Microsoft Excel: Mastering Excel Functions and Formulas

Name: Microsoft Excel: Mastering Excel Functions and Formulas
Rating: 4.7 (83 reviews)

Advance your Excel knowledge with Excel formulas & Excel Functions (Free Excel Formulas Practice Workbooks Included)

Created byAhmed Oyelowo, Foresight BI & Analytics. 100,000+ Learners

Last updated 3/2025

English

What you'll learn

Apply 50+ essential Microsoft Excel functions to solve common business, reporting, and data analysis problems
Combine multiple Excel formulas to create more powerful calculations for real-world spreadsheet tasks
Use aggregate functions such as SUM, AVERAGE, MIN, MAX, SUBTOTAL, and AGGREGATE to summarize data accurately
Apply Excel text functions such as LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, and TRIM to clean and transform text data
Use Excel date functions such as EOMONTH, EDATE, DATEDIF, TODAY, and YEAR to analyze dates and timelines
Perform data lookups using VLOOKUP, XLOOKUP, INDEX MATCH, and other lookup functions in Microsoft Excel
Build logical formulas using IF, AND, OR, IFS, and nested IF statements to automate spreadsheet decisions
Analyze data with Excel functions such as SUMIF, COUNTIF, AVERAGEIF, ROUND
Troubleshoot common Excel formula errors and correct mistakes in business calculations and reports
Create practical Excel formulas for cleaning data, summarizing records, performing lookups, and preparing reports

Course content

8 sections • 59 lectures • 4h 21m total length

Before you begin0:24
Download Class Demo files0:03
Introduction4:14
Understanding Function Syntax5:32
Understanding Expressions (1)5:29
Understanding Expressions (2)0:53
Introduction to Excel aggregate functions7:03
Master Excel aggregate functions to summarize data using sum, average, max, min, large, and small. Learn to reference ranges, insert functions with the tab key, and adjust ranges by dragging.
Using Aggregate Functions in Excel (2)4:32
Replicating formulas and using the AUTOSUM feature smartly5:45
Using the SUBTOTAL function for filtered data5:07
Counting data ranges3:34
Practice Assignment 1

Converting characters between cases in Excel3:04
Master Excel text functions to convert text case using proper, lower, and upper to standardize names and phrases.
Extracting characters from beginning and ending of texts with LEFT and RIGHT5:10
Using MID to extract characters and TRIM to remove extra spaces4:21
Combining texts with CONCATENATE, CONCAT and TEXTJOIN functions7:24
Coding and decoding between characters and numbers with UNICHAR and UNICODE3:10
Counting characters with LEN and finding position with FIND and SEARCH4:41
Practice Assignment 2

Introduction to DATE functions4:32
Extracting DAY, MONTH and YEAR from a Date1:56
Extracting Day of Week and Week of year with WEEKDAY and WEEKNUM4:36
Master Excel weekday and weeknum functions to extract a date’s day of week and its week number, choosing start days and return types with practical date examples.
Using TEXT function to display dates in text formats7:15
Using DATEVALUE to convert date in text format to proper date format in excel2:48
Getting the endo of month date with EOMONTH function in Excel3:08
Master the EOMONTH function in Excel to obtain the end date of any month from a start date and offset by a specified number of months.
Moving periods between dates with EDATE function in Excel2:30
Using NETWORKDAYS & NETWORKDAYS.INTL to get number of working days in excel5:00
Learn to calculate working days between dates using networkdays and networkdays.intl, adjust weekends and holidays, and apply country-specific weekend patterns.
Introduction to DATEDIF function in Excel4:28
Calculating different units of age with DATEDIF6:47
Practice Assignment 3

Introduction to Logical Operators in Excel2:02
Using COUNTIF function to count number of value occurrences within a range7:27
Using COUNTIF function to count number of value occurrences within a range (2)3:13
Apply the countif function to count missing files across yearly ranges, using dynamic cell ranges and a missing criterion to tally file status for each year.
Using COUNTIFS to count values in ranges with multiple criteria4:32
Summarizing data values based on a criteria with SUMIF and AVERAGEIF5:31
Summarizing data values based on multiple criteria with SUMIFS2:09
Practice Assignment 5

Introduction to logical functions in Excel3:59
Using the IF function to write conditional expressions (part 1)2:58
Using the IF function to write conditional expressions (part 2)4:09
Understanding the AND & OR functions in Excel3:08
Combining IF with AND to write an expression based on multiple conditions3:55
Combining IF with OR to write an expression based on multiple conditions5:17
Using nested IF4:42

Introduction to VLOOKUP function5:21
Learn to use the VLOOKUP function to retrieve data by matching an ID in the first column, with a defined table array, column index, and exact match.
Using the VLOOKUP function to return values matched from a data range (1)3:45
Using the VLOOKUP function to return values matched from a data range (2)3:37
Introduction to MATCH function in Excel5:32
Automating VLOOKUP column index with MATCH function5:54
Handling unfound values by combing VLOOKUP with IFERROR function3:06
Using the VLOOKUP function to return values matched from a data range (3)3:56
Introduction to XLOOKUP function2:53
Learn how to use xlookup to perform lookups across any column, defining lookup value, lookup array, and return array, with optional if not found and match mode.
Introduction to INDEX function2:52
Explore how the index function retrieves values from a chosen array, using specified row and column numbers. See how index pairs with match to perform a lookup.
Automating Row or Column number in INDEX with the MATCH function2:57
Practice Assignment 6

Requirements

Familiarity with basic excel
Microsoft Excel for Windows

Description

Microsoft Excel: Mastering Excel Functions and Formulas (Free Excel Formulas Practice Workbooks Included)

This excel formulas & functions course is taught by Ahmed Oyelowo, who is a 5-time Microsoft MVP, Microsoft Certified Trainer since 2018 and also a Microsoft Office Specialist (Excel Expert).

In this course, you will learn, with practical examples, how to use over 50 everyday Excel functions to write Formulas in Excel

You will also be learning an easy way of combining multiple Excel functions inside a single Excel formula.

The course comes with 2 sets of Excel Workbook files.

One used by the instructor which you should use to follow along in the lessons and
The other one for your own practice. The practice file will automatically mark you once you have completed the exercises in there.

You will also learn the logic of Cell Referencing, which is the back bone of writing accurate formulas when you need to replicate formulas across multiple cells in Excel.

What functions will you learn in this course?

Aggregate functions in Excel
1. SUM
2. AVERAGE
3. COUNT
4. COUNTA
5. LARGE
6. SMALL
7. MIN
8. MAX
Text functions in Excel
1. LEFT
2. RIGHT
3. MID
4. FIND
5. SEARCH
6. LEN
7. UPPER
8. LOWER
9. CONCATENATE
10. CONCAT
11. TEXTJOIN
Date functions in Excel
1. DATE
2. DAY
3. MONTH
4. YEAR
5. EDATE
6. EOMONTH
7. NETWORKDAYS
8. NETWORKDAYS.INTL
9. WEEKNUM
10. WEEKDAY
11. DATEDIF
Data Analysis Function in Excel
1. COUNTIF
2. SUMIF
3. COUNTIFS
4. AVERAGEIF
5. SUMIFS
LOGICAL Functions in Excel
1. IF
2. AND
3. OR
Lookup functions in Excel
1. VLOOKUP
2. XLOOKUP
3. MATCH
4. INDEX

Who this course is for:

Beginner to intermediate Excel users who want to master essential Microsoft Excel formulas and functions
Professionals who use Excel at work and want to become faster, more accurate, and more confident with spreadsheets
Students, graduates, and job seekers who want practical Excel skills for workplace readiness and career growth
Aspiring data analysts who want to build a strong foundation in Excel formulas, functions, and data analysis
Business users who need Excel for reporting, calculations, data cleaning, lookups, and decision-making
Finance, accounting, HR, sales, marketing, operations, and administrative professionals who work with data in Excel
Excel users who want to learn lookup, logical, text, date, math, statistical, and aggregate functions
Anyone who struggles with Excel formulas and wants a practical, step-by-step approach to understanding them
Small business owners and entrepreneurs who use Excel to track, calculate, summarize, and analyze business data
Learners who want to combine multiple Excel functions to solve real-world business and reporting problems
Beginner to intermediate Excel users who want to master essential formulas and functions for workplace tasks

Microsoft Excel: Mastering Excel Functions and Formulas

What you'll learn

Explore related topics

Course content

Introduction to writing formulas in Excel11 lectures • 43min

Working with Excel Text functions6 lectures • 28min

Working with Excel Date Functions10 lectures • 43min

Combining multiple functions in a single formula5 lectures • 30min

Understanding Cell Referencing in Excel4 lectures • 24min

Working with Maths, Statatistics and Data Analysis Functions in Excel6 lectures • 25min

Working with Logical Functions in Excel7 lectures • 28min

Using Lookup functions in Excel10 lectures • 40min

Requirements

Description

Who this course is for: