I’ve been taking some time to make sure my spreadsheet skills are up to date on the latest version of Excel. It is always good to explore some new features and practice some old techniques.
I just completed the Excel 2016 Pivot Tables in Depth class on Lynda.com and I certainly recommend this on-line class. This is an intermediate level class which presumes that you are already experienced with all the standard spreadsheet techniques and Excel methods and controls. The course covers the creating, managing, filtering, sorting, summarizing, formatting, printing, and displaying both Pivot Tables and Pivot Charts. It also touches on using macros with Pivot Tables and building Pivot Tables based on relational tables.
The course uses what I would call the “Tell, Show, and Follow” method. For each topic, there is a video lecture telling the importance of a specific tool or technique, including a demonstration of the technique within an Excel spreadsheet. A copy of the exact file is provided for the student to follow along performing the same technique on their own computer.
Curtis Frye has done a good job here. The lectures are flawlessly delivered. His diction is so clear that it is possible to accelerate the delivery rate to 1.5x and still clearly understand what is being presented. The on-screen time is 100% focused on the Excel tool, with excellent use of pointers, highlighting, and other visual cues. (I believe too many on-line classes waste screen time showing the presenter blather away in a poorly prepared “studio” space.)
The course incorporated 3.7 hours of video in 54 lectures, with 56 accompanying exercises (with files included.)
This course has no final exams, grades, or certifications.
(Image courtesy of jarmoluk at Pixabay)