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  
14 Jan Sandton 0830 - 1600    R1695 Book
11 Feb Sandton 0830 - 1600    R1695 Book
11 Mar Sandton 0830 - 1600    R1695 Book
15 Apr Sandton 0830 - 1600    R1695 Book
13 May Sandton 0830 - 1600    R1695 Book
10 Jun Sandton 0830 - 1600    R1695 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 Basic 2013 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  
 
07 Jan Boksburg 0830 - 1600    R1695 Book
04 Feb Boksburg 0830 - 1600    R1695 Book
04 Mar Boksburg 0830 - 1600    R1695 Book
25 Mar Boksburg 0830 - 1600    R1695 Book
13 Apr Boksburg 0830 - 1600    R1695 Book
06 May Boksburg 0830 - 1600    R1695 Book
27 May Boksburg 0830 - 1600    R1695 Book
11 Jun Boksburg 0830 - 1600    R1695 Book
 
21 Jan Cape Town 0830 - 1600    R1695 Book
31 Jan Cape Town 0830 - 1600    R1695 Book
04 Feb Cape Town 0830 - 1600    R1695 Book
18 Feb Cape Town 0830 - 1600    R1695 Book
06 Mar Cape Town 0830 - 1600    R1695 Book
18 Mar Cape Town 0830 - 1600    R1695 Book
28 Mar Cape Town 0830 - 1600    R1695 Book
30 Mar Cape Town 0830 - 1600    R1695 Book
09 May Cape Town 0830 - 1600    R1695 Book
27 Jun Cape Town 0830 - 1600    R1695 Book
 
21 Jan Durban 0830 - 1600    R1695 Book
31 Jan Durban 0830 - 1600    R1695 Book
04 Feb Durban 0830 - 1600    R1695 Book
18 Feb Durban 0830 - 1600    R1695 Book
06 Mar Durban 0830 - 1600    R1695 Book
18 Mar Durban 0830 - 1600    R1695 Book
28 Mar Durban 0830 - 1600    R1695 Book
30 Mar Durban 0830 - 1600    R1695 Book
09 May Durban 0830 - 1600    R1695 Book
27 Jun Durban 0830 - 1600    R1695 Book
 
21 Jan Pretoria 0830 - 1600    R1695 Book
05 Feb Pretoria 0830 - 1600    R1695 Book
18 Feb Pretoria 0830 - 1600    R1695 Book
03 Mar Pretoria 0830 - 1600    R1695 Book
18 Mar Pretoria 0830 - 1600    R1695 Book
02 Apr Pretoria 0830 - 1600    R1695 Book
22 Apr Pretoria 0830 - 1600    R1695 Book
05 May Pretoria 0830 - 1600    R1695 Book
20 May Pretoria 0830 - 1600    R1695 Book
04 Jun Pretoria 0830 - 1600    R1695 Book
 
14 Jan Sandton 0830 - 1600    R1695 Book
11 Feb Sandton 0830 - 1600    R1695 Book
11 Mar Sandton 0830 - 1600    R1695 Book
15 Apr Sandton 0830 - 1600    R1695 Book
13 May Sandton 0830 - 1600    R1695 Book
10 Jun Sandton 0830 - 1600    R1695 Book
 
12 Jan Woodmead 0830 - 1600    R1695 Book
02 Feb Woodmead 0830 - 1600    R1695 Book
02 Mar Woodmead 0830 - 1600    R1695 Book
16 Mar Woodmead 0900 - 1600    R1695 Book
06 Apr Woodmead 0830 - 1600    R1695 Book
20 Apr Woodmead 0830 - 1600    R1695 Book
04 May Woodmead 0830 - 1600    R1695 Book
01 Jun Woodmead 0830 - 1600    R1695 Book
15 Jun Woodmead 0830 - 1600    R1695 Book
06 Jul Woodmead 0830 - 1600    R1695 Book
20 Jul Woodmead 0830 - 1600    R1695 Book
03 Aug Woodmead 0830 - 1600    R1695 Book
07 Sep Woodmead 0830 - 1600    R1695 Book
21 Sep Woodmead 0830 - 1600    R1695 Book


Course Date  City Course Times    Cost  
20 Jan Sandton 0830 - 1600    R1795 Book
16 Feb Sandton 0830 - 1600    R1795 Book
18 Mar Sandton 0830 - 1600    R1795 Book
14 Apr Sandton 0830 - 1600    R1795 Book
18 May Sandton 0830 - 1600    R1795 Book
17 Jun Sandton 0830 - 1600    R1795 Book

Excel Level 2 Course

Course Description

Microsoft Office Excel Basic 2013 is followed by Microsoft Office Excel Intermediate 2013, 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  
 
27 Jan Boksburg 0830 - 1600    R1795 Book
05 Mar Boksburg 0830 - 1600    R1795 Book
07 Apr Boksburg 0830 - 1600    R1795 Book
14 May Boksburg 0830 - 1600    R1795 Book
15 Jun Boksburg 0830 - 1600    R1795 Book
23 Jul Boksburg 0830 - 1600    R1795 Book
 
07 Feb Cape Town 0830 - 1600    R1795 Book
13 Feb Cape Town 0830 - 1600    R1795 Book
10 Mar Cape Town 0830 - 1600    R1795 Book
08 Apr Cape Town 0830 - 1600    R1795 Book
11 Apr Cape Town 0830 - 1600    R1795 Book
07 May Cape Town 0830 - 1600    R1795 Book
16 May Cape Town 0830 - 1600    R1795 Book
 
07 Feb Durban 0830 - 1600    R1795 Book
13 Feb Durban 0830 - 1600    R1795 Book
10 Mar Durban 0830 - 1600    R1795 Book
08 Apr Durban 0830 - 1600    R1795 Book
11 Apr Durban 0830 - 1600    R1795 Book
07 May Durban 0830 - 1600    R1795 Book
16 May Durban 0830 - 1600    R1795 Book
 
29 Jan Pretoria 0830 - 1600    R1795 Book
23 Feb Pretoria 0830 - 1600    R1795 Book
25 Mar Pretoria 0830 - 1600    R1795 Book
29 Apr Pretoria 0830 - 1600    R1795 Book
26 May Pretoria 0830 - 1600    R1795 Book
01 Jul Pretoria 0830 - 1600    R1795 Book
 
20 Jan Sandton 0830 - 1600    R1795 Book
16 Feb Sandton 0830 - 1600    R1795 Book
18 Mar Sandton 0830 - 1600    R1795 Book
14 Apr Sandton 0830 - 1600    R1795 Book
18 May Sandton 0830 - 1600    R1795 Book
17 Jun Sandton 0830 - 1600    R1795 Book

Excel Level 3 Course

Course Description

Microsoft Office Excel Intermediate 2013 course is followed by Microsoft Office Excel Advanced 2013, 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  
 
28 Jan Boksburg 0830 - 1600    R1995 Book
06 Mar Boksburg 0830 - 1600    R1995 Book
09 Apr Boksburg 0830 - 1600    R1995 Book
15 May Boksburg 0830 - 1600    R1995 Book
18 Jun Boksburg 0830 - 1600    R1995 Book
 
14 Feb Cape Town 0830 - 1600    R1995 Book
16 Feb Cape Town 0830 - 1600    R1995 Book
11 Mar Cape Town 0830 - 1600    R1995 Book
09 Apr Cape Town 0830 - 1600    R1995 Book
08 May Cape Town 0830 - 1600    R1995 Book
23 May Cape Town 0830 - 1600    R1995 Book
11 Jul Cape Town 0830 - 1600    R1995 Book
 
14 Feb Durban 0830 - 1600    R1995 Book
16 Feb Durban 0830 - 1600    R1995 Book
11 Mar Durban 0830 - 1600    R1995 Book
09 Apr Durban 0830 - 1600    R1995 Book
08 May Durban 0830 - 1600    R1995 Book
23 May Durban 0830 - 1600    R1995 Book
11 Jul Durban 0830 - 1600    R1995 Book
 
30 Jan Pretoria 0830 - 1600    R1995 Book
24 Feb Pretoria 0830 - 1600    R1995 Book
27 Mar Pretoria 0830 - 1600    R1995 Book
30 Apr Pretoria 0830 - 1600    R1995 Book
28 May Pretoria 0830 - 1600    R1995 Book
02 Jul Pretoria 0830 - 1600    R1995 Book
 
22 Jan Sandton 0830 - 1600    R1995 Book
18 Feb Sandton 0830 - 1600    R1995 Book
20 Mar Sandton 0830 - 1600    R1995 Book
16 Apr Sandton 0830 - 1600    R1995 Book
21 May Sandton 0830 - 1600    R1995 Book
19 Jun Sandton 0830 - 1600    R1995 Book