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)

View

Leave a Reply

Your email address will not be published. Required fields are marked *