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 #2: Intermediate Level
-
Video Lesson: Logical Functions and Formulas
-
Master Workbook
-
Video Lesson: Lookup / Reference Functions
-
Video Lesson: Absolute & Relative Referencing
-
Video Lesson: Naming Ranges and Cells
-
Video Lesson: Data Validation
-
Video Lesson: Conditional Formatting in Excel
-
Video Lesson: Introduction to Pivot Tables
-
Video Lesson: Advanced Pivot Tables - Round 1
-
Video Lesson: Advanced Pivot Tables - Round 2
-
Video Lesson: Advanced Filtering in Excel
-
Video Lesson: Creating and Designing Charts
-
Video Lesson: Error Checking & Data Monitoring
-
Guest Excel Lesson: Introduction to Tables
-
What-If Analysis
-
Protecting and Hiding Information and Formulas