When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Mastering Microsoft Excel Formulas
Advance your Excel knowledge with Excel formulas
This Course Includes
udemy
4.8 (38 reviews )
4.5 total hours 
english
Online - Self Paced
course
Udemy
About Mastering Microsoft Excel Formulas
This excel 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.
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
SUM
AVERAGE
COUNT
COUNTA
LARGE
SMALL
MIN
MAX
Text functions in Excel
LEFT
RIGHT
MID
FIND
SEARCH
LEN
UPPER
LOWER
CONCATENATE
CONCAT
TEXTJOIN
Date functions in Excel
DATE
DAY
MONTH
YEAR
EDATE
EOMONTH
NETWORKDAYS
NETWORKDAYS.INTL
WEEKNUM
WEEKDAY
DATEDIF
Data Analysis Function in Excel
COUNTIF
SUMIF
COUNTIFS
AVERAGEIF
SUMIFS
LOGICAL Functions in Excel
IF
AND
OR
Lookup functions in Excel
VLOOKUP
XLOOKUP
MATCH
INDEX
What You Will Learn?
- How to use 50+ everyday excel functions.
- How to combine multiple functions in Excel easily.
- Using Aggregate functions in excel.
- Using Text functions such as LEFT, CONCATENATE, TEXTJOIN etc.
- Using Date functions such as EOMONTH, EDATE, DATEDIF etc.
- Using Lookup functions such as VLOOKUP, XLOOKUP, INDEX&MATCH.
- Using Maths and Stats functions such as SUMIF, COUNTIF, AVERAGEIF etc.
- Using Logical functions such as IF, AND, OR etc.