|
|
SPREADSHEETS
| Level |
Course Coverage |
Office
Versions |
 |
| Introduction |
- Building New Spreadsheets from scratch
- Selecting and moving around the Worksheet
- Saving and Opening Workbooks
- Formatting selected cell ranges
- Inserting and deleting columns and rows
- Printing, Previewing and Page Setup
- Creating and customsing Charts
|
All Versions |
| Intermediate |
- Naming Ranges of Cells
- Data Validation
- What If? Analysis
- IF() function and Lookup Tables
- Organising Workbooks and Worksheets
- Sorting, filtering and subtotalling Lists
- Advanced Charting
|
|
| Advanced |
- Advanced Data and Pivot Table Usage
- Outling and Auditing features
- Creating Templates
- Adding Keyboard shortcuts and AutoText
- Customising Excel via Macros
- Recording and Running Macros
|
|
| Programming |
- Recording and Editing Macros
- Visual Basic Language elements
- Excel Objects
- Selecting , moving and formatting
- Building UserForms in Excel
|
|
|
