|
Our evening Courses have been tailored to meet the needs of professionals who need to improve their own peronal development and meet the requirements set by their particular institutes.
They run between 6pm and 8pm.

|
CONTENT A |
|
Advanced Functions
- IF Function & Nested IF Statements
- And & Or Functions
- Conditional Formatting
|
|
3D Ranges
- Create & Maintain (Within Worksheets in a single file & between external files)
|
|
Data
- Sort data into Lists
- Filter data – Autofilter, Advanced Filter
- Validation Rules to restrict data entry
|
|
Outlines
- Group Row/ Column Data to create Outline
- Levels based on Worksheet Formulae
- Display Summary Rows and Summary Styles
|
|
Custom Views
- Create, modify, delete
- Include hidden Rows, Columns, Filter Settings
|
Please click here to view Content B
Click here to view list of ALL Excel courses

|