Call  086 999 0497

TTC

Microsot Excel courses logo

Excel courses
Bloemfontein

MS Excel level 1 course in Bloemfontein

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.

MS Excel level 1 course Schedule - Bloemfontein

22 Jan R 2000BookQuote
04 Mar R 2000BookQuote
23 Apr R 2000BookQuote
03 Jun R 2000BookQuote

Level One Course Outline

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.

MS Excel level 2 course in Bloemfontein

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.

MS Excel level 2 course Schedule - Bloemfontein

Date    Cost    Booking    Quote   
23 Jan R 2000BookQuote
05 Mar R 2000BookQuote
24 Apr R 2000BookQuote
05 Jun R 2000BookQuote

Level Two Course Outline

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 Courses In Other Locations

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

Private Course Request


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.

More About Excel Courses
Bloemfontein

Excel Course Options In Bloemfontein
We offer both public and private Excel courses in Bloemfontein

Excel Consulting In Bloemfontein
Sometimes a course is not your best option and you may just need some assistance with Excel. Our developers can assist you in Bloemfontein whether you need some hand holding or a project developed from scratch.

Excel Class Features
Delegates will receive hands-on training when you attend our Excel course in Bloemfontein. Training at our Bloemfontein campus includes refreshments, lunch, free parking, digital course materials and a certificate.

Excel training courses are available for all versions
Some of us don't always upgrade to the latest versions of Excel. No problem our facilitators in Bloemfontein have been using Excel for years and can help teach you on earlier versions. To a point!

Prerequisites for Excel public courses in Bloemfontein
Each course has different prerequisites, Typically for software aplications, beginners only need a working knowledge of the operating system, windows or iOs is required. Please check the specific course and make sure you understand the requirements before enrolling in any of our Bloemfontein courses.

Course Materials for Excel Courses
For credit bearing courses we use accredited SETA course materials. For other courses, our materials are authorised by their respective publisher if available. For custom Excel courses in Bloemfontein we may provide additional materials.

Excel Certification Training
Our courses wil help prepare you for certfication. Please contact us for more details on how to get certified.

Excel Class Reviews and Testimonials
Please visit our testimonial page to view what our clients have to say
Microsoft Logo
MS Access Logo
Access Logo

Excel World Class Tutors

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

Excel Course Support Bloemfontein

When you attend our Bloemfontein Excel Course, all students receive class materials, a certificate on completion and 3 months support from our certified instructors.

Your Bloemfontein Excel Course is Guaranteed

We guarantee your Excel 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 Bloemfontein Excel class.