Microsoft Excel - Advanced

Duration

15 online hours and a POE submission.

Duration

Self-paced online learning.

Duration

This course is intended for people who need to enhance spreadsheet appearance using a Graphical User Interface (GUI)-based spreadsheet application, either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry. This course is also intended for people who work with spreadsheets and for whom the reliability of the data produced is critical.

Prerequisites

The learner must be competent in Communication, Mathematical Literacy and Computer Literacy at NQF level 3.

Unit Standards

Using a Graphical User Interface (GUI)-based Spreadsheet Application, Enhance the Functionality and Apply Graph / Charts to a Spreadsheet NQF 4 (3 credits)

(116943)

Learning outcomes:

• Create and edit a graph.
• Load data from an external data source to produce a given spreadsheet result.
• Insert and edit objects into a spreadsheet.

Ensure Spreadsheet Integrity to Enhance Reliability NQF 4 (3 credits)

(258878)

Learning outcomes:

• Set up a spreadsheet.
• Apply security.
• Check input data.
• Check formulas and totals.
• Check output data.
• Audit spreadsheets.
• Validate and sort data in a spreadsheet.

List of Lessons

• Sparklines
• Charts creation
• Chart design
• Chart formatting
• Screenshots and screen clipping
• Shapes
• SmartArt
• Themes
• Proofing tools
• Tracking changes
• Comments
• Managing multiple windows
• Splitting worksheets into panes
• Workbook views
• Header and footer
• Page setup
• Microsoft account
• File properties
• Workbook protection
• Workbook inspection
• File AutoRecovery
• Using templates
• Compatibility issues
• Saving a workbook to the Web
• Introduction to macros
• Macro recording
• Macro editing
• Macro security
• Digitally signed macros