Call  086 999 0497
Microsoft Excel courses

Microsoft Excel

  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 or iOS: Basic or equivalent experience.

29 Nov   R2000 Book Quote
10 Jan   R2000 Book Quote
07 Feb   R2000 Book Quote
06 Mar   R2000 Book Quote
10 Apr   R2000 Book Quote
08 May   R2000 Book Quote
11 Dec   R2000 Book Quote
29 Nov   R2000 Book Quote
10 Jan   R2000 Book Quote
07 Feb   R2000 Book Quote
06 Mar   R2000 Book Quote
10 Apr   R2000 Book Quote
08 May   R2000 Book Quote
29 Nov   R2000 Book Quote
10 Jan   R2000 Book Quote
23 Jan   R2000 Book Quote
06 Feb   R2000 Book Quote
16 Feb   R2000 Book Quote
27 Feb   R2000 Book Quote
07 Mar   R2000 Book Quote
19 Mar   R2000 Book Quote
28 Mar   R2000 Book Quote
09 Apr   R2000 Book Quote
19 Apr   R2000 Book Quote
29 Apr   R2000 Book Quote
08 May   R2000 Book Quote
17 May   R2000 Book Quote
Request a Private Course

Hours are 08:30 to 16:00 unless specified otherwise

Course Outline

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.

  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: Basic or equivalent experience.

05 Dec   R2000 Book Quote
16 Jan   R2000 Book Quote
13 Feb   R2000 Book Quote
13 Mar   R2000 Book Quote
16 Apr   R2000 Book Quote
15 May   R2000 Book Quote
12 Dec   R2000 Book Quote
05 Dec   R2000 Book Quote
16 Jan   R2000 Book Quote
13 Feb   R2000 Book Quote
13 Mar   R2000 Book Quote
16 Apr   R2000 Book Quote
15 May   R2000 Book Quote
Request a Private Course

Hours are 08:30 to 16:00 unless specified otherwise

Course Outline

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.

  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: Intermediate or equivalent experience.

13 Dec   R2000 Book Quote
30 Jan   R2000 Book Quote
27 Feb   R2000 Book Quote
26 Mar   R2000 Book Quote
23 Apr   R2000 Book Quote
13 Dec   R2000 Book Quote
13 Dec   R2000 Book Quote
30 Jan   R2000 Book Quote
27 Feb   R2000 Book Quote
26 Mar   R2000 Book Quote
23 Apr   R2000 Book Quote
30 Nov   R2200 Book Quote
11 Dec   R2200 Book Quote
19 Jan   R2000 Book Quote
29 Jan   R2000 Book Quote
09 Feb   R2000 Book Quote
21 Feb   R2000 Book Quote
08 Mar   R2000 Book Quote
18 Mar   R2000 Book Quote
27 Mar   R2000 Book Quote
02 Apr   R2000 Book Quote
15 Apr   R2000 Book Quote
30 Apr   R2000 Book Quote
06 May   R2000 Book Quote
16 May   R2000 Book Quote
27 May   R2000 Book Quote
Request a Private Course

Hours are 08:30 to 16:00 unless specified otherwise

Course Outline

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.

  MS Excel VBA course

Course Description

Visual Basic for Applications (VBA) course ware. VBA is a powerful development tool for creating macros in Excel and other Microsoft Office applications. By the end of this course, users should be comfortable with creating, recording, editing, and debugging a macro; formatting worksheets using macros; creating an interactive worksheet; and performing custom calculations using VBA.

Target Audience

This course is intended to help all intermediate to advanced Excel users get up to speed quickly with Visual Basic for Applications. We will cover different features of the Visual Basic Editor interface; show users how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros..

Prerequisites

This course assumes that the user understands the basics of using a Windows-based computer. Students should also be comfortable using the Microsoft Excel 2016 interface, and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables within Excel 2016 is strongly recommended. No previous experience with Visual Basic for Applications is required.

Hours are 08:30 to 16:00 unless specified otherwise

Course Outline

Module 1: Developing Macros

  • TOPIC A: Create a Macro Using the Macro Recorder
  • TOPIC B: Edit a Macro
  • TOPIC C: Debug a Macro
  • TOPIC D: Customize the Quick Access Toolbar and Hotkeys
  • TOPIC E: Set Macro Security

Module 2: Formatting Worksheets Using Macros

  • TOPIC A: Insert Text
  • TOPIC B: Format Text
  • TOPIC C: Sort Data
  • TOPIC D: Duplicate Data
  • TOPIC E: Generate a Report

Module 3: Creating an Interactive Worksheet

  • TOPIC A: Determine the Dialog Box Type
  • TOPIC B: Capture User Input

Module 4: Working with Multiple Worksheets

  • TOPIC A: Insert, Copy, and Delete Worksheets
  • TOPIC B: Rename Worksheets
  • TOPIC C: Modify the Order of Worksheets
  • TOPIC D: Print Worksheets

Module 5: Performing Calculations

  • TOPIC A: Create User-Defined Functions
  • TOPIC B: Automate SUM Functions

Private Training?

Would you prefer to take a private Excel course with one of our certified trainers?

We offer Excel training:

From 1 to 100 delegates, On-site at your offices.

Group rates, Flexible dates, Customised courses & Ongoing support for Adobe Excel



Virtual Classroom

Live, Online instructor-led Excel training.
Flexible dates and times to suit. All taught in real time wherever you are to individuals or groups.


Testimonials

If you would like to see our Excel Testimonials, please either contact us directly or view our client list and their experiences with our company.

Microsoft Excel courses
EXCEL COURSE INFORMATION

Which Excel Course do I take?

We offer 3 Excel courses. A beginner, intermediate and advanced. Each is 1-day. Please read the course oulines above to determine which is best for you. We taking the advanced course if you are knowledgable of at least 70% of the beginner course.

Microsoft Excel Onsite Course Options

Wherever your office is located, we can come to you and deliver a private custom Excel course. The larger the group the bigger the discount. However we also offer Excel training for individuals, either at your offices or your home.

For on-site courses, you will need to have a computer with Excel and if there are 3 or more delegates, a projection system is required for our Excel instructor.

Microsoft Excel Public Courses

Currently we offer Public Excel courses in the Johannesburg, Cape Town, Durban, Gqeberha and Bloemfontein areas. We can however provide a private onsite course or of course an online Excel course is also available

Excel Online Courses

If you are unable to attend a public Excel course, or simply prefer the convenience of an online course, these are regularly offered. For online Excel courses you will need Excel installed, an internet connection of 5MB/s or faster and a headset with a mic or use your laptop's built in mic and speakers. All Excel course materials are provided digitally. The course is of course, live and fully interactive with engaging teaching.

Microsoft Excel Private Course

Excel users tend to use the product for specific purposes. We can tailor a course to meet your specific goals.

What else should I learn after my Excel course?

Firstly, get the basics done. It is absolutely essential for you to have a good working knowledge of Excel. More and more companies are demanding expertise in Excel, whether it is formula’s, pivot tables or dashboard. Taking the Excel level 2 and level 3 class is highly recommended.
In addition to Excel, most office users will use PowerPoint, Word and Outlook.

It’s essential to know Excel and taking an Excel beginner course is the best way to start. What will certainly make a difference though, is your level of expertise in Excel and knowledge of the other Microsoft products.

Excel training courses are available for all versions

Whether you are using the most recent Excel version, or earlier releases such as Excel 2010,2013,2016 or 2019, our Excel training courses will help you learn the tools you use. When attending a public Excel course, we will use the most recent versions for your Excel course. If you wish to use an older version of Excel for your training, simply let us know and we will work with you on that version. Our Excel instructors have been teaching and developing courses for over 15 years, and are happy to address questions and deliver training on all versions of Excel.

Excel Training Courses from TTC

Microsoft Excel is installed on almost every device today. Computers, tablets and mobile devices. It is the most common spreadsheet used by over 500 million people and it is an office tool you can’t live without. Our instructors have been using and teaching Excel for over 20 years. Whether you are a beginner or advanced we can assit you.

Prerequisites for enrolling in Excel public courses

For the beginner course, no previous experience is required. For the intermediate and advanced Excel courses, we recommend using Excel for at least 3 months or having attended the beginner course. If you are not sure which level would benefit you, please have a look at the course descriptions for each level. Most of our classrooms, are equipped with Windows computers for use during your Excel training class. If you are an Excel mac user, you are welcome to bring your Mac with with you. It is strongly recommended that you have a personal installation of Excel to use directly after your training

Course materials for Excel classes

All delegates receive digital materials which are the official Microsoft training manuals. Our instructors may provide addtional training lessons and information especially for custom courses

Excel Certification Training

These Excel courses are the perfect preparation to become a Microsoft Office Specialist

Excel Class Reviews and Testimonials

Excel is used by almost every computer user. Simply put if you want to be employed or run your own business, knowledge of Excel is imperative. We cannot show you all our clients and their reviews on our site, and you can view a sample by using this link, however if you contact us directly, we will be happy to put in you in touch with some of our students who have taken our Excel courses.


Microsoft Logo
MS Access Logo
Access Logo

World Class Instruction

You can rely on the expertise of our instructors who have been teaching courses over 15 years. Our trainers are developers too. It’s essential to learn from professionals.

Course Support

When you attend our courses, all delegates receive course materials, a certificate on completion and 3 months support from our certified instructors.

Your Course is Guaranteed

We guarantee your course and offer a full refund if you are not satisfied with your training experience. Just let us know within the first 2 hours of your course.