Excel with Excel Pivot Tables!

Excel with the Most Comprehensive Microsoft Excel Pivot Table Course for Excel 2007, Excel 2010, Excel 2013 & Excel 2016
4.4 (480 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
17,053 students enrolled
$190
Take This Course
  • Lectures 242
  • Contents Video: 10 hours
    Other: 10 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2014 English

Course Description

***** THE MOST TUTORIALS IN ANY OF THE UDEMY EXCEL COURSES *****

***** OVER 10,000 SATISFIED STUDENTS JOINED IN LESS THAN 12 MONTHS *****

***** THE NO.1 RANKED EXCEL COURSE ON UDEMY  *****

"This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money" - James, Udemy Student

This is the Ultimate Excel Pivot Table course which has 217 short and precise tutorials. It also expands in to Charts, Conditional Formatting, Macros and Excel Shortcut Tips!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010 or 2013. There are 14 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers. The course is just over 9 hours long so you can become an awesome analyst and advanced Excel user within 1 week!

In this course there are free downloadable Excel workbooks for each tutorial, a BONUS Pivot Table Cheat Sheet, an Excel Tutorial Tracker and my Top 20 Excel Shortcuts in an animated gif format.

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way. These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc.....then this is the course for YOU!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and I'll answer them personally within the day!

I am so confident that you will get lots of value from this course that you can take it for the full 30 days, study it and apply it to your work to see the results. If you're not 100% satisfied, I am more than happy to refund the full purchase amount!

So go ahead and learn from the following in depth Pivot table subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...

1 CUSTOMISE YOUR PIVOT TABLE 2 VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 3 VALUE FIELD SETTINGS > SHOW VALUES AS 4 GROUPING 5 SORT 6 FILTER 7 SLICERS (NEW IN EXCEL 2010) 8 CALCULATED FIELDS & ITEMS 9 PIVOT CHARTS 10 CONDITIONAL FORMATTING PIVOT TABLES 11 GETPIVOTDATA formula 12 MACROS 13 DATA MANAGEMENT 14 BONUS VIDEOS

What are the requirements?

  • Excel 2007, 2010 & 2013. This course was recorded using Excel 2010 but all the concepts taught are compatible with Excel 2013 and 2007.
  • Some concepts are not available in Excel 2007, like Slicers and some Pivot table calculations, but this is highlighted in the Course Outline
  • Microsoft & Apple compatible

What am I going to get from this course?

  • You will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers

What is the target audience?

  • New users, beginners, intermediates and advanced Excel users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

01:21

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

You can follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table.

You can then follow along as I go through the instructions in each tutorial.

Thank You,

John

Article

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

COURSE TRACKER EXCEL WORKBOOK
Preview
Article
BONUS: EXCEL PIVOT TABLE CHEAT SHEET
1 page
BONUS: TOP 20 EXCEL SHORTCUTS
Preview
Article
1 page

Visit my brand new Excel blog where I have short 1 minute tutorials & downloadable free example workbooks from all topics like Formulas, Pivot Tables, Data Analysis, Charts, Macros & Shortcuts.

Also don't forget to subscribe so you can receive the Free Weekly Excel Lesson Plans!

Here is the link >>> http://www.myexcelonline.com/blog

1 page

Dear Valued Student,


I have just launched my new Excel Podcast show where I interview fellow Excel experts to get their insights.

This podcast will teach beginner & intermediate Microsoft Excel users the different Excel tools like: Formulas, Pivot Tables, Charting, Analysis, Macros, VBA, Dashboards, Power BI, Add-Ins, Shortcuts plus much more.


I interview Excel MVPs and experts around the world to share their Excel insights, knowledge, tips and tricks that will get you on the way to becoming an advanced Excel user, just like them.


Here is the link for you to listen now: http://www.myexcelonline.com/podcast/


Also, please leave an honest review for The MyExcelOnline Podcast on iTunes here:

http://www.myexcelonline.com/podcast/itune


Ratings and reviews are extremely helpful and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.


Don't forget to subscribe to the show on iTunes to get automatic updates so you don't miss out on these awesome interviews and Excel insights!


Keep Excelling,


John Michaloudis

Section 1: CUSTOMIZING YOUR EXCEL PIVOT TABLE
Article

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,


JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

02:25

Customize your Excel Pivot Table - Tabular Format

02:30

Customize your Excel Pivot Table - No Gaps

01:27

Customize your Excel Pivot Table - Formatting

02:46

Customize your Excel Pivot Table - Excel Tables

02:18

Customize your Excel Pivot Table - Clean Your Data Set

03:22

Customize your Excel Pivot Table - Insert a Pivot Table

01:40

Customize your Excel Pivot Table - Field List, Activate, Move

05:26

Customize your Excel Pivot Table - Field List & Areas

01:42

Customize your Excel Pivot Table - Drill down to audit

00:45

Customize your Excel Pivot Table - Sort Field List

00:53

Customize your Excel Pivot Table - Double click on a label

00:55

Customize your Excel Pivot Table - Defer layout update 

01:01

Customize your Excel Pivot Table - Pivot Cache

01:20

Customize your Excel Pivot Table - Refresh

02:17

Customize your Excel Pivot Table - Refresh All

04:59

Customize your Excel Pivot Table - Refresh External Data

02:27

Customize your Excel Pivot Table - Import from Access

03:10

Customize your Microsoft Excel Pivot Table - Change Data Source

01:17

Customize your Microsoft Excel Pivot Table - Clear Filters & Pivot

03:15

Customize your Microsoft Excel Pivot Table - Select & Format

01:01

Customize your Microsoft Excel Pivot Table - Move a Pivot Table

03:43

Customize your Microsoft Excel Pivot Table - Pivot Table Styles

04:13

Customize your Microsoft Excel Pivot Table - Customizing a Pivot Table

01:27

Customize your Microsoft Excel Pivot Table - Customized Pivot Table Styles

00:55

Customize your Microsoft Excel Pivot Table - Subtotals

01:01

Customize your Microsoft Excel Pivot Table - Grand Totals

02:48

Customize your Microsoft Excel Pivot Table - Report Layouts

00:40

Customize your Microsoft Excel Pivot Table - Blank Rows

01:08

Customize your Microsoft Excel Pivot Table - Classic Pivot Table Layout

04:26

Customize your Microsoft Excel Pivot Table - Expand & Collapse buttons

02:39

Customize your Microsoft Excel Pivot Table - Move & Remove Field Items

00:27

Customize your Microsoft Excel Pivot Table - Show & Hide Field List

00:27

Customize your Microsoft Excel Pivot Table - Show & Hide Field Headers

01:10

Customize your Microsoft Excel Pivot Table - Change from Count to Sum

01:42

Customize your Microsoft Excel Pivot Table - Number Formatting

02:16

Customize your Microsoft Excel Pivot Table - Field Name formatting

01:29

Customize your Microsoft Excel Pivot Table - Predetermined number formatting

00:52

Customize your Microsoft Excel Pivot Table - Change Sum values

01:00

Customize your Microsoft Excel Pivot Table - Indent Rows

01:25

Customize your Microsoft Excel Pivot Table - Change Report Filter layout

00:49

Customize your Microsoft Excel Pivot Table - Format error values

01:27

Customize your Microsoft Excel Pivot Table - Format empty cells

00:53

Customize your Microsoft Excel Pivot Table - Fix column widths

00:56

Customize your Microsoft Excel Pivot Table - Automatic Pivot Table Refresh

01:20

Customize your Microsoft Excel Pivot Table - Print a Pivot Table 

02:23

Customize your Microsoft Excel Pivot Table - Show Report Filter items on multiple sheets

1 question

What button do you need to press to update a Pivot Table

Section 2: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
Article

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

01:44

Summarize your Microsoft Excel Pivot Table - Multiple Subtotals

02:27

Summarize your Microsoft Excel Pivot Table - Count

02:43

Summarize your Microsoft Excel Pivot Table - Average

02:03

Summarize your Microsoft Excel Pivot Table - Maximum

01:26

Summarize your Microsoft Excel Pivot Table - Minimum

03:39

Summarize your Microsoft Excel Pivot Table - Product

02:26

Summarize your Microsoft Excel Pivot Table - Count Numbers

07:07

Summarize your Microsoft Excel Pivot Table - Standard Deviation

03:36

Summarize your Microsoft Excel Pivot Table - Variance Population

02:36

Summarize your Microsoft Excel Pivot Table - Show various Grand Totals

02:19

Summarize your Microsoft Excel Pivot Table - Shortcuts

06:00

Summarize your Microsoft Excel Pivot Table - See all Pivot Table items

02:36

Summarize your Microsoft Excel Pivot Table - Show a unique count

Recall the way to change a "Count Of" to a "Sum Of"
1 question
Section 3: VALUE FIELD SETTINGS > SHOW VALUES AS
Article

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

02:09

Summarize your Microsoft Excel Pivot Table - % of Grand Total

02:15

% of Column Total

01:55

Summarize your Microsoft Excel Pivot Table - % of Row Total

04:03

Summarize your Microsoft Excel Pivot Table - % Of

03:19

Summarize your Microsoft Excel Pivot Table - % of Parent Row Total (New in Excel 2013, Excel 2013 & Excel 2016)

02:23

Summarize your Microsoft Excel Pivot Table - % of Parent Column Total (New in Excel 2013, Excel 2013 & Excel 2016)

02:52

Summarize your Microsoft Excel Pivot Table - % of Parent Total (New in Excel 2010, Excel 2013 & Excel 2016)

04:54

Summarize your Microsoft Excel Pivot Table - Difference From

04:18

Summarize your Microsoft Excel Pivot Table - % Difference From

02:20

Summarize your Microsoft Excel Pivot Table - Running Total In

02:58

Summarize your Microsoft Excel Pivot Table - % Running Total In (New in Excel 2010, Excel 2013 & Excel 2016)

02:14

Summarize your Microsoft Excel Pivot Table - Rank Smallest to Largest (New in Excel 2010, Excel 2013 & Excel 2016)

02:21

Summarize your Microsoft Excel Pivot Table - Rank Largest to Smallest (New in Excel 2010, Excel 2013 & Excel 2016)

03:45

Summarize your Microsoft Excel Pivot Table - Index

01:16

Summarize your Microsoft Excel Pivot Table - Shortcuts

02:38

Summarize your Microsoft Excel Pivot Table - % of Revenue Margins 

04:43

Summarize your Microsoft Excel Pivot Table - Actual v Plan variance report

Identify the steps to showing the values as a Year to Date accumulation
1 question
Section 4: GROUPING
Article

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

02:45

Group your Microsoft Excel Pivot Table - by Date

01:51

Group your Microsoft Excel Pivot Table - by Months

01:48

Group your Microsoft Excel Pivot Table - by Quarters & Years

03:19

Group your Microsoft Excel Pivot Table - by Sales ranges

02:16

Group your Microsoft Excel Pivot Table - by Text fields

01:45

Group your Microsoft Excel Pivot Table - by Time

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

John Michaloudis, Founder of MyExcelOnline | 25,000+ Excel Students

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline.  I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

Join one of my courses and get ready to change your life!

Ready to start learning?
Take This Course