Unlock your inner Excel ninja!
At Excel Exposure, I understand just how little time you have and I am so glad you decided to stop by! My hope is to provide you with all the information you need to succeed in your job, personal business, or college career.
Newest Post: May 3rd, 2022 – The Top 5 Excel Podcasts You Should Listen To!
There are many hours of free lessons on the site, so feel free to dive right in…
Free Excel Training Starts Here!
Latest Post 12/10/2020:
Excel Templates for Budget Management
For the free course, I’d recommend checking out the Lesson Guide which lists the lessons in the ideal order for viewing, especially if you plan on going through the course start to finish.
Before watching the videos, make sure to download the Master Workbook full of great practice examples and tons of resources to follow along!
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
- 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