Microsoft Excel Data Visualisation

by Keybase Training Solutions

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.

$2300

Contact the Institutes

Fill this form

Advertisement

Keybase Training Solutions Logo

img Duration

Course Details

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

  • SAQA ID: 116940       NQF Level:  3          Credits: 6
  • US Title:        Use a Graphical User Interface (GUI)-Based Spreadsheet Application to Solve a Given Problem
  • SAQA ID:  116943        NQF Level: 4          Credits: 3
  • US Title:        Use a Graphical User Interface (GUI)-Based Spreadsheet Application, enhance the functionality and apply graph / charts to a spreadsheet.

 

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.

  • Moreleta Park Branch

    608 Rubenstein drive, Moreleta Park, Pretoria

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy