418,099 views 249 on YTPak
1,595 39

Published on 09 Jun 2015 | about 1 year ago

In this Excel Pivot Table tutorial you will learn the most important tools within a Pivot Table for Microsoft Excel 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 and 2013.
DOWNLOAD THE FREE EXCEL WORKBOOKS FROM THIS VIDEO: myexcelonline.com/blog/ytptwebinar *** SIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: myexcelonline.com/blog/signup

To access more than 200+ Excel Pivot Table tutorials click to view on my website: www.myexcelonline.com/107-2.html

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 A 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 A PIVOT TABLE ***
28:30 Grouping Numbers
30:40 Grouping Dates
33:40 Group by Text

35:10 *** INSERT AN EXCEL SLICER ***

39:25 *** INSERT A 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

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

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


Comment and ask Questions about this video below and I will get back to you with the answer!

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 :)

Loading related videos...