Microsoft Excel courses logo

 

MS Excel courses

 


 

 

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

Course Date  City Course Times    Cost  
July        
23 Jul Fourways 0830 - 1600    R2200 Book
24 Jul Durban 0830 - 1600    R2200 Book
24 Jul Pretoria 0830 - 1600    R2200 Book
26 Jul Port Elizabeth 0830 - 1600    R2200 Book
29 Jul Pretoria 0830 - 1600    R2200 Book
August        
01 Aug Nelspruit 0830 - 1600    R2200 Book
05 Aug Port Elizabeth 0830 - 1600    R2200 Book
06 Aug Fourways 0830 - 1600    R2200 Book
07 Aug Durban 0830 - 1600    R2200 Book
13 Aug Cape Town 0830 - 1600    R2200 Book
14 Aug Midrand 0830 - 1600    R2200 Book
16 Aug Durban 0830 - 1600    R2200 Book
19 Aug Midrand 0830 - 1600    R2200 Book
19 Aug Vereeniging 0830 - 1600    R2200 Book
22 Aug Durban 0830 - 1600    R2200 Book
28 Aug Pretoria 0830 - 1600    R2200 Book
30 Aug Port Elizabeth 0830 - 1600    R2200 Book
September        
02 Sep Pretoria 0830 - 1600    R2200 Book
03 Sep Fourways 0830 - 1600    R2200 Book
04 Sep Cape Town 0830 - 1600    R2200 Book
04 Sep Nelspruit 0830 - 1600    R2200 Book
09 Sep Port Elizabeth 0830 - 1600    R2200 Book
11 Sep Midrand 0830 - 1600    R2200 Book
16 Sep Midrand 0830 - 1600    R2200 Book
16 Sep Vereeniging 0830 - 1600    R2200 Book
25 Sep Cape Town 0830 - 1600    R2200 Book
27 Sep Port Elizabeth 0830 - 1600    R2200 Book
October        
01 Oct Nelspruit 0830 - 1600    R2200 Book
02 Oct Pretoria 0830 - 1600    R2200 Book
07 Oct Port Elizabeth 0830 - 1600    R2200 Book
07 Oct Pretoria 0830 - 1600    R2200 Book
09 Oct Cape Town 0830 - 1600    R2200 Book
16 Oct Midrand 0830 - 1600    R2200 Book
21 Oct Midrand 0830 - 1600    R2200 Book
21 Oct Vereeniging 0830 - 1600    R2200 Book
25 Oct Port Elizabeth 0830 - 1600    R2200 Book
28 Oct Cape Town 0830 - 1600    R2200 Book
30 Oct Pretoria 0830 - 1600    R2200 Book
November        
04 Nov Port Elizabeth 0830 - 1600    R2200 Book
04 Nov Pretoria 0830 - 1600    R2200 Book
05 Nov Fourways 0830 - 1600    R2200 Book
06 Nov Cape Town 0830 - 1600    R2200 Book
07 Nov Nelspruit 0830 - 1600    R2200 Book
13 Nov Midrand 0830 - 1600    R2200 Book
18 Nov Midrand 0830 - 1600    R2200 Book
18 Nov Vereeniging 0830 - 1600    R2200 Book
27 Nov Pretoria 0830 - 1600    R2200 Book
29 Nov Cape Town 0830 - 1600    R2200 Book
29 Nov Port Elizabeth 0830 - 1600    R2200 Book
December        
02 Dec Nelspruit 0830 - 1600    R2200 Book
02 Dec Port Elizabeth 0830 - 1600    R2200 Book
02 Dec Pretoria 0830 - 1600    R2200 Book
02 Dec Vereeniging 0830 - 1600    R2200 Book
04 Dec Cape Town 0830 - 1600    R2200 Book
11 Dec Midrand 0830 - 1600    R2200 Book
12 Dec Port Elizabeth 0830 - 1600    R2200 Book
18 Dec Cape Town 0830 - 1600    R2200 Book
18 Dec Midrand 0830 - 1600    R2200 Book

Course Date  City Course Times    Cost  
       
13 Aug Cape Town 0830 - 1600    R2200 Book
04 Sep Cape Town 0830 - 1600    R2200 Book
25 Sep Cape Town 0830 - 1600    R2200 Book
09 Oct Cape Town 0830 - 1600    R2200 Book
28 Oct Cape Town 0830 - 1600    R2200 Book
06 Nov Cape Town 0830 - 1600    R2200 Book
29 Nov Cape Town 0830 - 1600    R2200 Book
04 Dec Cape Town 0830 - 1600    R2200 Book
18 Dec Cape Town 0830 - 1600    R2200 Book
       
24 Jul Durban 0830 - 1600    R2200 Book
07 Aug Durban 0830 - 1600    R2200 Book
16 Aug Durban 0830 - 1600    R2200 Book
22 Aug Durban 0830 - 1600    R2200 Book
       
23 Jul Fourways 0830 - 1600    R2200 Book
06 Aug Fourways 0830 - 1600    R2200 Book
03 Sep Fourways 0830 - 1600    R2200 Book
05 Nov Fourways 0830 - 1600    R2200 Book
       
14 Aug Midrand 0830 - 1600    R2200 Book
19 Aug Midrand 0830 - 1600    R2200 Book
11 Sep Midrand 0830 - 1600    R2200 Book
16 Sep Midrand 0830 - 1600    R2200 Book
16 Oct Midrand 0830 - 1600    R2200 Book
21 Oct Midrand 0830 - 1600    R2200 Book
13 Nov Midrand 0830 - 1600    R2200 Book
18 Nov Midrand 0830 - 1600    R2200 Book
11 Dec Midrand 0830 - 1600    R2200 Book
18 Dec Midrand 0830 - 1600    R2200 Book
       
01 Aug Nelspruit 0830 - 1600    R2200 Book
04 Sep Nelspruit 0830 - 1600    R2200 Book
01 Oct Nelspruit 0830 - 1600    R2200 Book
07 Nov Nelspruit 0830 - 1600    R2200 Book
02 Dec Nelspruit 0830 - 1600    R2200 Book
       
26 Jul Port Elizabeth 0830 - 1600    R2200 Book
05 Aug Port Elizabeth 0830 - 1600    R2200 Book
30 Aug Port Elizabeth 0830 - 1600    R2200 Book
09 Sep Port Elizabeth 0830 - 1600    R2200 Book
27 Sep Port Elizabeth 0830 - 1600    R2200 Book
07 Oct Port Elizabeth 0830 - 1600    R2200 Book
25 Oct Port Elizabeth 0830 - 1600    R2200 Book
04 Nov Port Elizabeth 0830 - 1600    R2200 Book
29 Nov Port Elizabeth 0830 - 1600    R2200 Book
02 Dec Port Elizabeth 0830 - 1600    R2200 Book
12 Dec Port Elizabeth 0830 - 1600    R2200 Book
       
24 Jul Pretoria 0830 - 1600    R2200 Book
29 Jul Pretoria 0830 - 1600    R2200 Book
28 Aug Pretoria 0830 - 1600    R2200 Book
02 Sep Pretoria 0830 - 1600    R2200 Book
02 Oct Pretoria 0830 - 1600    R2200 Book
07 Oct Pretoria 0830 - 1600    R2200 Book
30 Oct Pretoria 0830 - 1600    R2200 Book
04 Nov Pretoria 0830 - 1600    R2200 Book
27 Nov Pretoria 0830 - 1600    R2200 Book
02 Dec Pretoria 0830 - 1600    R2200 Book
       
19 Aug Vereeniging 0830 - 1600    R2200 Book
16 Sep Vereeniging 0830 - 1600    R2200 Book
21 Oct Vereeniging 0830 - 1600    R2200 Book
18 Nov Vereeniging 0830 - 1600    R2200 Book
02 Dec Vereeniging 0830 - 1600    R2200 Book

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

Download PDF

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  
July        
19 Jul Durban 0830 - 1600    R2300 Book
19 Jul Vereeniging 0830 - 1600    R2300 Book
25 Jul Midrand 0830 - 1600    R2300 Book
26 Jul Durban 0830 - 1600    R2300 Book
30 Jul Pretoria 0830 - 1600    R2300 Book
August        
01 Aug Cape Town 0830 - 1600    R2300 Book
07 Aug Port Elizabeth 0830 - 1600    R2300 Book
07 Aug Pretoria 0830 - 1600    R2300 Book
12 Aug Durban 0830 - 1600    R2300 Book
12 Aug Nelspruit 0830 - 1600    R2300 Book
15 Aug Cape Town 0830 - 1600    R2300 Book
16 Aug Cape Town 0830 - 1600    R2300 Book
20 Aug Durban 0830 - 1600    R2300 Book
20 Aug Fourways 0830 - 1600    R2300 Book
20 Aug Midrand 0830 - 1600    R2300 Book
23 Aug Vereeniging 0830 - 1600    R2300 Book
26 Aug Durban 0830 - 1600    R2300 Book
27 Aug Port Elizabeth 0830 - 1600    R2300 Book
29 Aug Midrand 0830 - 1600    R2300 Book
30 Aug Cape Town 0830 - 1600    R2300 Book
September        
03 Sep Pretoria 0830 - 1600    R2300 Book
10 Sep Bloemfontein 0830 - 1600    R2300 Book
11 Sep Port Elizabeth 0830 - 1600    R2300 Book
12 Sep Pretoria 0830 - 1600    R2300 Book
17 Sep Midrand 0830 - 1600    R2300 Book
20 Sep Fourways 0830 - 1600    R2300 Book
20 Sep Vereeniging 0830 - 1600    R2300 Book
26 Sep Midrand 0830 - 1600    R2300 Book
October        
08 Oct Bloemfontein 0830 - 1600    R2300 Book
08 Oct Fourways 0830 - 1600    R2300 Book
08 Oct Pretoria 0830 - 1600    R2300 Book
09 Oct Port Elizabeth 0830 - 1600    R2300 Book
17 Oct Pretoria 0830 - 1600    R2300 Book
22 Oct Midrand 0830 - 1600    R2300 Book
22 Oct Nelspruit 0830 - 1600    R2300 Book
25 Oct Fourways 0830 - 1600    R2300 Book
25 Oct Vereeniging 0830 - 1600    R2300 Book
29 Oct Port Elizabeth 0830 - 1600    R2300 Book
31 Oct Midrand 0830 - 1600    R2300 Book
November        
01 Nov Fourways 0830 - 1600    R2300 Book
05 Nov Pretoria 0830 - 1600    R2300 Book
06 Nov Port Elizabeth 0830 - 1600    R2300 Book
14 Nov Pretoria 0830 - 1600    R2300 Book
19 Nov Fourways 0830 - 1600    R2300 Book
19 Nov Midrand 0830 - 1600    R2300 Book
22 Nov Vereeniging 0830 - 1600    R2300 Book
27 Nov Bloemfontein 0830 - 1600    R2300 Book
28 Nov Midrand 0830 - 1600    R2300 Book
29 Nov Fourways 0830 - 1600    R2300 Book
December        
03 Dec Port Elizabeth 0830 - 1600    R2300 Book
03 Dec Pretoria 0830 - 1600    R2300 Book
06 Dec Vereeniging 0830 - 1600    R2300 Book
09 Dec Nelspruit 0830 - 1600    R2300 Book
12 Dec Port Elizabeth 0830 - 1600    R2300 Book
12 Dec Pretoria 0830 - 1600    R2300 Book
19 Dec Midrand 0830 - 1600    R2300 Book

Course Date  City Course Times    Cost  
       
10 Sep Bloemfontein 0830 - 1600    R2300 Book
08 Oct Bloemfontein 0830 - 1600    R2300 Book
27 Nov Bloemfontein 0830 - 1600    R2300 Book
       
01 Aug Cape Town 0830 - 1600    R2300 Book
15 Aug Cape Town 0830 - 1600    R2300 Book
16 Aug Cape Town 0830 - 1600    R2300 Book
30 Aug Cape Town 0830 - 1600    R2300 Book
       
19 Jul Durban 0830 - 1600    R2300 Book
26 Jul Durban 0830 - 1600    R2300 Book
12 Aug Durban 0830 - 1600    R2300 Book
20 Aug Durban 0830 - 1600    R2300 Book
26 Aug Durban 0830 - 1600    R2300 Book
       
20 Aug Fourways 0830 - 1600    R2300 Book
20 Sep Fourways 0830 - 1600    R2300 Book
08 Oct Fourways 0830 - 1600    R2300 Book
25 Oct Fourways 0830 - 1600    R2300 Book
01 Nov Fourways 0830 - 1600    R2300 Book
19 Nov Fourways 0830 - 1600    R2300 Book
29 Nov Fourways 0830 - 1600    R2300 Book
       
25 Jul Midrand 0830 - 1600    R2300 Book
20 Aug Midrand 0830 - 1600    R2300 Book
29 Aug Midrand 0830 - 1600    R2300 Book
17 Sep Midrand 0830 - 1600    R2300 Book
26 Sep Midrand 0830 - 1600    R2300 Book
22 Oct Midrand 0830 - 1600    R2300 Book
31 Oct Midrand 0830 - 1600    R2300 Book
19 Nov Midrand 0830 - 1600    R2300 Book
28 Nov Midrand 0830 - 1600    R2300 Book
19 Dec Midrand 0830 - 1600    R2300 Book
       
12 Aug Nelspruit 0830 - 1600    R2300 Book
22 Oct Nelspruit 0830 - 1600    R2300 Book
09 Dec Nelspruit 0830 - 1600    R2300 Book
       
07 Aug Port Elizabeth 0830 - 1600    R2300 Book
27 Aug Port Elizabeth 0830 - 1600    R2300 Book
11 Sep Port Elizabeth 0830 - 1600    R2300 Book
09 Oct Port Elizabeth 0830 - 1600    R2300 Book
29 Oct Port Elizabeth 0830 - 1600    R2300 Book
06 Nov Port Elizabeth 0830 - 1600    R2300 Book
03 Dec Port Elizabeth 0830 - 1600    R2300 Book
12 Dec Port Elizabeth 0830 - 1600    R2300 Book
       
30 Jul Pretoria 0830 - 1600    R2300 Book
07 Aug Pretoria 0830 - 1600    R2300 Book
03 Sep Pretoria 0830 - 1600    R2300 Book
12 Sep Pretoria 0830 - 1600    R2300 Book
08 Oct Pretoria 0830 - 1600    R2300 Book
17 Oct Pretoria 0830 - 1600    R2300 Book
05 Nov Pretoria 0830 - 1600    R2300 Book
14 Nov Pretoria 0830 - 1600    R2300 Book
03 Dec Pretoria 0830 - 1600    R2300 Book
12 Dec Pretoria 0830 - 1600    R2300 Book
       
19 Jul Vereeniging 0830 - 1600    R2300 Book
23 Aug Vereeniging 0830 - 1600    R2300 Book
20 Sep Vereeniging 0830 - 1600    R2300 Book
25 Oct Vereeniging 0830 - 1600    R2300 Book
22 Nov Vereeniging 0830 - 1600    R2300 Book
06 Dec Vereeniging 0830 - 1600    R2300 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

Download PDF

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  
July        
24 Jul Vereeniging 0830 - 1600    R2500 Book
26 Jul Midrand 0830 - 1600    R2500 Book
30 Jul Durban 0830 - 1600    R2500 Book
31 Jul Pretoria 0830 - 1600    R2500 Book
August        
01 Aug Bloemfontein 0830 - 1600    R2500 Book
08 Aug Pretoria 0830 - 1600    R2500 Book
09 Aug Port Elizabeth 0830 - 1600    R2500 Book
14 Aug Durban 0830 - 1600    R2500 Book
19 Aug Cape Town 0830 - 1600    R2500 Book
21 Aug Midrand 0830 - 1600    R2500 Book
28 Aug Durban 0830 - 1600    R2500 Book
28 Aug Vereeniging 0830 - 1600    R2500 Book
30 Aug Midrand 0830 - 1600    R2500 Book
September        
04 Sep Pretoria 0830 - 1600    R2500 Book
13 Sep Port Elizabeth 0830 - 1600    R2500 Book
13 Sep Pretoria 0830 - 1600    R2500 Book
17 Sep Fourways 0830 - 1600    R2500 Book
18 Sep Midrand 0830 - 1600    R2500 Book
25 Sep Vereeniging 0830 - 1600    R2500 Book
27 Sep Midrand 0830 - 1600    R2500 Book
30 Sep Bloemfontein 0830 - 1600    R2500 Book
October        
09 Oct Pretoria 0830 - 1600    R2500 Book
11 Oct Port Elizabeth 0830 - 1600    R2500 Book
18 Oct Pretoria 0830 - 1600    R2500 Book
22 Oct Fourways 0830 - 1600    R2500 Book
23 Oct Midrand 0830 - 1600    R2500 Book
30 Oct Vereeniging 0830 - 1600    R2500 Book
31 Oct Bloemfontein 0830 - 1600    R2500 Book
November        
01 Nov Midrand 0830 - 1600    R2500 Book
04 Nov Port Elizabeth 0830 - 1600    R2500 Book
06 Nov Pretoria 0830 - 1600    R2500 Book
15 Nov Pretoria 0830 - 1600    R2500 Book
20 Nov Midrand 0830 - 1600    R2500 Book
22 Nov Port Elizabeth 0830 - 1600    R2500 Book
26 Nov Fourways 0830 - 1600    R2500 Book
27 Nov Vereeniging 0830 - 1600    R2500 Book
28 Nov Bloemfontein 0830 - 1600    R2500 Book
29 Nov Midrand 0830 - 1600    R2500 Book
December        
02 Dec Port Elizabeth 0830 - 1600    R2500 Book
04 Dec Pretoria 0830 - 1600    R2500 Book
11 Dec Vereeniging 0830 - 1600    R2500 Book
12 Dec Port Elizabeth 0830 - 1600    R2500 Book
13 Dec Pretoria 0830 - 1600    R2500 Book
16 Dec Bloemfontein 0830 - 1600    R2500 Book
20 Dec Midrand 0830 - 1600    R2500 Book


Course Date  City Course Times    Cost  
       
01 Aug Bloemfontein 0830 - 1600    R2500 Book
30 Sep Bloemfontein 0830 - 1600    R2500 Book
31 Oct Bloemfontein 0830 - 1600    R2500 Book
28 Nov Bloemfontein 0830 - 1600    R2500 Book
16 Dec Bloemfontein 0830 - 1600    R2500 Book
       
19 Aug Cape Town 0830 - 1600    R2500 Book
       
30 Jul Durban 0830 - 1600    R2500 Book
14 Aug Durban 0830 - 1600    R2500 Book
28 Aug Durban 0830 - 1600    R2500 Book
       
17 Sep Fourways 0830 - 1600    R2500 Book
22 Oct Fourways 0830 - 1600    R2500 Book
26 Nov Fourways 0830 - 1600    R2500 Book
       
26 Jul Midrand 0830 - 1600    R2500 Book
21 Aug Midrand 0830 - 1600    R2500 Book
30 Aug Midrand 0830 - 1600    R2500 Book
18 Sep Midrand 0830 - 1600    R2500 Book
27 Sep Midrand 0830 - 1600    R2500 Book
23 Oct Midrand 0830 - 1600    R2500 Book
01 Nov Midrand 0830 - 1600    R2500 Book
20 Nov Midrand 0830 - 1600    R2500 Book
29 Nov Midrand 0830 - 1600    R2500 Book
20 Dec Midrand 0830 - 1600    R2500 Book
       
09 Aug Port Elizabeth 0830 - 1600    R2500 Book
13 Sep Port Elizabeth 0830 - 1600    R2500 Book
11 Oct Port Elizabeth 0830 - 1600    R2500 Book
04 Nov Port Elizabeth 0830 - 1600    R2500 Book
22 Nov Port Elizabeth 0830 - 1600    R2500 Book
02 Dec Port Elizabeth 0830 - 1600    R2500 Book
12 Dec Port Elizabeth 0830 - 1600    R2500 Book
       
31 Jul Pretoria 0830 - 1600    R2500 Book
08 Aug Pretoria 0830 - 1600    R2500 Book
04 Sep Pretoria 0830 - 1600    R2500 Book
13 Sep Pretoria 0830 - 1600    R2500 Book
09 Oct Pretoria 0830 - 1600    R2500 Book
18 Oct Pretoria 0830 - 1600    R2500 Book
06 Nov Pretoria 0830 - 1600    R2500 Book
15 Nov Pretoria 0830 - 1600    R2500 Book
04 Dec Pretoria 0830 - 1600    R2500 Book
13 Dec Pretoria 0830 - 1600    R2500 Book
       
24 Jul Vereeniging 0830 - 1600    R2500 Book
28 Aug Vereeniging 0830 - 1600    R2500 Book
25 Sep Vereeniging 0830 - 1600    R2500 Book
30 Oct Vereeniging 0830 - 1600    R2500 Book
27 Nov Vereeniging 0830 - 1600    R2500 Book
11 Dec Vereeniging 0830 - 1600    R2500 Book

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

Download PDF

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.