EXCEL ADVANCED
Description
You have successfully completed a foundational and intermediate excel course, or have the equivalent knowledge and skills. In your work environment, you need to produce and/or modify sophisticated spreadsheets in a variety of industry and economic sectors. This course is designed to assist you to succeed in business. Having the ability to use tools to manipulate data while ensuring is critical to your on-going success.
After completion of the course, and some practical application, you can opt to undergo a formal assessment with the view of earning a nationally recognised certification.
Learning outcomes
- Validate and sort data in a spreadsheet.
- Apply security settings to a spreadsheet.
- Use a range of functions within a spreadsheet.
- Use formula, mixed references and named ranges to provide solutions to a problem.
- Audit formulae to ensure data integrity.
- Create and edit scenarios
Target Group
For people who have knowledge of Excel
Learning Delivery Method
Stand-alone classroom-based accredited course
Unit Standard Alignment
SAQA ID: 258882 NQF Level: 4 Credits: 4
US Title: Use a Graphical User Interface (GUI)-based presentation application to prepare and produce a presentation according to a given brief
Assessment
Optional
Duration
1 Day