On completion of this fast-paced course you will be able to create and format a spreadsheet effectively, utilise Excel formulas and functions, as well as create and modify charts to be visually professional and accurate.
Excel Data Visualisation
What Can You Expect?
This workshop is designed for people who are currently working in Excel that need to fill knowledge gaps, learn additional features of Charts and Sparklines to visually represent data. This is the ideal course to attend prior to Data Management and/ or PivotTable and Dashboard Reporting.
Assessment Strategy
The assessment methodologies used in this course are to determine and recognise learner competence against the criteria in the related unit standard(s). Learners are required to successfully complete both Formative and Summative assessments.
Unit Standard Alignment
1 Day Course Content
Modify Worksheet & Workbook Data
Use AutoFill Effectively
Move and Copy Data
Insert and Delete Columns and Rows
Insert and Rename Sheets
Move and Delete Sheets
Formatting a Worksheet
Format Cells to Enhance a Spreadsheet
Apply Various Cell Styles
Apply Conditional Formatting – Data Bars
Inset and Format Sparklines
Formulas and Functions
Use Autosum to Total Lists of Values
Basic Arithmetic Formulas
Use Logical Operators in Formulas
Use Absolute Cell References in Formulas
Insert Functions into Formulas
Display Formulas on Screen and Edit Formulas
Managing Workbooks
Hide and Unhide Columns and Rows
Insert, Remove and Adjust Page Breaks
Repeat Heading Rows at Top of Each Page
Freeze and Unfreeze Panes
Graphically Display Data
Create, Edit and Format a Chart
Load Data from External Data
Insert, Edit and Format Objects
Chart and Sparkline features
Show trends – increases or decreases
Printing Workbook Contents
Adjust Page Setup Options
Add Headers and Footers
Print Preview and Print a Spreadsheet
Expected Outcomes
On completion of this fast-paced course you will be able to create and format a spreadsheet effectively, utilise Excel formulas and functions, as well as create and modify charts to be visually professional and accurate.
Keybase Pretoria is an accredited training centre based in Moreleta Park, Pretoria East. We specialize in all Microsoft courses from Basic to Advanced as well as soft skill courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy