Beginner module

Syllabus covered

Excel Dynamic Arrays (How they will change EVERYTHING!)

Searchable Drop Down List in Excel (Very Easy with FILTER Function)

Intermediate module

Syllabus covered

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

ARE YOU READY for the NEW Excel?

Advanced module

Syllabus covered

Excel Array Formula: Count Rows with OR condition – SUMPRODUCT & FREQUENCY Functions (Part 1/3)

Excel Array Formula: Count Rows with OR Condition – Excel MMULT Function (Part 2/3)

Expert module

Syllabus covered

Excel Array Formula: Count Rows based on OR condition – Excel MMULT, INDIRECT Functions (Part 3/3)

View