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  
August        
27 Aug Sandton 0900 - 1600    R1695 Book
September        
08 Sep Sandton 0900 - 1600    R1695 Book
October        
01 Oct Sandton 0900 - 1600    R1695 Book
09 Oct Sandton 0900 - 1600    R1695 Book
29 Oct Sandton 0900 - 1600    R1695 Book
November        
07 Nov Sandton 0900 - 1600    R1695 Book
26 Nov Sandton 0900 - 1600    R1695 Book
December        
02 Dec Sandton 0900 - 1600    R1695 Book

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. Setting Up a Workbook

  • Creating Workbooks
  • Excel Environment
  • Customising Quick Access Toolbar
  • Creating a New Workbook
  • Entering Data into Workbook
  • Saving a workbook
  • Open a workbook
  • Zoom
  • Insert a new worksheet
  • Renaming a new worksheet
  • Changing the tab colour of worksheet
  • Rearranging the order of worksheets
  • Move or Copy worksheets
  • Hide / Unhide Worksheets
  • Switch windows
  • Modifying Workbooks and Worksheets
    • Changing column widths and row heights
    • Insert Columns / Rows
    • Delete Columns / Rows
    • Hide / Unhide columns or rows
    • Insert Cells
    • Moving Data by dragging

 

2. Working with Data and Excel Tables

  • Entering Data
  • Copy, Cut and Paste
  • Pick from drop down list
  • Find and Replace data
  • Spell Check
  • Thesaurus
  • Defining an Excel Table
    • Format as table
    • Table design
    • Basic Formulas
    • How to create a basic formula
    • Operators
    • Copy formula down
    • Absolute cell reference
    • Basic Functions
      • What is the difference between formulas and functions
      • Insert a function
      • Autosum, sum, min, max and average

 

3. Changing Workbook Appearance

  • Format Cells
    • Changing Font, Font size and Font Colour
    • Borders
    • Bolt, Italic and Underline
    • Fill Colour
  • Themes
  • Format Numbers as percentage, currency and general
  • Insert a Picture
  • Picture Styles, remove background, picture effects
  • Insert Background

 

4. Printing

  • Inserting Headers and Footers
  • Print Preview
  • Page Setup
  • Page break preview
  • Print active worksheets
  • Print entire workbook
  • Print Selection
  • Print titles
  • Set Print area
  • Centre data on page

 

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  
       
26 Aug Boksburg 0900 - 1600    R1695 Book
       
10 Sep Boksburg 0900 - 1600    R1695 Book
       
25 Sep Boksburg 0900 - 1600    R1695 Book
       
08 Oct Boksburg 0900 - 1600    R1695 Book
       
24 Oct Boksburg 0900 - 1600    R1695 Book
       
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
       
03 Sep Cape Town 0900 - 1600    R1695 Book
       
15 Sep Cape Town 0900 - 1600    R1695 Book
       
01 Oct Cape Town 0900 - 1600    R1695 Book
       
17 Oct Cape Town 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
       
03 Sep Durban 0900 - 1600    R1695 Book
       
15 Sep Durban 0900 - 1600    R1695 Book
       
15 Sep Durban 0900 - 1600    R1695 Book
       
01 Oct Durban 0900 - 1600    R1695 Book
       
17 Oct Durban 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
       
03 Sep Pretoria 0900 - 1600    R1695 Book
       
19 Sep Pretoria 0900 - 1600    R1695 Book
       
08 Oct Pretoria 0900 - 1600    R1695 Book
       
22 Oct Pretoria 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
       
27 Aug Sandton 0900 - 1600    R1695 Book
       
08 Sep Sandton 0900 - 1600    R1695 Book
       
01 Oct Sandton 0900 - 1600    R1695 Book
       
09 Oct Sandton 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  
September        
16 Sep Sandton 0900 - 1600    R1795 Book
October        
14 Oct Sandton 0900 - 1600    R1795 Book
November        
13 Nov Sandton 0900 - 1600    R1795 Book
December        
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. Performing Calculations

  • Naming groups of Data using Named Ranges
  • Creating Formulas to Calculate Values
  • Summarizing data meets specific condition using If function
  • Formula Auditing
    • Adding a watch Window
    • Tracing Formula Errors
    • Tracing Precedents and Dependent cells

 

2. Changing Workbook Appearance

  • Defining Styles
  • Making Numbers easier to read
  • Transposing data
  • Changing Cell Orientation and Merging Cells
  • Change appearance of data based on its value
  • Focusing on specific data by using filters:
    • Inserting Filters
    • Sort A to Z using Filters
    • Number Filters
    • Clear Filters
    • Advanced Filtering (Criteria Range)
    • Summarizing worksheets with hidden and filtered rows (subtotal and aggregate functions)
  • Data Validation

 

3. Reordering and Summarizing Data

  • Sort Data
  • Custom Lists
  • Organizing data into levels using subtotals
  • Creating an outline
  • Lookup Functions

 

4. Combining Data from Multiple Sources

  • Using Excel's Built-in Templates
  • Using workbooks as templates for other workbooks
  • Linking to data in other workbooks
  • Consolidating data
  • Saving workbooks as a workspace
  • Comments in cells and workbooks:
    • Viewing Comments in a worksheet
    • Adding and Removing comments
    • Adding comments to a workbook
  • Protection:
    • Password protect a worksheet and workbook
    • Unlock cells and protecting part of a worksheet
  • Track Changes
  • Mark a workbook as final

 

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  
       
04 Sep Boksburg 0900 - 1600    R1795 Book
       
02 Oct Boksburg 0900 - 1600    R1795 Book
       
29 Oct Boksburg 0900 - 1600    R1795 Book
       
27 Nov Boksburg 0900 - 1600    R1795 Book
       
18 Dec Boksburg 0900 - 1600    R1795 Book
       
28 Aug Cape Town 0900 - 1600    R1795 Book
       
22 Sep Cape Town 0900 - 1600    R1795 Book
       
21 Oct Cape Town 0900 - 1600    R1795 Book
       
19 Nov Cape Town 0900 - 1600    R1795 Book
       
15 Dec Cape Town 0900 - 1600    R1795 Book
       
28 Aug Durban 0900 - 1600    R1795 Book
       
22 Sep Durban 0900 - 1600    R1795 Book
       
21 Oct Durban 0900 - 1600    R1795 Book
       
19 Nov Durban 0900 - 1600    R1795 Book
       
15 Dec Durban 0900 - 1600    R1795 Book
       
15 Dec Durban 0900 - 1600    R1795 Book
       
26 Aug Pretoria 0900 - 1600    R1795 Book
       
23 Sep Pretoria 0900 - 1600    R1795 Book
       
27 Oct Pretoria 0900 - 1600    R1795 Book
       
24 Nov Pretoria 0900 - 1600    R1795 Book
       
16 Sep Sandton 0900 - 1600    R1795 Book
       
14 Oct Sandton 0900 - 1600    R1795 Book
       
13 Nov Sandton 0900 - 1600    R1795 Book
       
08 Dec Sandton 0900 - 1600    R1795 Book

Sorry, we currently do not have any public courses scheduled for the Excel level 3 course in Johannesburg. Please contact us to see if we can put one on the schedule for you

Excel Level 3 Course

Course Description

Microsoft Office Excel Advanced courses is followed by Microsoft Excel: Beginners and Microsoft Excel: Intermediate, 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

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

Excel Level 3 Course

1. Analysing Alternative Data Sets

  • Define an alternative data set using Scenario Manager and Scenario Summary
  • Vary your data to get an alternative result using Goal Seek
  • Find optimal solutions using Solver
  • Analysing Data by using descriptive statistics
  • Creating custom views and switching between them

 

2. Advanced Functions

  • If Statements
  • Using Other functions such as And, Or, Not with your If statements
  • Nested If Statement
  • SumIf, CountIf, AverageIf
  • Rounding off your figures using the Round function
  • PMT Function
  • Showing / Hiding Formulas

 

3. Creating Dynamic Worksheets by Using Pivot Tables

  • Working with Pivot Tables:
    • Adding Fields to Pivot Tables
    • Filter, Show and Hide Pivot Table data
    • Using Slicers to filter data
  • Rearranging Pivot Tables:
    • Moving fields
    • Collapsing and Expanding Fields
    • Refreshing Data
  • Editing Pivot Table:
    • Show Value As
    • Get Pivot Data function
    • Adding Subtotals and Grand Totals
    • Formatting field settings
    • Applying a Pivot Table Style
    • Creating a new custom Pivot table Style
    • Creating Pivot Tables from external data import

 

4. Creating Charts and Graphics

  • Creating Charts
  • Customising the appearance of charts
  • Find trends in your data using Trendlines
  • Summarise your data using Sparklines
  • Create dynamic charts using Pivot Charts
  • Create diagrams using Smart Art
  • Insert Shapes and Mathematical Equations

 

5. Automation of Repetitive Tasks Using Macros

  • Enabling and Examining Macros
  • Creating Macros
  • Editing Macros
  • Add Macros button to Quick Access Toolbar
  • Run a macro when a workbook is opened

 

6. Working with Other Microsoft Office Programs

  • Linking / Embedding other office files
  • Hyperlinking
  • Pasting charts into other documents

 

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 Sep Boksburg 0900 - 1600    R1995 Book
       
30 Oct Boksburg 0900 - 1600    R1995 Book
       
28 Nov Boksburg 0900 - 1600    R1995 Book
       
19 Dec Boksburg 0900 - 1600    R1995 Book
       
29 Aug Cape Town 0900 - 1600    R1995 Book
       
23 Sep Cape Town 0900 - 1600    R1995 Book
       
22 Oct Cape Town 0900 - 1600    R1995 Book
       
20 Nov Cape Town 0900 - 1600    R1995 Book
       
17 Dec Cape Town 0900 - 1600    R1995 Book
       
29 Aug Durban 0900 - 1600    R1995 Book
       
23 Sep Durban 0900 - 1600    R1995 Book
       
22 Oct Durban 0900 - 1600    R1995 Book
       
20 Nov Durban 0900 - 1600    R1995 Book
       
17 Dec Durban 0900 - 1600    R1995 Book
       
28 Aug Pretoria 0900 - 1600    R1995 Book
       
25 Sep Pretoria 0900 - 1600    R1995 Book
       
28 Oct Pretoria 0900 - 1600    R1995 Book
       
25 Nov Pretoria 0900 - 1600    R1995 Book
       
17 Sep Sandton 0900 - 1600    R1995 Book
       
15 Oct Sandton 0900 - 1600    R1995 Book
       
14 Nov Sandton 0900 - 1600    R1995 Book
       
09 Dec Sandton 0900 - 1600    R1995 Book