Excel for Beginners

Introduction
Interface
Cell References
• Settings
• Selection formatting
• Hiding and deleting
• Basic function and calculation (+, -, *, /,^)

Tables Charts and graphs
Sparklines
Sorting filtering
Protection
Duplicates highlight remove
Condition formatting

Saving, printing
Data validation
Freeze Panes
Errors
Functions:
• SUM, AVARGE, MIN, MAX,
• TODAY(), NOW(),
• COUNT, COUNTA,
• LEN, TRIM
• UPPER, LOWER, PROPER
• CONCATENATE or &