9:00 |
EXCEL FUNCTIONS RECAP | |
|
|
- Vertical Lookup (Vlookup)
- Horizontal Lookup (Hlookup)
|
|
APPLYING AND MANAGING CONDITIONAL FORMATTING | |
- Data Bars
- Colour Scales
- Icon Sets
- Top/Bottom
|
|
ESSENTIAL LIST MANAGEMENT | |
- Sorting Data (By Values, By Cell Colour, By Font Colour, By Cell Icons)
- Multi Column Sort
- Filter (By Values, By Cell Colour, By Font Colour, By Cell Icons)
- Multi Column Filter
- Advanced Filter
- Adding Subtotals
- Group and Outline
- Data Form
- Format As Table Feature
- Data Consolidation
|
2:00 |
CHARTS/GRAPHS TECHNIQUES | |
- Creating Chart Using Shortcut Keys
- Saving Custom Chart as Templates
- Setting Chart as Default
- Applying Trendlines
- Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc...
- Using Sparklines (Line, Column, Win/Loss)
|
|