Excel courses logo

Microsoft Excel courses
in Stellenbosch

 


 


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


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

 


We offer all of these courses in Stellenbosch.

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

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  
 
20 Apr Bloemfontein 0830 - 1600    R2200 Book
28 May Bloemfontein 0830 - 1600    R2200 Book
 
03 Apr Cape Town 0830 - 1600    R2200 Book
 
31 Mar Durban 0830 - 1600    R2200 Book
17 Apr Durban 0830 - 1600    R2200 Book
05 May Durban 0830 - 1600    R2200 Book
 
31 Mar Live Online 0830 - 1600    R1800 Book
22 Apr Live Online 0830 - 1600    R1800 Book
18 May Live Online 0830 - 1600    R1800 Book
23 Jun Live Online 0830 - 1600    R1800 Book
20 Jul Live Online 0830 - 1600    R1800 Book
24 Aug Live Online 0830 - 1600    R1800 Book
21 Sep Live Online 0830 - 1600    R1800 Book
 
01 Apr Midrand 0830 - 1600    R2300 Book
14 May Midrand 0830 - 1600    R2300 Book
03 Jun Midrand 0830 - 1600    R2300 Book
08 Jul Midrand 0830 - 1600    R2300 Book
12 Aug Midrand 0830 - 1600    R2300 Book
09 Sep Midrand 0830 - 1600    R2300 Book
14 Oct Midrand 0830 - 1600    R2300 Book
11 Nov Midrand 0830 - 1600    R2300 Book
17 Dec Midrand 0830 - 1600    R2300 Book
 
28 Apr Port Elizabeth 0830 - 1600    R2200 Book
25 May Port Elizabeth 0830 - 1600    R2200 Book
30 Jun Port Elizabeth 0830 - 1600    R2200 Book
28 Jul Port Elizabeth 0830 - 1600    R2200 Book
01 Sep Port Elizabeth 0830 - 1600    R2200 Book
13 Oct Port Elizabeth 0830 - 1600    R2200 Book
24 Nov Port Elizabeth 0830 - 1600    R2200 Book
 
01 Apr Pretoria 0830 - 1600    R2300 Book
20 May Pretoria 0830 - 1600    R2300 Book
24 Jun Pretoria 0830 - 1600    R2300 Book
22 Jul Pretoria 0830 - 1600    R2300 Book
26 Aug Pretoria 0830 - 1600    R2300 Book
30 Sep Pretoria 0830 - 1600    R2300 Book
29 Oct Pretoria 0830 - 1600    R2300 Book
27 Nov Pretoria 0830 - 1600    R2300 Book
 
08 Apr Sandton 0830 - 1600    R2100 Book
20 Apr Sandton 0830 - 1600    R2100 Book
28 Apr Sandton 0830 - 1600    R2100 Book


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

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  
 
14 Apr Bloemfontein 0830 - 1600    R Book
26 May Bloemfontein 0830 - 1600    R Book
30 Jun Bloemfontein 0830 - 1600    R Book
 
06 Apr Cape Town 0830 - 1600    R Book
 
03 Apr Durban 0830 - 1600    R Book
21 Apr Durban 0830 - 1600    R Book
07 May Durban 0830 - 1600    R Book
 
01 Apr Live Online 0830 - 1600    R Book
23 Apr Live Online 0830 - 1600    R Book
19 May Live Online 0830 - 1600    R Book
24 Jun Live Online 0830 - 1600    R Book
21 Jul Live Online 0830 - 1600    R Book
25 Aug Live Online 0830 - 1600    R Book
 
02 Apr Midrand 0830 - 1600    R Book
21 May Midrand 0830 - 1600    R Book
15 Jun Midrand 0830 - 1600    R Book
23 Jul Midrand 0830 - 1600    R Book
27 Aug Midrand 0830 - 1600    R Book
25 Sep Midrand 0830 - 1600    R Book
30 Oct Midrand 0830 - 1600    R Book
26 Nov Midrand 0830 - 1600    R Book
 
29 Apr Port Elizabeth 0830 - 1600    R Book
26 May Port Elizabeth 0830 - 1600    R Book
01 Jul Port Elizabeth 0830 - 1600    R Book
29 Jul Port Elizabeth 0830 - 1600    R Book
02 Sep Port Elizabeth 0830 - 1600    R Book
14 Oct Port Elizabeth 0830 - 1600    R Book
25 Nov Port Elizabeth 0830 - 1600    R Book
 
20 Apr Pretoria 0830 - 1600    R Book
04 Jun Pretoria 0830 - 1600    R Book
09 Jul Pretoria 0830 - 1600    R Book
11 Aug Pretoria 0830 - 1600    R Book
10 Sep Pretoria 0830 - 1600    R Book
16 Oct Pretoria 0830 - 1600    R Book
12 Nov Pretoria 0830 - 1600    R Book
10 Dec Pretoria 0830 - 1600    R Book


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

 


We offer all of these courses in Stellenbosch.

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

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  
 
28 Apr Bloemfontein 0830 - 1600    R2500 Book
27 May Bloemfontein 0900 - 1600    R2500 Book
 
08 Apr Cape Town 0830 - 1600    R2500 Book
 
07 Apr Durban 0830 - 1600    R2500 Book
23 Apr Durban 0830 - 1600    R2500 Book
11 May Durban 0830 - 1600    R2500 Book
 
02 Apr Live Online 0830 - 1600    R2100 Book
24 Apr Live Online 0830 - 1600    R2100 Book
20 May Live Online 0830 - 1600    R2100 Book
25 Jun Live Online 0830 - 1600    R2100 Book
22 Jul Live Online 0830 - 1600    R2100 Book
26 Aug Live Online 0830 - 1600    R2100 Book
 
03 Apr Midrand 0830 - 1600    R2600 Book
22 May Midrand 0830 - 1600    R2600 Book
11 Jun Midrand 0830 - 1600    R2600 Book
24 Jul Midrand 0830 - 1600    R2600 Book
28 Aug Midrand 0830 - 1600    R2600 Book
17 Sep Midrand 0830 - 1600    R2600 Book
22 Oct Midrand 0830 - 1600    R2600 Book
20 Nov Midrand 0830 - 1600    R2600 Book
 
30 Apr Port Elizabeth 0830 - 1600    R2500 Book
27 May Port Elizabeth 0830 - 1600    R2500 Book
02 Jul Port Elizabeth 0830 - 1600    R2500 Book
30 Jul Port Elizabeth 0830 - 1600    R2500 Book
03 Sep Port Elizabeth 0830 - 1600    R2500 Book
15 Oct Port Elizabeth 0830 - 1600    R2500 Book
26 Nov Port Elizabeth 0830 - 1600    R2500 Book
26 Nov Port Elizabeth 0830 - 1600    R2500 Book
 
21 Apr Pretoria 0830 - 1600    R2600 Book
02 Jun Pretoria 0830 - 1600    R2600 Book
31 Jul Pretoria 0830 - 1600    R2600 Book
06 Aug Pretoria 0830 - 1600    R2600 Book
18 Sep Pretoria 0830 - 1600    R2600 Book
12 Oct Pretoria 0830 - 1600    R2600 Book
09 Nov Pretoria 0830 - 1600    R2600 Book
11 Dec Pretoria 0830 - 1600    R2600 Book
 
03 Apr Sandton 0830 - 1600    R2500 Book
16 Apr Sandton 0830 - 1600    R2500 Book
29 Apr Sandton 0830 - 1600    R2500 Book