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 &