65
Welcome
Download the class files here
Welcome
Understanding Excel functions
Understanding Expressions (1)
Understanding Expressions (2)
Intro to aggregate functions
Using Aggregate Functions (2)
Replicating Formulas and Using the Autosum feature
Using the SUBTOTAL function
Counting ranges with COUNT and COUNTA functions
Practice Assignment 1
Converting texts to different cases with UPPER, LOWER and PROPER
Using LEFT and RIGHT to extract characters from start and end of text strings
Using MID to extract middle characters and TRIM to remove extra spaces
Combining texts with CONCATENATE, CONCAT and TEXTJOIN
Converting between numbers and characters with UNICODE and UNICHAR
Using LEN, FIND and SEARCH functions
Practice Assignment 2
Introduction to Date Functions
Extracting Day, Month and Year from Date with DAY, MONTH and YEAR
Extracting day of week and week of year with WEEKDAY and WEEKNUM
Using TEXT function to write Date into a text format
Using DATEVALUE to convert text based date to date based
Using EOMONTH to get end of month date
Moving date by periods with EDATE
Getting the number of working dates between 2 dates with NETWORKDAYS and NETWORKDAYS.INTL
Intro to DATEDIF
Calculating Age in different units with DATEDIF
Practice Assignment 3
Intro to combining functions
Combining Functions Example 1
Combining Functions Example 2
Combining Functions Example 3a
Combining Functions Example 3b
Intro to Cell referencing
Using Relative Cell Referencing Style
Using Absolute Cell Referencing Style
Using Mixed Referencing (Row Lock and Column Lock)
Practice Assignment 4
Intro to Logical Operators in Excel
Counting values based on criteria with COUNTIF (part 1)
Counting values based on criteria with COUNTIF (part 2)
Counting values based on multiple criteria with COUNTIFS
Using SUMIF and AVERAGEIF functions to summarize category values
Using SUMIFS to summarize multiple criteria categories
Intro to logical functions
Using IF function (part 1)
Using IF function (part 2)
Introduction to AND & OR functions
Combining IF with AND functions
Combining IF with OR function
Using Nested IFs
Practice Assignment 5
Intro to VLOOKUP
Using VLOOKUP (part 2)
Using VLOOKUP (part 3)
Intro to MATCH function
Combining VLOOKUP and MATCH
Combining VLOOKUP and IFERROR
Using VLOOKUP (part 3)
Intro to XLOOKUP
Intro to INDEX
Using INDEX and MATCH
Practice Assignment 6
Emuobonuvie
Advanced excel functions
Very detailed
Cherif
Great course!!!
Complex Excel Functions explain in easy way to understand. Thanks for this excellent course.
Omotayo
Good learning experience
Now I have a good idea of using formulas on excel.
Olayinka
Great Course
Excellent instructor. Dedicates time to thoroughly explain the details of all functions.
Bernard
Powerful
The class was so powerful, so simple to assimilate. Great job.