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  
29 Oct Sandton 0900 - 1600    R1695 Book
07 Nov Sandton 0900 - 1600    R1695 Book
26 Nov Sandton 0900 - 1600    R1695 Book
02 Dec Sandton 0900 - 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 Beginners 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

Good working knowledge of the Windows Operating System and proper IT skills

Excel Level 1 Course

1. Getting Started

  • Spreadsheet terminology
  • The Excel environment
  • Getting help
  • Navigating a worksheet

 

2. Entering and Editing Data

  • Entering and editing text and values
  • Entering and Editing formulas
  • Working with pictures
  • Saving and updating workbooks

 

3. Modifying a Worksheet

  • Moving and copying data
  • Moving and copying 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. Printing

  • Preparing to print
  • Page Setup options
  • Printing worksheets

 

7. Charts

  • Chart basics
  • Formatting charts

 

8. Managing large workbooks

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.


Course Date  City Course Times    Cost  
 
05 Nov Boksburg 0900 - 1600    R1695 Book
17 Nov Boksburg 0900 - 1600    R1695 Book
10 Dec Boksburg 0900 - 1600    R1695 Book
17 Dec Boksburg 0900 - 1600    R1695 Book
 
29 Oct Cape Town 0900 - 1600    R1695 Book
10 Nov Cape Town 0900 - 1600    R1695 Book
26 Nov Cape Town 0900 - 1600    R1695 Book
11 Dec Cape Town 0900 - 1600    R1695 Book
 
29 Oct Durban 0900 - 1600    R1695 Book
10 Nov Durban 0900 - 1600    R1695 Book
26 Nov Durban 0900 - 1600    R1695 Book
11 Dec Durban 0900 - 1600    R1695 Book
 
05 Nov Pretoria 0900 - 1600    R1695 Book
19 Nov Pretoria 0900 - 1600    R1695 Book
03 Dec Pretoria 0900 - 1600    R1695 Book
19 Dec Pretoria 0900 - 1600    R1695 Book
 
29 Oct Sandton 0900 - 1600    R1695 Book
07 Nov Sandton 0900 - 1600    R1695 Book
26 Nov Sandton 0900 - 1600    R1695 Book
02 Dec Sandton 0900 - 1600    R1695 Book


Course Date  City Course Times    Cost  
13 Nov Sandton 0900 - 1600    R1795 Book
08 Dec Sandton 0900 - 1600    R1795 Book

Excel Level 2 Course

Course Description

Microsoft Office Excel Intermediate is followed by Microsoft Office Excel: Beginners, 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, analyze data and work with Excel on the Web.

 

Prerequisites

Microsoft Office Excel: Beginners or equivalent working knowledge

Excel Level 2 Course

1. Using multiple worksheets and workbooks

  • Using multiple workbooks
  • Linking worksheets work 3-D formulas
  • Linking workbooks
  • Managing workbooks

 

2. Advanced formatting

  • Using Special number formats
  • Using functions to format text
  • Working with styles
  • 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. Tables

  • Sorting and filtering data
  • Advanced filtering
  • Working with tables

 

6. Web and sharing features

  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks

 

7. Advanced charting

  • Chart formatting options
  • Combination charts
  • Graphical elements

 

8. Documenting and auditing

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

 

9. Templates and settings

  • Application settings
  • Built-in templates
  • Creating and managing templates

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.


Course Date  City Course Times    Cost  
 
29 Oct Boksburg 0900 - 1600    R1795 Book
27 Nov Boksburg 0900 - 1600    R1795 Book
18 Dec Boksburg 0900 - 1600    R1795 Book
 
19 Nov Cape Town 0900 - 1600    R1795 Book
15 Dec Cape Town 0900 - 1600    R1795 Book
 
19 Nov Durban 0900 - 1600    R1795 Book
15 Dec Durban 0900 - 1600    R1795 Book
 
27 Oct Pretoria 0900 - 1600    R1795 Book
24 Nov Pretoria 0900 - 1600    R1795 Book
 
13 Nov Sandton 0900 - 1600    R1795 Book
08 Dec Sandton 0900 - 1600    R1795 Book

Excel Level 3 Course

Course Description

Microsoft Office Excel Advanced courses are followed by Microsoft Excel: Beginners and Microsoft Excel: Intermediate, this course will extend your knowledge into some of the more specialised 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

Microsoft Office Excel: Beginners and Microsoft Excel: Intermediate or equivalent working knowledge

Excel Level 3 Course

1. Advanced functions

  • Logical functions
  • Math and statistical functions
  • Financial functions
  • Displaying and printing formula

 

2. Lookups and data tables

  • Using lookup functions
  • Using MATCH and INDEX
  • Creating data table

 

3. Advanced data management

  • Validating cell entries
  • Exploring database functions

 

4. PivotTables and PivotCharts

  • Working with PivotTables
  • Rearranging Pivot Tables
  • Formatting PivotTables
  • PivotCharts

 

5. Exporting and importing

  • Exporting and importing text files
  • Exporting and importing XML data
  • Querying external databases

 

6. Analytical Tools

  • Goal seek and solver
  • The Analysis Toolpak
  • Scenarios
  • Views

 

7. Macros and custom functions

  • Running and recording a macro
  • Working with VBA Code
  • Creating functions

 

8. Conditional formatting and SmartArt graphics

  • Conditional formatting with graphics
  • SmartArt graphics

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Course Date  City Course Times    Cost  
 
30 Oct Boksburg 0900 - 1600    R1995 Book
28 Nov Boksburg 0900 - 1600    R1995 Book
19 Dec Boksburg 0900 - 1600    R1995 Book
 
20 Nov Cape Town 0900 - 1600    R1995 Book
17 Dec Cape Town 0900 - 1600    R1995 Book
 
20 Nov Durban 0900 - 1600    R1995 Book
17 Dec Durban 0900 - 1600    R1995 Book
 
28 Oct Pretoria 0900 - 1600    R1995 Book
25 Nov Pretoria 0900 - 1600    R1995 Book
 
14 Nov Sandton 0900 - 1600    R1995 Book
09 Dec Sandton 0900 - 1600    R1995 Book