Training: Microsoft Excel

Data Analysis

A good command of Microsoft Excel is of benefit to all levels of the organisation from Administration to IT and even Marketing. It offers a myriad skills including the ability to effectively structure, capture, visualise and manipulate data. We go beyond teaching to integrating. Data is nothing without the ability to mine it effectively. If prepared properly, data can be analysed to guide business decisions such as efficiency, stock, finance, database and workflow. We offer three Microsoft Excel courses for occasional, intermediate and advanced users. Our training courses all come with instructional design manuals.

Duration: One Day
Cost: R1,499.00
T. +27(0)21 100 3599


Who should attend?

  • Needs to analyse data
  • Creates spreadsheets for use by others
  • Needs to learn how to add visual elements representing large data sets
  • Needs a smaller, specific overview of a large data set

Course Benefits

  • This course looks at Excel as an all-in-one data management tool allowing you to import, explore, clean, analyse, and visualise your data all in one application.

Course Outline

  • Lesson 1: Creating Subtotals, Applying an Auto Outline and Grouping Data
  • Lesson 2: Working with Table Overlays
  • Lesson 3: Conditional Formatting
  • Lesson 4: Inserting Sparklines
  • Lesson 5: Creating Charts
  • Lesson 6: Creating Templates

We also offer cost effective in-house training. This workshop can be held exclusively as an in-house option for your organisation.
We provide a 20% discount for those clients who opt to use their own training venue with a minimum of 10 candidates.
Candidates receive a Certificate of Attendance on successful completion.