Module 01 – ESSENTIALS
- Workbook (Pdf)
- Introduction To Excel Function
- Basic Formulas
- Basic Functions
- Basic Functions Part 2
- Functions In Mac
- Keyboard Shortcuts For Functions
- Review Quiz (Number of attempts allowed: Unlimited)
Module 03 – FUNCTION LIBRARY
- Workbook (Pdf)
- SUM
- SUMIF
- SUMIFS
- COUNT, COUNTA, COUNTBLANK
- COUNTIF, COUNTIFS
- AVERAGE, AVERAGEA
- AVERAGEIF, AVERAGEIFS
- MIN, MAX, SMALL, LARGE
- MINIFS, MAXIFS
- RAND, RANDBETWEEN
- TODAY, NOW
- MONTH, DAY, YEAR, TEXT
- CONCAT, TEXTJOIN
- LEFT, RIGHT, MID
- UPPER, LOWER, PROPER
- TRIM, CLEAN
- CHAR, CODE, UNICHAR, UNICODE
- REPLACE, SUBSTITUTE
- FIND, SEARCH
- LEN
- IF
- AND, OR
- NOT
- MATCH
- INDEX
- VLOOKUP
- HLOOKUP
- LOOKUP
- CHOOSE
- Review Quiz (Number of attempts allowed: Unlimited)
Module 02 – ADVANCED
- Workbook (Pdf)
- Named Ranges
- 3D Cell Reference
- Formula Auditing
- Review Quiz (Number of attempts allowed: Unlimited)