504,684 views 293 on YTPak
2,242 56

#### Published on 09 Jun 2015 | over 2 years ago

REGISTER FOR OUR FREE EXCEL COURSE HERE: www.myexcelonline.com/107-5.html

DOWNLOAD THE FREE EXCEL WORKBOOKS FROM THIS VIDEO & BONUS PIVOT TABLE CHEAT SHEETS: myexcelonline.com/blog/ytptwebinar

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 Windows versions 2007, 2013 & 2016 and Excel Mac versions 2011 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.

You can jump to the following sections within this Excel tutorial by clicking on the time links below:

2:40 CREATE AN EXCEL PIVOT TABLE
3:14 Tabular format
4:13 No gaps in the data
4:48 Use Excel Tables
7:55 Create a Pivot Table

13:50 FORMAT AN EXCEL PIVOT TABLE
15:29 Refresh a Pivot Table upon data change
16:21 Number formatting
17:04 Pivot Table design

18:00 SUMMARIZE VALUES BY: COUNT & AVERAGE
18:20 Summarize by Count
18:35 Summarize by Average

20:30 SHOW VALUES AS CALCULATIONS
22:00 Show Values As: Running Total In (Year To Date)
24:55 Show Values As: Difference From Previous Month

28:10 GROUPING AN EXCEL PIVOT TABLE
28:30 Grouping Numbers
30:40 Grouping Dates
33:40 Group by Text

35:10 INSERT AN EXCEL SLICER

39:25 INSERT AN EXCEL PIVOT CHART

41:50 CREATE AN INTERACTIVE EXCEL DASHBOARD

46:00 BONUS PIVOT TABLE TIPS
46:27 Value for empty cells
46:54 Auto fit column widths on update
48:05 Option to Refresh data
49:00 What's due next month
49:56 Top 10
52:17 Expand Report filter to new worksheets

VIEW OUR FULL PIVOT TABLE COURSE HERE WITH 200+ TUTORIALS: www.myexcelonline.com/107-28.html

MyExcelOnline BLOG (300+ FREE Excel tutorials): www.myexcelonline.com/blog

MyExcelOnline PODCAST: www.myexcelonline.com/podcast
Get the Excel Insights From The Excel Experts!

If you enjoyed the video, please give a thumbs up, comment, share and do not forget to SUBSCRIBE to this channel to get my new Excel tutorials delivered straight to you! Thank You :)

Cheers,

JOHN MICHALOUDIS
CHIEF INSPIRATIONAL OFFICER
www.myexcelonline.com
www.myexcelonline.com/blog
www.myexcelonline.com/podcast
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.

Report video function is under development.