Advanced Excel

Mastering Microsoft Excel Formulas

In this Excel Mastery Course, you will learn how to write simple to intermediate and advanced Excel formulas. You will also learn how to combine functions in a single excel formula. Learn to use over 50 Excel functions.

Buy $15.00 Join Week 1 FREE

Course curriculum

Use coupon code code EXCELPRO2024 to get 80% Off

1. Welcome
  FREE PREVIEW
2. Download the class files here
1. Converting texts to different cases with UPPER, LOWER and PROPER
  FREE PREVIEW
2. Using LEFT and RIGHT to extract characters from start and end of text strings
  FREE PREVIEW
3. Using MID to extract middle characters and TRIM to remove extra spaces
  FREE PREVIEW
4. Combining texts with CONCATENATE, CONCAT and TEXTJOIN
5. Converting between numbers and characters with UNICODE and UNICHAR
6. Using LEN, FIND and SEARCH functions
7. Practice Assignment 2
1. Introduction to Date Functions
2. Extracting Day, Month and Year from Date with DAY, MONTH and YEAR
3. Extracting day of week and week of year with WEEKDAY and WEEKNUM
4. Using TEXT function to write Date into a text format
5. Using DATEVALUE to convert text based date to date based
6. Using EOMONTH to get end of month date
7. Moving date by periods with EDATE
8. Getting the number of working dates between 2 dates with NETWORKDAYS and NETWORKDAYS.INTL
9. Intro to DATEDIF
10. Calculating Age in different units with DATEDIF
11. Practice Assignment 3
1. Intro to combining functions
2. Combining Functions Example 1
3. Combining Functions Example 2
4. Combining Functions Example 3a
5. Combining Functions Example 3b
1. Intro to Cell referencing
2. Using Relative Cell Referencing Style
3. Using Absolute Cell Referencing Style
4. Using Mixed Referencing (Row Lock and Column Lock)
5. Practice Assignment 4
1. Intro to Logical Operators in Excel
2. Counting values based on criteria with COUNTIF (part 1)
3. Counting values based on criteria with COUNTIF (part 2)
4. Counting values based on multiple criteria with COUNTIFS
5. Using SUMIF and AVERAGEIF functions to summarize category values
6. Using SUMIFS to summarize multiple criteria categories
7. Intro to logical functions
8. Using IF function (part 1)
9. Using IF function (part 2)
10. Introduction to AND & OR functions
11. Combining IF with AND functions
12. Combining IF with OR function
13. Using Nested IFs
14. Practice Assignment 5
1. Intro to VLOOKUP
2. Using VLOOKUP (part 2)
3. Using VLOOKUP (part 3)
4. Intro to MATCH function
5. Combining VLOOKUP and MATCH
6. Combining VLOOKUP and IFERROR
7. Using VLOOKUP (part 3)
8. Intro to XLOOKUP
9. Intro to INDEX
10. Using INDEX and MATCH
11. Practice Assignment 6