INTRODUCTION
- SUM IFS AND COUNTIFS
- PIVOT TABLE AND PIVOT CHART
- VLOOK UP & HLOOKUP
- DATA VALIDATION
- GOAL SEEK
- HYPERLINK
- NAME MANAGER
- ADVANCE FILTER
- SCENARIO MANAGER
- QUICK ACCESS TOOL BAR
- FORMULA AUDITTING
- CONDITIONAL FORMATTING
- SUBTOTAL, GROUP, UNGROUP
- DATA TABLE
- REMOVE DUPLICATES
- CONSOLIDATION
- WATCH WINDOW
- TEXT TO COLUMNS
- CUSTOM VIEWS
- COMMENT
- PASTE SPECIAL
- TRACK CHANGES