Master 20 essential Excel formulas and functions in this comprehensive 2.5-hour tutorial. Learn basic math and counting functions like SUM, MIN, MAX, AVERAGE, and COUNT. Explore logical functions such as AND, OR, and IF. Dive into advanced lookup techniques with VLOOKUP, INDEX, MATCH, XLOOKUP, and XMATCH. Enhance your skills in text manipulation using CONCAT, error handling with IFERROR and IFNA, and formula efficiency with the LET function. Gain proficiency in handling date, time, and randomization tasks. Practice with hands-on examples to solidify your understanding of these crucial Excel tools, preparing you to tackle complex spreadsheet challenges in 2024 and beyond.
Overview
Syllabus
- Intro
- SUM Function
- MIN and MAX Functions
- AVERAGE Function
- COUNT, COUNTA, and COUNTBLANK
- Logical Functions AND, OR, IF
- MATCH Function
- CONCAT Function
- VLOOKUP
- SUMIFS and COUNTIFS
- INDEX AND MATCH Functions
- XLOOKUP and XMATCH Functions
- Count Cells with Text COUNTIF
- IF, Nested IF, IFS
- Example of IF Function
- Nested IF
- IFS Function
- IFERROR AND IFNA
- LET Function
- Date and Time Functions
- Randomized List and RAND Function
Taught by
Simon Sez IT
