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 Data Validation 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 capabilities and shortcomings of data validation within Excel 2016. It offers a few “best practices” for developing effective data validation techniques.
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.
Dennis Taylor has done a very 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 1.5 hours of video in 18 lectures, with 16 accompanying exercises (with files included.)
This course has no final exams, grades, or certifications.
(Image courtesy of jarmoluk at Pixabay)