Pragmatic Excel - Pivot Tables Package
Many users shy away from pivot tables, thinking that specialized knowledge is required. In fact, pivot tables are one of the easiest and best features to use in Excel, as long as you follow a few simple ground rules. In no time you'll be transforming staid and/or overwhelming data sets into ...
On demand, 6 hour(s)
In the introductory courses, David will take you through the basics of creating and using pivot tables.
The intermediate course takes you beyond the basics of pivot tables, which are a report writing feature in Microsoft Excel. You'll see how to transform unwieldy reports into pivot table-ready lists. David will then show how you can drill down into the details behind a pivot table, as well as prevent others from doing so. You'll also see three different ways to perform calculations based on data within pivot tables, in addition to using Slicers and Timelines to filter pivot table data. The presentation concludes with a discussion of pivot charts in Excel.
Finally, in the advanced course, you’ll learn how to extract data from Microsoft Access databases and other sources, minimize repetitive steps in Excel by creating keyboard shortcuts, and adapt simple macros that can be recorded. In addition, David discusses several helpful Excel features, including the Table feature, PivotTable feature, Slicer feature, Linked Picture feature, the PowerPivot feature, and others.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.