This course is aimed at those who wish to build on their basic Microsoft Excel skills and gain further knowledge on some more advanced features.
This course will provide instruction on;
- Working with large spreadsheets
- Working with multiple spreadsheets
- Working with Dates & Times
- Conditional Formulas
- Conditional Formatting
- Working with Tables
- Documenting & Auditing
- Templates
Participants in the course must complete all the listed assignments for marking by the instructor in order to pass.
Curriculum
- 1 Section
- 7 Lessons
- 3 Weeks
Expand all sectionsCollapse all sections
- Intermediate Microsoft Excel14
- 1.11 – Working with large worksheets
- 1.2Intermediate Excel – Assignment 1
- 1.32 – Working with multiple worksheets and workbooks
- 1.4Intermediate Excel – Assignment 2
- 1.53 – Working with dates
- 1.6Intermediate Excel – Assignment 3
- 1.74 – Conditional formulas and formatting
- 1.8Intermediate Excel – Assignment 4
- 1.95 – Working with tables
- 1.10Intermediate Excel – Assignment 5
- 1.116 – Documenting and auditing
- 1.12Intermediate Excel – Assignment 6
- 1.137 – Using Templates
- 1.14Intermediate Excel – Assignment 7