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

Microsoft Excel courses
in Johannesburg

 


 


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


Course Date  City Course Times    Cost  
17 Jul Sandton 0830 - 1600    R1795 Book
21 Aug Sandton 0830 - 1600    R1795 Book
18 Sep Sandton 0830 - 1600    R1795 Book
16 Oct Sandton 0830 - 1600    R1795 Book
13 Nov Sandton 0830 - 1600    R1795 Book
11 Dec Sandton 0830 - 1600    R1795 Book

 


We offer all of these courses in Johannesburg.

Access training courses in Sandton
Excel training courses in Sandton
Outlook training courses in Sandton
Powerpoint training courses in Sandton
Project training courses in Sandton
Publisher training courses in Sandton
Sharepoint training courses in Sandton
SQL Server training courses in Sandton
Visio training courses in Sandton
Word training courses in Sandton
HTML training courses in Sandton
PHP training courses in Sandton
Java training courses in Sandton
JavaScript training courses in Sandton
SQL training courses in Sandton

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

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  
 
04 Jul Bloemfontein 0830 - 1600    R1795 Book
01 Aug Bloemfontein 0830 - 1600    R1795 Book
06 Sep Bloemfontein 0830 - 1600    R1795 Book
04 Oct Bloemfontein 0830 - 1600    R1795 Book
06 Nov Bloemfontein 0830 - 1600    R1795 Book
07 Dec Bloemfontein 0830 - 1600    R1795 Book
 
18 Jul Boksburg 0830 - 1600    R1795 Book
23 Aug Boksburg 0830 - 1600    R1795 Book
27 Sep Boksburg 0830 - 1600    R1795 Book
25 Oct Boksburg 0830 - 1600    R1795 Book
29 Nov Boksburg 0830 - 1600    R1795 Book
11 Dec Boksburg 0830 - 1600    R1795 Book
 
05 Jul Cape Town 0830 - 1600    R1795 Book
06 Jul Cape Town 0830 - 1600    R1795 Book
18 Jul Cape Town 0830 - 1600    R1795 Book
03 Aug Cape Town 0830 - 1600    R1795 Book
07 Aug Cape Town 0830 - 1600    R1795 Book
18 Aug Cape Town 0830 - 1600    R1795 Book
05 Sep Cape Town 0830 - 1600    R1795 Book
04 Oct Cape Town 0830 - 1600    R1795 Book
02 Nov Cape Town 0830 - 1600    R1795 Book
 
06 Jul Durban 0830 - 1600    R1795 Book
27 Jul Durban 0830 - 1600    R1795 Book
17 Aug Durban 0830 - 1600    R1795 Book
05 Sep Durban 0830 - 1600    R1795 Book
22 Sep Durban 0830 - 1600    R1795 Book
12 Oct Durban 0830 - 1600    R1795 Book
 
10 Jul Midrand 0830 - 1600    R1795 Book
21 Aug Midrand 0830 - 1600    R1795 Book
30 Aug Midrand 0830 - 1600    R1795 Book
18 Sep Midrand 0830 - 1600    R1795 Book
16 Oct Midrand 0830 - 1600    R1795 Book
25 Oct Midrand 0830 - 1600    R1795 Book
13 Nov Midrand 0830 - 1600    R1795 Book
22 Nov Midrand 0830 - 1600    R1795 Book
11 Dec Midrand 0830 - 1600    R1795 Book
20 Dec Midrand 0830 - 1600    R1795 Book
 
03 Jul Nelspruit 0830 - 1600    R1795 Book
01 Aug Nelspruit 0830 - 1600    R1795 Book
04 Sep Nelspruit 0830 - 1600    R1795 Book
02 Oct Nelspruit 0830 - 1600    R1795 Book
01 Nov Nelspruit 0830 - 1600    R1795 Book
11 Dec Nelspruit 0830 - 1600    R1795 Book
 
10 Jul Polokwane 0830 - 1600    R1795 Book
14 Aug Polokwane 0830 - 1600    R1795 Book
11 Sep Polokwane 0830 - 1600    R1795 Book
09 Oct Polokwane 0830 - 1600    R1795 Book
13 Nov Polokwane 0830 - 1600    R1795 Book
18 Dec Polokwane 0830 - 1600    R1795 Book
 
18 Jul Port Elizabeth 0830 - 1600    R1795 Book
22 Aug Port Elizabeth 0830 - 1600    R1795 Book
20 Sep Port Elizabeth 0830 - 1600    R1795 Book
26 Oct Port Elizabeth 0830 - 1600    R1795 Book
22 Nov Port Elizabeth 0830 - 1600    R1795 Book
05 Dec Port Elizabeth 0830 - 1600    R1795 Book
 
12 Jul Pretoria 0830 - 1600    R1795 Book
31 Jul Pretoria 0830 - 1600    R1795 Book
16 Aug Pretoria 0830 - 1600    R1795 Book
04 Sep Pretoria 0830 - 1600    R1795 Book
02 Oct Pretoria 0830 - 1600    R1795 Book
11 Oct Pretoria 0830 - 1600    R1795 Book
30 Oct Pretoria 0830 - 1600    R1795 Book
08 Nov Pretoria 0830 - 1600    R1795 Book
27 Nov Pretoria 0830 - 1600    R1795 Book
05 Dec Pretoria 0830 - 1600    R1795 Book
 
17 Jul Sandton 0830 - 1600    R1795 Book
21 Aug Sandton 0830 - 1600    R1795 Book
18 Sep Sandton 0830 - 1600    R1795 Book
16 Oct Sandton 0830 - 1600    R1795 Book
13 Nov Sandton 0830 - 1600    R1795 Book
11 Dec Sandton 0830 - 1600    R1795 Book
 
04 Jul Stellenbosch 0900 - 1600    R1795 Book
22 Aug Stellenbosch 0830 - 1600    R1795 Book
13 Sep Stellenbosch 0830 - 1600    R1795 Book
09 Oct Stellenbosch 0900 - 1600    R1795 Book
13 Nov Stellenbosch 0900 - 1600    R1795 Book
04 Dec Stellenbosch 0830 - 1600    R1795 Book
 
31 Jul Vereeniging 0830 - 1600    R1795 Book
29 Aug Vereeniging 0830 - 1600    R1795 Book
27 Sep Vereeniging 0830 - 1600    R1795 Book
31 Oct Vereeniging 0830 - 1600    R1795 Book
29 Nov Vereeniging 0830 - 1600    R1795 Book
05 Dec Vereeniging 0830 - 1600    R1795 Book


Course Date  City Course Times    Cost  
18 Jul Sandton 0830 - 1600    R1895 Book
22 Aug Sandton 0830 - 1600    R1895 Book
28 Sep Sandton 0830 - 1600    R1895 Book
12 Oct Sandton 0830 - 1600    R1895 Book
14 Nov Sandton 0830 - 1600    R1895 Book
12 Dec 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

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  
 
24 Jul Bloemfontein 0830 - 1600    R1895 Book
22 Aug Bloemfontein 0830 - 1600    R1895 Book
26 Sep Bloemfontein 0830 - 1600    R1895 Book
24 Oct Bloemfontein 0830 - 1600    R1895 Book
28 Nov Bloemfontein 0830 - 1600    R1895 Book
 
04 Jul Boksburg 0830 - 1600    R1895 Book
01 Aug Boksburg 0830 - 1600    R1895 Book
05 Sep Boksburg 0830 - 1600    R1895 Book
10 Oct Boksburg 0830 - 1600    R1895 Book
13 Nov Boksburg 0830 - 1600    R1895 Book
 
10 Jul Cape Town 0830 - 1600    R1895 Book
20 Jul Cape Town 0830 - 1600    R1895 Book
15 Aug Cape Town 0830 - 1600    R1895 Book
22 Aug Cape Town 0830 - 1600    R1895 Book
30 Aug Cape Town 0830 - 1600    R1895 Book
19 Sep Cape Town 0830 - 1600    R1895 Book
16 Oct Cape Town 0830 - 1600    R1895 Book
09 Nov Cape Town 0830 - 1600    R1895 Book
 
07 Jul Durban 0830 - 1600    R1895 Book
24 Jul Durban 0830 - 1600    R1895 Book
07 Aug Durban 0830 - 1600    R1895 Book
24 Aug Durban 0830 - 1600    R1895 Book
 
11 Jul Midrand 0830 - 1600    R1895 Book
10 Aug Midrand 0830 - 1600    R1895 Book
22 Aug Midrand 0830 - 1600    R1895 Book
08 Sep Midrand 0830 - 1600    R1895 Book
19 Sep Midrand 0830 - 1600    R1895 Book
28 Sep Midrand 0830 - 1600    R1895 Book
12 Oct Midrand 0830 - 1600    R1895 Book
17 Oct Midrand 0830 - 1600    R1895 Book
14 Nov Midrand 0830 - 1600    R1895 Book
01 Dec Midrand 0830 - 1600    R1895 Book
12 Dec Midrand 0830 - 1600    R1895 Book
 
19 Jul Nelspruit 0830 - 1600    R1895 Book
21 Aug Nelspruit 0830 - 1600    R1895 Book
19 Sep Nelspruit 0830 - 1600    R1895 Book
16 Oct Nelspruit 0830 - 1600    R1895 Book
21 Nov Nelspruit 0830 - 1600    R1895 Book
11 Dec Nelspruit 0830 - 1600    R1895 Book
 
12 Jul Port Elizabeth 0830 - 1600    R1895 Book
09 Aug Port Elizabeth 0830 - 1600    R1895 Book
05 Sep Port Elizabeth 0830 - 1600    R1895 Book
18 Oct Port Elizabeth 0830 - 1600    R1895 Book
15 Nov Port Elizabeth 0830 - 1600    R1895 Book
05 Dec Port Elizabeth 0830 - 1600    R1795 Book
 
27 Jul Pretoria 0830 - 1600    R1895 Book
01 Aug Pretoria 0830 - 1600    R1895 Book
25 Aug Pretoria 0830 - 1600    R1895 Book
05 Sep Pretoria 0830 - 1600    R1895 Book
03 Oct Pretoria 0830 - 1600    R1895 Book
27 Oct Pretoria 0830 - 1600    R1895 Book
31 Oct Pretoria 0830 - 1600    R1895 Book
28 Nov Pretoria 0830 - 1600    R1895 Book
21 Dec Pretoria 0830 - 1600    R1895 Book
 
18 Jul Sandton 0830 - 1600    R1895 Book
22 Aug Sandton 0830 - 1600    R1895 Book
28 Sep Sandton 0830 - 1600    R1895 Book
12 Oct Sandton 0830 - 1600    R1895 Book
14 Nov Sandton 0830 - 1600    R1895 Book
12 Dec Sandton 0830 - 1600    R1895 Book
 
12 Jul Stellenbosch 0830 - 1600    R1895 Book
15 Aug Stellenbosch 0830 - 1600    R1895 Book
04 Sep Stellenbosch 0830 - 1600    R1895 Book
05 Oct Stellenbosch 0830 - 1600    R1895 Book
22 Nov Stellenbosch 0900 - 1600    R1895 Book
01 Dec Stellenbosch 0830 - 1600    R1895 Book
 
04 Jul Vereeniging 0830 - 1600    R1895 Book
08 Aug Vereeniging 0830 - 1600    R1895 Book
05 Sep Vereeniging 0830 - 1600    R1895 Book
17 Oct Vereeniging 0830 - 1600    R1895 Book
07 Nov Vereeniging 0830 - 1600    R1895 Book
12 Dec Vereeniging 0830 - 1600    R1895 Book


Course Date  City Course Times    Cost  
19 Jul Sandton 0830 - 1600    R1995 Book
11 Aug Sandton 0830 - 1600    R1995 Book
14 Sep Sandton 0830 - 1600    R1995 Book
18 Oct Sandton 0830 - 1600    R1995 Book
15 Nov Sandton 0830 - 1600    R1995 Book
13 Dec Sandton 0830 - 1600    R1995 Book

 


We offer all of these courses in Johannesburg.

Access training courses in Sandton
Excel training courses in Sandton
Outlook training courses in Sandton
Powerpoint training courses in Sandton
Project training courses in Sandton
Publisher training courses in Sandton
Sharepoint training courses in Sandton
SQL Server training courses in Sandton
Visio training courses in Sandton
Word training courses in Sandton
HTML training courses in Sandton
PHP training courses in Sandton
Java training courses in Sandton
JavaScript training courses in Sandton
SQL training courses in Sandton

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

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.

Course Date  City Course Times    Cost  
 
07 Jul Bloemfontein 0830 - 1600    R1995 Book
18 Aug Bloemfontein 0830 - 1600    R1995 Book
22 Sep Bloemfontein 0830 - 1600    R1995 Book
27 Oct Bloemfontein 0830 - 1600    R1995 Book
24 Nov Bloemfontein 0830 - 1600    R1995 Book
 
31 Jul Boksburg 0830 - 1600    R1995 Book
28 Aug Boksburg 0830 - 1600    R1995 Book
25 Sep Boksburg 0830 - 1600    R1995 Book
30 Oct Boksburg 0830 - 1600    R1995 Book
27 Nov Boksburg 0830 - 1600    R1995 Book
 
17 Jul Cape Town 0830 - 1600    R1995 Book
26 Jul Cape Town 0830 - 1600    R1995 Book
27 Jul Cape Town 0830 - 1600    R1995 Book
24 Aug Cape Town 0830 - 1600    R1995 Book
31 Aug Cape Town 0830 - 1600    R1995 Book
29 Sep Cape Town 0830 - 1600    R1995 Book
26 Oct Cape Town 0830 - 1600    R1995 Book
28 Nov Cape Town 0830 - 1600    R1995 Book
 
12 Jul Durban 0830 - 1600    R1995 Book
11 Aug Durban 0830 - 1600    R1995 Book
30 Aug Durban 0830 - 1600    R1995 Book
12 Sep Durban 0830 - 1600    R1995 Book
20 Sep Durban 0830 - 1600    R1995 Book
09 Oct Durban 0830 - 1600    R1995 Book
31 Oct Durban 0830 - 1600    R1995 Book
 
12 Jul Midrand 0830 - 1600    R1995 Book
11 Aug Midrand 0830 - 1600    R1995 Book
23 Aug Midrand 0830 - 1600    R1995 Book
14 Sep Midrand 0830 - 1600    R1995 Book
20 Sep Midrand 0830 - 1600    R1995 Book
13 Oct Midrand 0830 - 1600    R1995 Book
18 Oct Midrand 0830 - 1600    R1995 Book
15 Nov Midrand 0830 - 1600    R1995 Book
08 Dec Midrand 0830 - 1600    R1995 Book
13 Dec Midrand 0830 - 1600    R1995 Book
 
03 Jul Nelspruit 0830 - 1600    R1995 Book
07 Aug Nelspruit 0830 - 1600    R1995 Book
04 Sep Nelspruit 0830 - 1600    R1995 Book
09 Oct Nelspruit 0830 - 1600    R1995 Book
06 Nov Nelspruit 0830 - 1600    R1995 Book
04 Dec Nelspruit 0830 - 1600    R1995 Book
 
12 Jul Polokwane 0830 - 1600    R1995 Book
16 Aug Polokwane 0830 - 1600    R1995 Book
13 Sep Polokwane 0830 - 1600    R1995 Book
18 Oct Polokwane 0830 - 1600    R1995 Book
15 Nov Polokwane 0830 - 1600    R1995 Book
 
25 Jul Port Elizabeth 0830 - 1600    R1995 Book
23 Aug Port Elizabeth 0830 - 1600    R1995 Book
28 Sep Port Elizabeth 0830 - 1600    R1995 Book
26 Oct Port Elizabeth 0830 - 1600    R1995 Book
 
28 Jul Pretoria 0830 - 1600    R1995 Book
02 Aug Pretoria 0830 - 1600    R1995 Book
31 Aug Pretoria 0830 - 1600    R1995 Book
06 Sep Pretoria 0830 - 1600    R1995 Book
29 Sep Pretoria 0830 - 1600    R1995 Book
04 Oct Pretoria 0830 - 1600    R1995 Book
01 Nov Pretoria 0830 - 1600    R1995 Book
03 Nov Pretoria 0830 - 1600    R1995 Book
29 Nov Pretoria 0830 - 1600    R1995 Book
22 Dec Pretoria 0830 - 1600    R1995 Book
 
19 Jul Sandton 0830 - 1600    R1995 Book
11 Aug Sandton 0830 - 1600    R1995 Book
14 Sep Sandton 0830 - 1600    R1995 Book
18 Oct Sandton 0830 - 1600    R1995 Book
15 Nov Sandton 0830 - 1600    R1995 Book
13 Dec Sandton 0830 - 1600    R1995 Book
 
18 Jul Stellenbosch 0830 - 1600    R1995 Book
15 Aug Stellenbosch 0900 - 1600    R1995 Book
19 Sep Stellenbosch 0830 - 1600    R1995 Book
31 Oct Stellenbosch 0900 - 1600    R1995 Book
21 Nov Stellenbosch 0830 - 1600    R1995 Book
05 Dec Stellenbosch 0830 - 1600    R1995 Book
 
07 Jul Vereeniging 0830 - 1600    R1995 Book
11 Aug Vereeniging 0830 - 1600    R1995 Book
08 Sep Vereeniging 0830 - 1600    R1995 Book
13 Oct Vereeniging 0830 - 1600    R1995 Book
10 Nov Vereeniging 0830 - 1600    R1995 Book
08 Dec Vereeniging 0830 - 1600    R1995 Book