Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly presentations.

Despite their hidden gems, Pivot Tables are feared by more than 95% of Excel users worldwide.

Why is that?

In legacy versions of Excel, Pivot Tables were hidden deep inside the menu tabs and there was never any instructions on how to use its rich features.  Sure there are plenty of books out there but who has the time to muddle through pages of highly technical literature?

Well, I have!

I have spent the last 12 months reading most of the Pivot Table books available on Amazon, searching through articles and video tutorials online to come up with this comprehensive but short 1 hour webinar tutorial.

In this Excel Pivot Table tutorial you will learn the most important tools within a Pivot Table for Microsoft Excel 2016, 2013, 2010 or 2007  – for Beginners or Advanced users.   I am using Excel 2010 in this tutorial but you can also apply what I teach in Excel versions 2007, 2013 and 2016.

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 Excel Dashboards and get noticed by top management & prospective employers.

Join this free 1 hour Excel Pivot Table Webinar Training Course below & get better at Excel:

FreeMicrosoft Excel Pivot Tables Online Tutorial

 

In this free Excel Pivot Table webinar training course you will learn the following:

*** CREATE AN EXCEL PIVOT TABLE ***
Tabular format
No gaps in the data
Use Excel Tables
Create a Pivot Table

*** FORMAT A PIVOT TABLE ***
Refresh a Pivot Table upon data change
Number formatting
Pivot Table design

*** SUMMARIZE VALUES BY: COUNT & AVERAGE ***
Summarize by Count
Summarize by Average

*** SHOW VALUES AS CALCULATIONS ***
Show Values As: Running Total In (Year To Date)
Show Values As: Difference From Previous Month

*** GROUPING A PIVOT TABLE ***
Grouping Numbers
Grouping Dates
Group by Text

*** INSERT AN EXCEL SLICER ***

*** INSERT A PIVOT CHART ***

*** CREATE AN INTERACTIVE EXCEL DASHBOARD ***

*** BONUS PIVOT TABLE TIPS ***
Value for empty cells
Auto fit column widths on update
Option to Refresh data
What’s due next month
Top 10
Expand Report filter to new worksheets

 

JOIN OUR  FREE EXCEL PIVOT TABLE WEBINAR TRAINING COURSE NOW >>

Free Microsoft Excel Pivot Tables Online Tutorial

 

Feel free to leave a comment below if you have any queries about this Pivot Table tutorial or Excel in general, I am here to help you 🙂

To Your Success!

 

JOHN MICHALOUDIS

Chief Inspirational Officer

MyExcelOnline

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column. Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet. The best layout to use is either the Outli...
Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
Group By Month With Excel Pivot Tables Before I was a Pivot Table guru, I had to get individual rows of daily sales and group them into a report showing the monthly sales during the year. Grouping these would take a ton of effort using Formulas: Extracting the month and year from each transactional date; Th...
Pivot Table Report Layouts Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form. You can choose from each layout by clicking in the Pivot Table and going to PivotTable Tools > Design > Report Layouts They each have their advantages and disadvanta...