Excel Exposure

Going through a rebrand. These links may be broken.
Go here for the paid course, the rest will be fixed shortly:
https://class.excelexposure.com/
Free Excel Lessons - Start Here:
Workbook & Reference – Video Lessons
- Beginner’s Introduction to Excel
- Basic Formatting Techniques
- Conditional Formatting
- Naming Ranges and Cells
- Auto-Filter and Advanced Data Filtering
- Introduction to Pivot Tables
- Advanced Pivot Tables – Round 1
- Advanced Pivot Tables – Round 2
- Creating and Designing Charts (including Sparklines)
- Data Validation with In-Cell Drop-Down List
- Formula Auditing & Formula Evaluation
- Cell Referencing – Absolute vs. Relative
- Five Powerful Excel Tips
- Error Checking and Data Monitoring
- Protecting and Hiding Information and Formulas
- Excel 2013: Data Model Tutorial
Function & Formula – Video Lessons
- Top 11 Most Used Excel Functions
- Math & Statistical Functions (e.g. SUM, AVERAGE)
- Lookup & Reference Functions (e.g. VLOOKUP, MATCH)
- Advanced VLOOKUP Examples
- Advanced INDEX & MATCH Lookup Examples
- Date & Time Functions (e.g. TODAY, MONTH)
- Text Functions (e.g. LEN, CONCATENATE)
- Logical Functions (e.g. IF, AND)
- Information Functions (e.g. CELL, ISNUMBER)
- Excel 2013: Real World Examples of New Functions
- Excel 2016: IFS Function
Macros / VBA – Video Lessons
- Introduction to Macros & VBA programming
- Learn by Doing: Intro to VBA via Adding Charts Example
- VBA Macro Walkthrough #1: Purchase Order Generator
- VBA Macro Walkthrough #2: Message Encoder & Decoder
- VBA Important Tips
Excel Tutorials, Tricks & Quick Tips (Non-Video Lessons)
- How to recover unsaved Excel Files
- Introduction to Power Pivot
- Introduction to Tables
- What-If Analysis
- Grouping and Ungrouping Rows / Columns
- Alternative to Merged Cells and How to Remove Gridlines
- Extract List From Data With Duplicate Values Removed
- Excel Book and Website Recommendation Links
- 7 Data Sorting Tips for Power Users
- Intro to Power BI – Part 1 / Part 2 / Part 3
- Introduction to Financial Modeling Part 1 / Part 2 / Part 3 / Part 4