Description
This course is for anyone with previous understanding or experience working with Excel. Learn how to work with and create sophisticated spreadsheets and as well as visualize and manipulate data. The course can be completed in conjunction with our Advanced and Intermediate Excel Courses.
Advanced
Course Duration: 7 hours
NQF 4
Credit 4
Outcomes
- Validating and Sorting data in a spreadsheet.
- Applying security settings to a spreadsheet.
- Using a range of functions within a spreadsheet.
- Using formula, mixed references and name ranges to provide solutions to a problem.
- Auditing formula to ensure data integrity.
- Create and edit scenarios.
COURSE OUTLINE ON REQUEST
