This comprehensive Excel course by Kevin Stratvert is focused entirely on mastering formulas and functions in Microsoft Excel. It is designed for beginners and intermediate users who want to build strong analytical skills using Excel’s most powerful tools.

The course starts with the fundamentals of creating and editing formulas, understanding cell references, and using relative and absolute references correctly. You will also learn how to use the fill handle, work across multiple sheets, and manage named ranges.

It then covers essential Excel functions such as SUM, AVERAGE, MIN, MAX, COUNT, and COUNTIF, along with advanced statistical and logical functions. You will also explore powerful text functions like CONCAT, TEXTJOIN, LEFT, RIGHT, MID, and TRIM for data cleaning and manipulation.

A major focus is placed on logical functions such as IF, AND, OR, nested IFs, and IFS for decision-making in spreadsheets. You will also learn lookup functions including VLOOKUP and XLOOKUP for retrieving data efficiently.

By the end of this course, you will have a strong understanding of Excel formulas and functions, enabling you to perform data analysis, automate calculations, and solve real-world spreadsheet problems effectively.