Please click here to chat with a certified trainer
Microsoft Excel courses logo

 

MS Excel courses

 


 

 

  • Excel Level 1 Course
  • Excel Level 2 Course
  • Excel Level 3 Course

Course Date  City Course Times    Cost  
December        
18 Dec Polokwane 0830 - 1600    R1795 Book
20 Dec Midrand 0830 - 1600    R1795 Book
20 Dec Sandton 0830 - 1600    R1795 Book
January        
08 Jan Cape Town 0830 - 1600    R1795 Book
08 Jan Durban 0830 - 1600    R1795 Book
08 Jan Midrand 0830 - 1600    R1795 Book
08 Jan Sandton 0830 - 1600    R1795 Book
10 Jan Cape Town 0830 - 1600    R1795 Book
16 Jan Durban 0830 - 1600    R1795 Book
17 Jan Midrand 0830 - 1600    R1795 Book
17 Jan Sandton 0830 - 1600    R1795 Book
22 Jan Durban 0830 - 1600    R1795 Book
22 Jan Pretoria 0830 - 1600    R1795 Book
24 Jan Boksburg 0830 - 1600    R1795 Book
31 Jan Pretoria 0830 - 1600    R1795 Book
February        
05 Feb Durban 0830 - 1600    R1795 Book
05 Feb Midrand 0830 - 1600    R1795 Book
05 Feb Sandton 0830 - 1600    R1795 Book
07 Feb Boksburg 0830 - 1600    R1795 Book
14 Feb Durban 0830 - 1600    R1795 Book
14 Feb Midrand 0830 - 1600    R1795 Book
14 Feb Sandton 0830 - 1600    R1795 Book
19 Feb Pretoria 0830 - 1600    R1795 Book
23 Feb Durban 0830 - 1600    R1795 Book
28 Feb Pretoria 0830 - 1600    R1795 Book
March        
05 Mar Midrand 0830 - 1600    R1795 Book
05 Mar Sandton 0830 - 1600    R1795 Book
14 Mar Durban 0830 - 1600    R1795 Book
14 Mar Midrand 0830 - 1600    R1795 Book
14 Mar Sandton 0830 - 1600    R1795 Book
23 Mar Durban 0830 - 1600    R1795 Book
26 Mar Pretoria 0830 - 1600    R1795 Book
April        
10 Apr Midrand 0830 - 1600    R1795 Book
10 Apr Sandton 0830 - 1600    R1795 Book
11 Apr Pretoria 0830 - 1600    R1795 Book
23 Apr Pretoria 0830 - 1600    R1795 Book
May        
07 May Midrand 0830 - 1600    R1795 Book
07 May Sandton 0830 - 1600    R1795 Book
16 May Midrand 0830 - 1600    R1795 Book
16 May Sandton 0830 - 1600    R1795 Book
21 May Pretoria 0830 - 1600    R1795 Book
30 May Pretoria 0830 - 1600    R1795 Book
June        
05 Jun Midrand 0830 - 1600    R1795 Book
05 Jun Sandton 0830 - 1600    R1795 Book
13 Jun Midrand 0830 - 1600    R1795 Book
13 Jun Sandton 0830 - 1600    R1795 Book
18 Jun Pretoria 0830 - 1600    R1795 Book
27 Jun Pretoria 0830 - 1600    R1795 Book
July        
02 Jul Midrand 0830 - 1600    R1795 Book
02 Jul Sandton 0830 - 1600    R1795 Book
11 Jul Midrand 0830 - 1600    R1795 Book
11 Jul Sandton 0830 - 1600    R1795 Book
16 Jul Pretoria 0830 - 1600    R1795 Book
25 Jul Pretoria 0830 - 1600    R1795 Book
30 Jul Midrand 0830 - 1600    R1795 Book
30 Jul Sandton 0830 - 1600    R1795 Book
August        
13 Aug Pretoria 0830 - 1600    R1795 Book
22 Aug Midrand 0830 - 1600    R1795 Book
22 Aug Pretoria 0830 - 1600    R1795 Book
22 Aug Sandton 0830 - 1600    R1795 Book

Course Date  City Course Times    Cost  
       
24 Jan Boksburg 0830 - 1600    R1795 Book
07 Feb Boksburg 0830 - 1600    R1795 Book
       
08 Jan Cape Town 0830 - 1600    R1795 Book
10 Jan Cape Town 0830 - 1600    R1795 Book
       
08 Jan Durban 0830 - 1600    R1795 Book
16 Jan Durban 0830 - 1600    R1795 Book
22 Jan Durban 0830 - 1600    R1795 Book
05 Feb Durban 0830 - 1600    R1795 Book
14 Feb Durban 0830 - 1600    R1795 Book
23 Feb Durban 0830 - 1600    R1795 Book
14 Mar Durban 0830 - 1600    R1795 Book
23 Mar Durban 0830 - 1600    R1795 Book
       
20 Dec Midrand 0830 - 1600    R1795 Book
08 Jan Midrand 0830 - 1600    R1795 Book
17 Jan Midrand 0830 - 1600    R1795 Book
05 Feb Midrand 0830 - 1600    R1795 Book
14 Feb Midrand 0830 - 1600    R1795 Book
05 Mar Midrand 0830 - 1600    R1795 Book
14 Mar Midrand 0830 - 1600    R1795 Book
10 Apr Midrand 0830 - 1600    R1795 Book
07 May Midrand 0830 - 1600    R1795 Book
16 May Midrand 0830 - 1600    R1795 Book
05 Jun Midrand 0830 - 1600    R1795 Book
13 Jun Midrand 0830 - 1600    R1795 Book
02 Jul Midrand 0830 - 1600    R1795 Book
11 Jul Midrand 0830 - 1600    R1795 Book
30 Jul Midrand 0830 - 1600    R1795 Book
22 Aug Midrand 0830 - 1600    R1795 Book
       
18 Dec Polokwane 0830 - 1600    R1795 Book
       
22 Jan Pretoria 0830 - 1600    R1795 Book
31 Jan Pretoria 0830 - 1600    R1795 Book
19 Feb Pretoria 0830 - 1600    R1795 Book
28 Feb Pretoria 0830 - 1600    R1795 Book
26 Mar Pretoria 0830 - 1600    R1795 Book
11 Apr Pretoria 0830 - 1600    R1795 Book
23 Apr Pretoria 0830 - 1600    R1795 Book
21 May Pretoria 0830 - 1600    R1795 Book
30 May Pretoria 0830 - 1600    R1795 Book
18 Jun Pretoria 0830 - 1600    R1795 Book
27 Jun Pretoria 0830 - 1600    R1795 Book
16 Jul Pretoria 0830 - 1600    R1795 Book
25 Jul Pretoria 0830 - 1600    R1795 Book
13 Aug Pretoria 0830 - 1600    R1795 Book
22 Aug Pretoria 0830 - 1600    R1795 Book
       
20 Dec Sandton 0830 - 1600    R1795 Book
08 Jan Sandton 0830 - 1600    R1795 Book
17 Jan Sandton 0830 - 1600    R1795 Book
05 Feb Sandton 0830 - 1600    R1795 Book
14 Feb Sandton 0830 - 1600    R1795 Book
05 Mar Sandton 0830 - 1600    R1795 Book
14 Mar Sandton 0830 - 1600    R1795 Book
10 Apr Sandton 0830 - 1600    R1795 Book
07 May Sandton 0830 - 1600    R1795 Book
16 May Sandton 0830 - 1600    R1795 Book
05 Jun Sandton 0830 - 1600    R1795 Book
13 Jun Sandton 0830 - 1600    R1795 Book
02 Jul Sandton 0830 - 1600    R1795 Book
11 Jul Sandton 0830 - 1600    R1795 Book
30 Jul Sandton 0830 - 1600    R1795 Book
22 Aug Sandton 0830 - 1600    R1795 Book

Excel Level 1 Course

Course Description

Microsoft Office Excel Beginner's course is intended for anyone who desires to gain the skills necessary to create, edit, format and print basic Microsoft Office Excel worksheets.

 

Target Audience

Anyone that needs to know Microsoft Office Excel and perform daily tasks on it.

 

Prerequisites

Windows 7: Basic or equivalent experience.

Excel Level 1 Course

Download PDF

1. Getting Started

  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Using a template

 

2. Entering and Editing Data

  • Entering and editing text and values
  • Entering and Editing formulas
  • Saving and updating workbooks

 

3. Modifying a Worksheet

  • Moving and copying data
  • Moving, copying, and viewing formulas
  • Absolute and relative references
  • Inserting and deleting ranges, rows and column

 

4. Functions

  • Entering functions
  • AutoSum
  • Other common functions

 

5. Formatting

  • Text formatting
  • Row and column formatting
  • Number formatting
  • Conditional formatting
  • Additional formatting options

 

6. Charts

  • Chart basics
  • Formatting charts

 

7. Graphics

  • Working with pictures
  • Conditional formatting with graphics
  • SmartArt graphics

 

8. Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

 

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Course Date  City Course Times    Cost  
December        
21 Dec Pretoria 0830 - 1600    R1895 Book
January        
10 Jan Durban 0830 - 1600    R1895 Book
15 Jan Cape Town 0830 - 1600    R1895 Book
18 Jan Durban 0830 - 1600    R1895 Book
19 Jan Cape Town 0830 - 1600    R1895 Book
23 Jan Pretoria 0830 - 1600    R1895 Book
24 Jan Durban 0830 - 1600    R1895 Book
25 Jan Midrand 0830 - 1600    R1895 Book
25 Jan Sandton 0830 - 1600    R1895 Book
26 Jan Boksburg 0830 - 1600    R1895 Book
February        
06 Feb Midrand 0830 - 1600    R1895 Book
06 Feb Sandton 0830 - 1600    R1895 Book
07 Feb Durban 0830 - 1600    R1895 Book
08 Feb Pretoria 0830 - 1600    R1895 Book
09 Feb Boksburg 0830 - 1600    R1895 Book
16 Feb Durban 0830 - 1600    R1895 Book
20 Feb Pretoria 0830 - 1600    R1895 Book
22 Feb Midrand 0830 - 1600    R1895 Book
22 Feb Sandton 0830 - 1600    R1895 Book
27 Feb Durban 0830 - 1600    R1895 Book
March        
06 Mar Midrand 0830 - 1600    R1895 Book
06 Mar Sandton 0830 - 1600    R1895 Book
15 Mar Pretoria 0830 - 1600    R1895 Book
16 Mar Durban 0830 - 1600    R1895 Book
22 Mar Midrand 0830 - 1600    R1895 Book
22 Mar Sandton 0830 - 1600    R1895 Book
27 Mar Durban 0830 - 1600    R1895 Book
27 Mar Pretoria 0830 - 1600    R1895 Book
April        
10 Apr Midrand 0830 - 1600    R1895 Book
10 Apr Sandton 0830 - 1600    R1895 Book
19 Apr Pretoria 0830 - 1600    R1895 Book
24 Apr Pretoria 0830 - 1600    R1895 Book
26 Apr Midrand 0830 - 1600    R1895 Book
26 Apr Sandton 0830 - 1600    R1895 Book
May        
08 May Midrand 0830 - 1600    R1895 Book
08 May Sandton 0830 - 1600    R1895 Book
22 May Pretoria 0830 - 1600    R1895 Book
31 May Midrand 0830 - 1600    R1895 Book
31 May Sandton 0830 - 1600    R1895 Book
June        
05 Jun Midrand 0830 - 1600    R1895 Book
05 Jun Sandton 0830 - 1600    R1895 Book
07 Jun Pretoria 0830 - 1600    R1895 Book
13 Jun Midrand 0830 - 1600    R1895 Book
13 Jun Sandton 0830 - 1600    R1895 Book
19 Jun Pretoria 0830 - 1600    R1895 Book
July        
03 Jul Midrand 0830 - 1600    R1895 Book
03 Jul Sandton 0830 - 1600    R1895 Book
05 Jul Pretoria 0830 - 1600    R1895 Book
17 Jul Pretoria 0830 - 1600    R1895 Book
26 Jul Midrand 0830 - 1600    R1895 Book
26 Jul Sandton 0830 - 1600    R1895 Book
31 Jul Midrand 0830 - 1600    R1895 Book
31 Jul Sandton 0830 - 1600    R1895 Book
August        
02 Aug Pretoria 0830 - 1600    R1895 Book
14 Aug Pretoria 0830 - 1600    R1895 Book
20 Aug Midrand 0830 - 1600    R1895 Book
20 Aug Sandton 0830 - 1600    R1895 Book
September        
11 Sep Pretoria 0830 - 1600    R1895 Book

Course Date  City Course Times    Cost  
       
26 Jan Boksburg 0830 - 1600    R1895 Book
09 Feb Boksburg 0830 - 1600    R1895 Book
       
15 Jan Cape Town 0830 - 1600    R1895 Book
19 Jan Cape Town 0830 - 1600    R1895 Book
       
10 Jan Durban 0830 - 1600    R1895 Book
18 Jan Durban 0830 - 1600    R1895 Book
24 Jan Durban 0830 - 1600    R1895 Book
07 Feb Durban 0830 - 1600    R1895 Book
16 Feb Durban 0830 - 1600    R1895 Book
27 Feb Durban 0830 - 1600    R1895 Book
16 Mar Durban 0830 - 1600    R1895 Book
27 Mar Durban 0830 - 1600    R1895 Book
       
25 Jan Midrand 0830 - 1600    R1895 Book
06 Feb Midrand 0830 - 1600    R1895 Book
22 Feb Midrand 0830 - 1600    R1895 Book
06 Mar Midrand 0830 - 1600    R1895 Book
22 Mar Midrand 0830 - 1600    R1895 Book
10 Apr Midrand 0830 - 1600    R1895 Book
26 Apr Midrand 0830 - 1600    R1895 Book
08 May Midrand 0830 - 1600    R1895 Book
31 May Midrand 0830 - 1600    R1895 Book
05 Jun Midrand 0830 - 1600    R1895 Book
13 Jun Midrand 0830 - 1600    R1895 Book
03 Jul Midrand 0830 - 1600    R1895 Book
26 Jul Midrand 0830 - 1600    R1895 Book
31 Jul Midrand 0830 - 1600    R1895 Book
20 Aug Midrand 0830 - 1600    R1895 Book
       
21 Dec Pretoria 0830 - 1600    R1895 Book
23 Jan Pretoria 0830 - 1600    R1895 Book
08 Feb Pretoria 0830 - 1600    R1895 Book
20 Feb Pretoria 0830 - 1600    R1895 Book
15 Mar Pretoria 0830 - 1600    R1895 Book
27 Mar Pretoria 0830 - 1600    R1895 Book
19 Apr Pretoria 0830 - 1600    R1895 Book
24 Apr Pretoria 0830 - 1600    R1895 Book
22 May Pretoria 0830 - 1600    R1895 Book
07 Jun Pretoria 0830 - 1600    R1895 Book
19 Jun Pretoria 0830 - 1600    R1895 Book
05 Jul Pretoria 0830 - 1600    R1895 Book
17 Jul Pretoria 0830 - 1600    R1895 Book
02 Aug Pretoria 0830 - 1600    R1895 Book
14 Aug Pretoria 0830 - 1600    R1895 Book
11 Sep Pretoria 0830 - 1600    R1895 Book
       
25 Jan Sandton 0830 - 1600    R1895 Book
06 Feb Sandton 0830 - 1600    R1895 Book
22 Feb Sandton 0830 - 1600    R1895 Book
06 Mar Sandton 0830 - 1600    R1895 Book
22 Mar Sandton 0830 - 1600    R1895 Book
10 Apr Sandton 0830 - 1600    R1895 Book
26 Apr Sandton 0830 - 1600    R1895 Book
08 May Sandton 0830 - 1600    R1895 Book
31 May Sandton 0830 - 1600    R1895 Book
05 Jun Sandton 0830 - 1600    R1895 Book
13 Jun Sandton 0830 - 1600    R1895 Book
03 Jul Sandton 0830 - 1600    R1895 Book
26 Jul Sandton 0830 - 1600    R1895 Book
31 Jul Sandton 0830 - 1600    R1895 Book
20 Aug Sandton 0830 - 1600    R1895 Book

Excel Level 2 Course

Course Description

Microsoft Office Excel Basic is followed by Microsoft Office Excel Intermediate, you created edited, formatted and printed basic spreadsheets. You now have to streamline repetitive tasks and display spreadsheets in more visually effective ways. In this course you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics and formulas.

 

Target Audience

Anyone that desires to gain necessary skill to create templates, sort and filter data, import and export data, analyse data and work with Excel on the Web.

 

Prerequisites

Excel 2013: Basic or equivalent experience.

Excel Level 2 Course

Download PDF

1. Managing Workbooks and Worksheets

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Linking worksheets with 3-D formulas
  • Using multiple workbooks
  • Linking workbooks

 

2. Advanced formatting

  • Using Special number formats
  • Working with themes
  • Other advanced formatting

 

3. Outlining and Subtotals

  • Outlining and consolidating data
  • Creating subtotals

 

4. Cell and Range Names

  • Creating and using names
  • Managing names

 

5. Data Structure and Tables

  • Sorting and filtering data
  • Working with tables

 

6. Web and Sharing Features

  • Saving workbooks as Web pages
  • Using hyperlinks

 

7. Documenting and Auditing

  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration

 

8. Application Settings and Templates

  • Application settings
  • Working with templates

 

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.

Course Date  City Course Times    Cost  
December        
22 Dec Pretoria 0830 - 1600    R1995 Book
January        
10 Jan Midrand 0830 - 1600    R1995 Book
10 Jan Sandton 0830 - 1600    R1995 Book
12 Jan Durban 0830 - 1600    R1995 Book
23 Jan Cape Town 0830 - 1600    R1995 Book
24 Jan Pretoria 0830 - 1600    R1995 Book
26 Jan Boksburg 0830 - 1600    R1995 Book
26 Jan Cape Town 0830 - 1600    R1995 Book
29 Jan Durban 0830 - 1600    R1995 Book
February        
07 Feb Midrand 0830 - 1600    R1995 Book
07 Feb Sandton 0830 - 1600    R1995 Book
09 Feb Durban 0830 - 1600    R1995 Book
14 Feb Boksburg 0830 - 1600    R1995 Book
15 Feb Pretoria 0830 - 1600    R1995 Book
March        
02 Mar Durban 0830 - 1600    R1995 Book
07 Mar Midrand 0830 - 1600    R1995 Book
07 Mar Sandton 0830 - 1600    R1995 Book
20 Mar Durban 0830 - 1600    R1995 Book
29 Mar Midrand 0830 - 1600    R1995 Book
29 Mar Sandton 0830 - 1600    R1995 Book
April        
11 Apr Midrand 0830 - 1600    R1995 Book
11 Apr Sandton 0830 - 1600    R1995 Book
May        
03 May Midrand 0830 - 1600    R1995 Book
03 May Sandton 0830 - 1600    R1995 Book


Course Date  City Course Times    Cost  
       
26 Jan Boksburg 0830 - 1600    R1995 Book
14 Feb Boksburg 0830 - 1600    R1995 Book
       
23 Jan Cape Town 0830 - 1600    R1995 Book
26 Jan Cape Town 0830 - 1600    R1995 Book
       
12 Jan Durban 0830 - 1600    R1995 Book
29 Jan Durban 0830 - 1600    R1995 Book
09 Feb Durban 0830 - 1600    R1995 Book
02 Mar Durban 0830 - 1600    R1995 Book
20 Mar Durban 0830 - 1600    R1995 Book
       
10 Jan Midrand 0830 - 1600    R1995 Book
07 Feb Midrand 0830 - 1600    R1995 Book
07 Mar Midrand 0830 - 1600    R1995 Book
29 Mar Midrand 0830 - 1600    R1995 Book
11 Apr Midrand 0830 - 1600    R1995 Book
03 May Midrand 0830 - 1600    R1995 Book
       
22 Dec Pretoria 0830 - 1600    R1995 Book
24 Jan Pretoria 0830 - 1600    R1995 Book
15 Feb Pretoria 0830 - 1600    R1995 Book
       
10 Jan Sandton 0830 - 1600    R1995 Book
07 Feb Sandton 0830 - 1600    R1995 Book
07 Mar Sandton 0830 - 1600    R1995 Book
29 Mar Sandton 0830 - 1600    R1995 Book
11 Apr Sandton 0830 - 1600    R1995 Book
03 May Sandton 0830 - 1600    R1995 Book

Excel Level 3 Course

Course Description

Microsoft Office Excel Intermediate course is followed by Microsoft Office Excel Advanced, this course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

 

Target Audience

This course was designed for students desiring to gain the skill necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources and import and export data.

 

Prerequisites

Excel 2013: Intermediate or equivalent experience.

Excel Level 3 Course

Download PDF

1. Advanced Functions and Formulas

  • Logical functions
  • Conditional functions
  • Financial functions
  • Text functions
  • Date and time functions
  • Array formulas
  • Calculation options

 

2. Lookups and Data Tables

  • Using lookup functions
  • Creating data tables

 

3. Advanced Data Management

  • Validating cell entries
  • Advanced filtering

 

4. Advanced Charting

  • Chart formatting options
  • Combination charts
  • Graphical objects

 

5. PivotTables and PivotCharts

  • Working with PivotTables
  • Modifying PivotTable data
  • Formatting PivotTables
  • Using PivotCharts
  • PowerPivot

 

6. Exporting and Importing data

  • Exporting and importing text files

 

7. Analytical Tools

  • Goal Seek
  • Scenarios
  • Instant data analysis

 

Our goal is to make sure your training meets your objectives, not ours. Therefore, all of our outlines are used as guidelines for particular courses. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.