After successful completion of the introduction and overview of the basic features of Excel learners will have an understanding of creating spreadsheets, handling simple lists of data, charts and be able to print formatted sections of a spreadsheet.
The intermediate course is intended to advance a learner‘s skills and confidence in working with Excel. Upon completion an understanding of advanced formatting, data searching using criteria based searches, analysis, summarising of data and creating customise charts will be acquired.
If you are familiar with creating and editing spreadsheets, have some knowledge of Excel or spreadsheets, able to launch and close applications, navigate to stored information and manage files and folders then this course will assist you to gain the necessary skills to plan, produce and use spreadsheets to solve problems using a spreadsheet application.
- Modify worksheet data
- Formatting a worksheet
- Basic calculations
- Modify a workbook
- Printing workbook contents
- Enhancing basic formulas
- Managing workbooks
- Customise the environment
For people who have some knowledge of Excel or spreadsheets
Learning Delivery Method
Stand-alone classroom-based accredited course
Unit Standard Alignment
SAQA ID: 116940 NQF Level: 3 Credits: 6
US Title: Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem.