Learn Excel Pivot Tables In 1 Hour!

May 8, 2015

In this Excel Pivot Table 2010 tutorial you will learn the basics of building a Pivot Table to more advanced Pivot Table commands like creating a Dashboard with Slicers and Pivot Charts.

DOWNLOAD EXCEL WORKBOOK: http://1drv.ms/1ElBsUL

Watch more free videos and view my comprehensive EXCEL PIVOT TABLE COURSE which has 200+ tutorials: http://www.myexcelonline.com/109-2.html

After this free tutorial you will be a able to use Excel Pivot Tables confidently at your work, make insightful business analysis and create interactive Management Reports & Dashboards.  This  will make you more important and extend the reach of your work to a lot more people than before, which means a greater opportunity for a promotion.

This Excel tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac)

Jump to the Pivot Table tutorial topic you want to view by clicking on the numbers below:

  2:40  CREATE A PIVOT TABLE;
14:20  FORMAT A PIVOT TABLE;
18:00  SUMMARIZE WITH VALUES;
20:30  SHOW VALUES AS YTD & DIFFERENCE FROM   PREVIOUS MONTH;
28:10  GROUPING;
35:15  SLICERS & PIVOT CHARTS & DASHBOARDS;
46:00  PIVOT TABLE TIPS;
55:40  XTREME PIVOT TABLE COURSE STRUCTURE

Download Course Syllabus: http://myexcelonline.com/descargas/xtreme-pivot-table-course-syllabus.pdf

SIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signup


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

Email me if you have any Excel queries: john@myexcelonline.com 
Watch Now:

Facebook Comments: