Microsoft Excel Formulas and Functions: Beginner to Advanced

Name: Microsoft Excel Formulas and Functions: Beginner to Advanced
Rating: 4.0 (21 reviews)

From Beginner to Advanced: Learn Microsoft Excel Formulas and Functions to Analyze Data, Create Powerful Calculations.

Created byLogic Labs

Last updated 1/2026

English

What you'll learn

Syntax of Excel Functions
Relative & Absolute Cell References
Most Common Excel Error
Show Formula, Evaluate Formula & Error Checking
Excel Shortcut Keys
AND, OR, NOT & IF & IF Error Functions
Nesting Multiple IF Statements
SMALL, LARGE, Rank, Percentrank, Percentile, RAND & RANDBETWEEN Functions
All of SUM, COUNT Functions
LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP Functions
Upper, Lower, Proper and Trim Function
Find, Search, Substitute & Replace
NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE & SECOND
calculate Age using YEARFRAC
Combining SORT, FILTER & UNIQUE
Combine the SORT, UNIQUE, and COUNT functions
Drop-Down Lists with SORT, UNIQUE & No Blanks
Unique Drop Down Lists that Automatically Update with New Values
RANDARRAY, FREQUENCY and TRANSPOSE Functions
And More.......

Course content

1 section • 55 lectures • 6h 35m total length

Syntax of Excel Functions9:06
Relative & Absolute Cell References5:21
Most Common Excel Error12:17
Show Formula, Evaluate Formula & Error Checking7:05
Excel Shortcut Keys12:39
Save Ttime with Excel Function Shortcuts7:17
AND & OR Functions7:01
NOT & IF Erorrs3:45
IF Functions4:38
SMALL and LARGE Functions6:47
Rank, Percentrank & Percentile Functions7:19
RAND & RANDBETWEEN Functions5:09
Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS8:15
Dynamic Dashboard with COUNTIFS & SUMIFS12:43
SUMPRODUCT vs COUNTIF7:13
Named Ranges5:00
Counting Rows & Columns5:13
Exact Function4:54
Dynamically LOOKUP Function10:17
VLookup to Return Multiple Matches9:42
IFERROR & VLOOKUP7:00
Vlookup with Exact Match6:06
VLookup Approximate Match5:51
Combining Vlookup and Match Functions8:48
Vlookup with Duplicate Entries7:35
XLOOKUP Functions9:29
CHOOSE Functions3:19
OFFSET Functions6:33
Upper, Lower, Proper and Trim Functions6:44
Concatenate a Date with Text4:42
LEFT, MID, RIGHT, LEN & FIND8:55
Entering Text Values6:43
Find, Search, Substitute & Replace8:09
Combining RIGHT, LEN, and SEARCH5:06
Substitute function to replace characters4:35
NOW, TODAY, YEAR, MONTH, DAY, HOUR, MINUTE & SECOND7:55
Calculating the Month Start or End with EOMONTH7:36
Calculate Age Using YEARFRAC4:43
WEEKDAY, WORKDAY & NETWORKDAYS6:54
Highlighting Alternative Rows Using the MOD Function6:27
Conditional Formatting on a Cell Based on Another Cell's Value5:28
Formatting Cells by Using Text Functions and Logical Operators6:48
SORT and SORTBY Functions12:28
FILTER Function11:09
UNIQUE Function7:26
Combining SORT, FILTER & UNIQUE Functions6:47
Drop-Down Lists with SORT, UNIQUE & No Blanks8:32
Unique Drop Down Lists that Automatically Update with New Values3:50
Advanced Conditional Formatting4:43
SEQUENCE Function8:20
Entering Excel Dynamic Arrays With VBA5:50
RANDARRAY Function6:14
FREQUENCY Function8:37
TRANSPOSE Function5:01
Create an Interactive Top N Report in Excel8:56

Requirements

No Microsoft Excel experience needed

Description

Unlock the full power of Excel with Microsoft Excel Formulas and Functions: Beginner to Advanced. Formulas and Functions are the heart of Excel, allowing you to analyze data, automate calculations, and make smarter, faster decisions. This course is designed to take you from a complete beginner to an advanced user capable of handling complex datasets with confidence.

I start with the basics, ensuring you understand how formulas work, how to reference cells, and how to perform simple calculations. You’ll learn essential functions like SUM, AVERAGE, and COUNT, and see how they can make your spreadsheets more powerful and efficient.

Once you’re comfortable with the basics, we’ll dive into intermediate functions such as IF statements, VLOOKUP, HLOOKUP, and text functions. You’ll learn how to combine functions to solve real-world problems and create dynamic formulas that adjust automatically as your data changes.

As we progress, I cover advanced topics including nested formulas, logical functions, date and time functions, and error handling techniques. You’ll also discover array formulas and dynamic functions that allow you to manipulate large datasets and extract meaningful insights quickly.

Efficiency is key in Excel, and this course is packed with tips, tricks, and shortcuts to save you time. You’ll learn keyboard shortcuts, formula auditing tools, and strategies for troubleshooting errors so that you can work faster and more accurately.

Hands-on practice is at the core of this course. Each lesson includes real-world examples and exercises so you can apply what you learn immediately. By practicing as you go, you’ll gain confidence and be ready to tackle your own Excel projects effectively.

This course is designed for learners of all skill levels. Beginners will gain a solid foundation in formulas and functions, while intermediate and advanced users will find valuable techniques to enhance their productivity and analytical skills. No matter your experience, you’ll leave with practical, immediately usable Excel skills.

By the end of this course, you’ll be able to create complex formulas, combine multiple functions efficiently, and automate repetitive tasks with ease. You’ll be able to analyze data faster, create professional reports, and make data-driven decisions with confidence.

Enroll in Microsoft Excel Formulas and Functions: Beginner to Advanced today and start building smarter, faster, and more powerful spreadsheets!

Who this course is for:

Anyone dealing with business reports, data entry, or data organization
Anyone who wants to master functions quickly and effectively
Students, professionals, and Excel beginners looking to improve their formula skills
Job seekers preparing for interviews that require Excel knowledge