Beginner module
Syllabus covered
Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)
Excel Cell Reference: Absolute, Relative or Mixed?
Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
Excel Hack: Copy Formula Without Changing Cell References (or Without File References)
How to set Default Workbook Theme in Excel and how this could help you save time
Excel Filter Basics (for quick data analysis)
Advanced Excel Filter (And, Or, Between conditions for criteria range)
Data Validation in Excel – should you include these in your files?
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
Intermediate module
Syllabus covered
3 Handy Excel Chart Tips You Might Have Missed
Excel Header & Footer (& Quickly Copy to other Sheets)
Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)
3 Methods to Unhide All Sheets in Excel (& how to hide)
Excel’s Find and Replace (surprising features)
All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More
Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)
Better Excel Presentations: Increase Font Size of Formula Bar
Advanced module
Syllabus covered
Change CASE of text in Excel (3 ways including NO Formulas)
Why you SHOULD be USING Custom Number Formatting in Excel
Lock Cells & Protect Excel Worksheet – EVEN by Cell Color!
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)
The QUICKEST & EASIEST Way to Work with TEXT in Excel
Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT
Excel Simple Dependent Drop down List based on numbers (Index without match)
Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List
Excel Dependent Drop Down List with Tabular Data without Named Ranges
Expert module
Syllabus covered
Excel: Extract unique items for dynamic data validation drop down list
Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)
Data Validation in Excel – should you include these in your files?
Excel Custom Data Validation (Use formulas to check for text, numbers & length)
Smart Dep. Drop-Down Lists in Excel: Expandable & Exclude Blank Cells
Excel Dynamic Arrays (How they will change EVERYTHING!)
This Excel Dependent Combo Box Solves an Annoying Problem (you’ve probably had this)
Reset Dependent Drop-down in Excel (with a tiny bit of VBA)
Reset Dependent Drop-down in Excel (with a tiny bit of VBA)