Microsoft Excel Level 3 (Intermediate)

Versions: All earlier versions, 2013 and 2016 available

On-site training or public courses available in Paulshof, Sandton

Description

This is a middle level or intermediate course for people who have done a beginners course but need more skills to analyse and report on data. This course focuses on the tools needed to work with large spreadsheets, clean up data, sort and filter, pivot tables and charts.

Duration

1 day

NQF level: 3

Outcomes

This course covers the handling of large amounts of data which has to be cleaned up, sorted and filtered and analysed for reporting purposes.

Prerequisites

You must have attended a beginner’s course in Excel and/or work with Microsoft Excel on a daily basis. We recommend you do our Excel level 2 course first.

Module 1: Work with large datasets

  • Use split and side by side to view the spreadsheet
  • Text functions
  • Text to Columns wizard
  • Conditional formatting
  • Finding duplicates by using conditional formatting

Module 2: Sort and filter data

  • Sort a list
  • Custom sort
  • Sort by cell colour
  • Sort by font colour
  • Sort by icon
  • Filter a list
  • Filter by cell colour
  • Filter by font colour
  • Filter by icon
  • Create sub-totals
  • Use the create table feature
  • Modify and format a table
  • Finding duplicates in a table
  • Functions and formulas in a table
  • Display data trends using Sparklines

Module 3: Introducing Pivot Tables

  •  Create a pivot table
  •  Move fields in a pivot table
  •  Group, sort and filter data
  •  Format pivot tables
  •  Format field settings
  •  Apply a Pivot Table Style
  •  Refresh a pivot table

Module 4:  Charts 

  • Insert a chart
  • The contextual tabs
  • Choose chart options
  • Edit a chart
  • Add a data series
  • Delete a series from a range
  • Change chart type
  • Change the chart format
  • Add text and drawing objects
  • Create a combination chart
  • Print a chart

Request a quotation

Full Name(*)
Please type your full name.

E-mail(*)
Invalid email address.

Phone Number
Invalid Input

Individual or company?(*)
Individual or company?

How many people require training?(*)
How many people require training?

Download course details