This Intermediate Microsoft Excel course is suitable for all students or professionals who would like to become an expert in Excel formulas. It is very important to be familiar with those formulas that are covered in this course if you would like to have an outstanding job in finance.

My goal is to help you to become and expert in Microsoft Excel.

By the end of this course, you will be able to

– use all relevant shortcuts in Excel
– understand and use the Vlookup, Hlookup formulas
– create dynamic lookup functions by the Index and Match function
– use simple and very complex, nested IF functions
– leverage the knowledge of OR, AND functions in IF statements
– count items in Excel based on different criteria
– replace and substitute words, characters by using formulas
– use error handling in formulas
– modify text and extract required data from it
– use different data functions (end of month, date difference, networking days)

All sections contain a homework Excel file that has many exercises for every topic that have been covered in the Intermediate Excel Formulas course. Furthermore, the solutions are also provided in the same file, so if you do not remember the formulas, you will still be able to use some hints from the solutions.

CURRICULUM

-EXCEL SHORTCUTS AND TIME SAVERS
Excel shortcuts and time savers – Part 1
Excel shortcuts and time savers – Part 2
Formula back tracing and shortcuts

-VLOOKUP AND HLOOKUP FUNCTIONS
Vlookup and Hlookup formulas
Nested, double Vlookup
Nested Vlookup and Hlookup
Vlookup with multiple criteria
HOMEWORK: Vlookup, Hlookup

-INDEX AND MATCH FUNCTIONS
Index-Match and Vlookup-Match
Complex Index-Match exercise
BONUS: Extra Functions of Index-Match

-HOMEWORK: Index Match
IF AND NESTED IF FUNCTIONS
IF and nested IF functions
IF statement with OR and AND
IF with LIST of criteria
IF in complex real daily tasks
HOMEWORK: IF, nested IF, OR and AND

-COUNT AND COUNTIF FUNCTIONS
Count and CountIF functions – part 1
Count and CountIF functions – part 2
HOMEWORK: CountIF and SumIF

-REPLACE AND SUBSTITUTE FUNCTIONS
Value, Replace and Substitute functions
HOMEWORK: Replace and Substitute
ERROR HANDLING IN FORMULAS
Error handling (ISerror, IFerror)
HOMEWORK: Error handling

-ALL ABOUT TEXT FORMULAS
Text formulas – (Len, Left, Right, Mid, Trim, Clean, T, Find, Search)
Text formulas – (Concatenations, Upper, Lower, Proper)
ADVANCED Text formulas – complex exercises
HOMEWORK: Text formulas

-DATE FUNCTIONS
Most important Date functions
HOMEWORK: Date functions