This path is based on content from ExcelExposure.com, a free online Excel training class designed to help you learn more about the features and functionality of Microsoft Excel. This course was designed for Microsoft Excel 2010, but many of the functions are the same for Excel 2013 and Excel 2016.
Microsoft Excel Guide #3: Advanced Level
-
Video Lesson: Information Functions in Excel
-
Video Lesson: Formula Auditing & Evaluation
-
Video Lesson: Advanced Lookup - Index & Match
-
Video Lesson: Five Powerful Excel Tips
-
Video Lesson: Introduction to Macros & VBA
-
Learn by Doing: Intro to VBA via Adding Charts Example
-
VBA Walkthrough #1: Purchase Order Generator
-
VBA Walkthrough #2: Message Encoder & Decoder