Udemy

Excel Mastery: Formulas and Functions

Name: Excel Mastery: Formulas and Functions
Availability: InStock
Rating: 4.5 (192 reviews)

4.5(192)3k studentsINTERMEDIATE

Korshub's take

What You'll Get

This course builds Excel formula skills from the ground up across two structured sections. The first covers foundations — writing simple formulas, relative versus absolute referencing, named ranges, and aggregate functions like SUMIF and COUNTIFS for conditional analysis.

The second section moves into the functions used daily by real spreadsheet builders: eleven of the most utilized Excel functions, splitting text across columns, removing duplicates, the IF statement for conditional logic, and lookup functions including XLOOKUP, VLOOKUP, and INDEX/MATCH.

Who It's For

Intermediate Excel users who already know the basics and want to move from simple formulas to confident, efficient data analysis — whether for personal finance, business reporting, or general spreadsheet work.

Key Takeaways

Relative vs. absolute referencing and named ranges
Conditional aggregate functions like SUMIF and COUNTIFS
Lookup functions: XLOOKUP, VLOOKUP, and INDEX/MATCH

About this course

In this course, you'll gain comprehensive knowledge to become proficient in writing formulas and using functions in Excel.

Formulas Section 1:

Basics: We'll start with the basics, focusing on writing simple formulas. This foundation is crucial for understanding more complex functions later on.
Relative and Absolute Referencing: You'll learn these key concepts, which are essential for creating larger and more intricate spreadsheets. Knowing when to use relative versus absolute references can make your formulas more dynamic and accurate.
Named Ranges: Discover how named ranges can save time and make your spreadsheets easier to maintain. Named ranges not only enhance readability but also simplify formula creation and management.
Aggregate Functions: We’ll cover essential aggregate functions, including IF and IFS functions (SUMIF, COUNTIFS, etc.). These functions are the workhorses for analyzing groups of data in various ways, allowing you to perform conditional calculations efficiently.

Formulas Section 2:

Most Utilized Functions: Begin with an introduction to 11 of the most utilized functions in Excel, plus one additional function for fun. These functions are fundamental for data analysis and manipulation.
Text Splitting and Duplicate Removal: Learn how to split text from one column into many, a useful skill for cleaning and organizing data. Additionally, we’ll demonstrate how to remove duplicates, ensuring your datasets are accurate and streamlined.
IF Statement: Understand the versatile IF statement, which allows you to perform different actions based on specified criteria. This function is indispensable for creating logical tests and conditional outcomes in your spreadsheets.
Lookup Functions: Delve into crucial lookup functions such as XLOOKUP, VLOOKUP, and INDEXMATCH. These functions are essential for finding and retrieving data from large datasets. While XLOOKUP is the recommended go-to for its versatility and ease of use, VLOOKUP and INDEXMATCH remain important for ensuring compatibility with older spreadsheets.

By the end of this course, you'll have the confidence and skills to master formulas and functions in Excel. Whether you're managing personal finances, handling business data, or conducting complex analyses, you'll be equipped to tackle any challenge Excel throws your way.