Online Excel Training

South Africa’s premier provider of Microsoft Excel Training, Consulting and Excel Add Ins.

If you are looking for live training see out Face to Face Excel Training Options (opens in a new tab)

• MS Excel Course for University Students

  63 Lessonsin A-Skill (Beg-Int-Adv)

  • Online Excel for University Students - R998

  

  In this course you will learn how to:

  • - operate the ribbon,
  • - customize the quick-access toolbar,
  • - format and set up personalized spreadsheets by using colours, spacing and lines,
  • - do calculations
  • - set up formulas for calculations and
  • - also produce graphs at the push of a few buttons.

  If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (10 preview lessons)

• Beginner to Advanced Excel Course

  3 Lessonsin A-Skill (Beg-Int-Adv), D- Bundles

  • Beginner to Advanced Excel Course Online - R3,750

  

  An online course that will take you from Beginner Excel, through Intermediate Excel and onto Advanced Excel. It is the equivalent of a 5 day live course. When you sign up you get access to 3 seperate courses so that you can learn in increments. This course is perfect for anyone who wants to get a good grounding but then wants to rapidly improve their skills.

  Preview this course - (3 preview lessons)

• Beginner Excel Course

  61 Lessonsin A-Skill (Beg-Int-Adv)

  • Online Beginner Excel Course - R998

  

  In this course you will learn how to:

  • - operate the ribbon,
  • - customize the quick-access toolbar,
  • - format and set up personalized spreadsheets by using colours, spacing and lines,
  • - do calculations
  • - set up formulas for calculations and
  • - also produce graphs at the push of a few buttons.

  If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (9 preview lessons)

• Beginner to Intermediate Excel Course

  2 Lessonsin A-Skill (Beg-Int-Adv), D- Bundles

  • Beginner to Intermediate Excel Course Online - R2,300

  

  An online course that will take you from Beginner Excel, through to Intermediate Excel. It is the equivalent of a 3 day live course. When you sign up you get access to 2 separate courses so that you can learn in increments. This course is perfect for anyone who wants to get a good grounding but then wants to rapidly improve their skills.

  Preview this course - (2 preview lessons)

• Intermediate Excel Course

  136 Lessonsin A-Skill (Beg-Int-Adv)

  • Online Intermediate Excel Course - R1,450

  

  In this course you will learn a combination of tools and functions that an Intermediate Excel user should be aware of. This is more than just an Excel 2 course, as it covers the practical uses of Excel at this level.

  Preview this course - (18 preview lessons)

• Intermediate to Advanced Excel Course

  2 Lessonsin A-Skill (Beg-Int-Adv), D- Bundles

  • Online Intermediate to Advanced Excel Course - R2,600

  

  An online course that will take you from Intermediate Excel to Advanced Excel. It is the equivalent of a 3 or 4 day live course. When you sign up you get access to 2 seperate courses so that you can learn in increments. This course is perfect for anyone who uses MS Excel regularly and wants to consolidate their current knowledge and move to the Advanced areas.

  Preview this course - (2 preview lessons)

• Advanced Excel Course

  153 Lessonsin A-Skill (Beg-Int-Adv)

  • Online Advanced Excel Course - R1,450

  

  This course is for anyone who needs to learn MS Advanced Excel. It follows on from our Intermediate MS Excel course. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (15 preview lessons)

• Online Financial Modelling, Budgeting and Forecasting Course

  97 Lessonsin C- Job Needs

  • Online Financial Modelling, Budgeting and Forecasting Course - R3,050

  

  An online financial modelling, budgeting and forecasting training course that covers all the key aspects of building financial models in Excel. Learn Spreadsheet best practice, Budget and Forecast template design and Financial Model time value of money calculations.

  Preview this course - (26 preview lessons)

• Excel for Data Analysis and Visualization

  141 Lessonsin A-Skill (Beg-Int-Adv)

  • Excel for Data Analysis and Visualization - R3,050

  

  In this course you will learn a combination of tools and functions that a user should be aware of. This is more than just an Excel  course, as it covers the practical uses of Excel at this level.

  Preview this course - (16 preview lessons)

• POPIA and GDPR Compliance- Built in Excel Tools that will help

  17 Lessonsin B-Excel Tools and formula, C- Job Needs

  • POPIA and GDPR Compliance Excel Course - R0

  

  A free course showing the tools already built into MS Excel to help with achieving Excel Spreadsheet POPIA and GDPR Compliance.

  Preview this course - (17 preview lessons)

• Free VLOOKUP Course

  23 Lessonsin A-Skill (Beg-Int-Adv), B-Excel Tools and formula

  • Free VLOOKUP Course - R0

  

  An ad supported free VLOOKUP course. One of the most important formula in Excel is the VLOOKUP formula. It has a variety of practical uses and is the stepping stone into truly understanding how Excel thinks. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (23 preview lessons)

• MS Excel Spreadsheet Best Practices course

  19 Lessonsin A-Skill (Beg-Int-Adv), B-Excel Tools and formula, C- Job Needs

  • MS Excel Spreadsheet Best Practices - R0

  

  An online MS Excel Spreadsheet Best Practices Course that covers all the spreadsheet best practice tips and tricks for reporting spreadsheets as well as financial models .

  Preview this course - (17 preview lessons)

• Avoid Spreadsheet Errors in Excel

  10 Lessonsin A-Skill (Beg-Int-Adv)

  • Avoid Spreadsheet Errors in Excel - R0

  

  In this free online course, you will learn how to avoid spreadsheet errors in Excel with a focus on everyday actions and how they can cause the errors you hear about in the news.

  Preview this course - (8 preview lessons)

• Free Excel Tips and Tricks

  13 Lessonsin B-Excel Tools and formula

  • Free Excel Tips and Tricks - R0

  

  A free course covering 11 useful tips and tricks for anyone using Excel in the business world. Covers ways to see multiple spreadsheets or sheets at the same time, navigating quicker, writing reports in MS Excel and more.

  Preview this course - (11 preview lessons)

• Excel Fundamentals-2 hrs

  10 Lessonsin A-Skill (Beg-Int-Adv)

  • Free MS Excel Fundamentals - R0

  

  Understanding the Excel fundamentals including how to find useful functions, understand which cells the formula uses, use the $ signs and creating IF functions.

  Preview this course - (9 preview lessons)

• Online Corporate Financial Modelling Course

  3 Lessonsin A-Skill (Beg-Int-Adv), D- Bundles

  • Corporate Financial Modelling Online - R5,395

  

  An online course that will take you from Intermediate Excel to Advanced Excel and cover financial modelling aspects as well. It is the equivalent of our 5 day live course. When you sign up you get access to 3 seperate courses so that you can learn in increments. This course is perfect for anyone who uses MS Excel regularly and wants to consolidate their current knowledge and move to the Advanced areas.

  Preview this course - (3 preview lessons)

• Advanced MS Excel for Auditors and Consultants

  4 Lessonsin C- Job Needs, D- Bundles

  • Excel Course for Auditors and Consultants - R6,550

  

  An online MS Excel course that will teach you all of the key tools that would be required by Auditors and Consultants. . When you sign up you get access to 4 separate courses so that you can learn in increments. This course is perfect for all auditors and consultants who regularly have to:

  • get information from clients
  • rework it to make it usable
  • analyse it to see what it is saying
  • present the findings and set up management reports.

  Preview this course - (4 preview lessons)

• Online MS Excel Super Bundle

  7 Lessonsin A-Skill (Beg-Int-Adv), D- Bundles

  • MS Excel Super Bundle online - R15,000

  

  An online course that will open all the MS Excel courses we offer and would be the equivalent of 10 days of live MS Excel courses. When you sign up you get access to 7 separate courses so that you can learn in increments. This course is perfect for anyone who uses MS Excel regularly and wants to consolidate their current knowledge.

  Preview this course - (7 preview lessons)

• Excel Functions and Formulas

  105 Lessonsin B-Excel Tools and formula

  • Online Excel Functions and Formula Course - R2,700

  

  This course is for anyone who needs to learn about the functions and formulas in Excel. It follows on from our Excel Tools course.

  Preview this course - (1 preview lessons)

• Excel Tools Course

  132 Lessonsin B-Excel Tools and formula

  • Online Excel Tools Course - R1,650

  

  In this course you will learn about all the tools that are available in Excel. This is more than just an Excel 2 course, as it covers the practical uses of Excel at this level.

  Preview this course - (2 preview lessons)

• Budgeting and Forecasting with Excel Course

  70 Lessonsin C- Job Needs

  • Budgeting and Forecasting with Excel Course - R3,250

  

  An online Budgeting and Forecasting with Excel Course that covers all the key aspects of building budget and forecast spreadsheets in Excel. Learn Spreadsheet best practice, Budget and Forecast template design and use, and various other useful tips and tricks.

  Preview this course - (19 preview lessons)

• Excel for Human Resource and Payroll Personnel

  137 Lessonsin C- Job Needs

  • Online Excel for HR and Payroll - R3,250

  

  This course is for anyone who works in the Human Resources and Payroll departments. The focus of the course is all the typical issues faced in these departments. The areas covered would also benefit anyone working with people data e.g. Learning and Development/ Training departments.

  Preview this course - (4 preview lessons)

• Get & Transform- Excel's data cleanup tool (aka PowerQuery)

  74 Lessonsin B-Excel Tools and formula

  • Get & Transform PowerQuery Online Course - R1,400

  

  Online course covering the latest data cleanup tool offered free within Excel. Learn how to automate all your data cleanup tasks so that it is as simple as:

  • Refresh
  • Go have some coffee
  • Come back and it is done!

  Preview this course - (7 preview lessons)

• Excel Dashboards and Management Reporting

  72 Lessonsin C- Job Needs

  • Excel Dashboards and Management Reporting - R3,900

  

  This course will cover how to use Excel to create meaningful dashboards and management reports. It is assumed you know the basics about Pivot Tables and Charting. The course will focus on areas that apply to dashboards and will include practical aspects of Pivot Tables, Charting, Conditional Formatting and Sparklines along with other critical dashboard tips and tricks.

  Preview this course - (10 preview lessons)

• Time value of money, debt, NPV and IRR in Excel

  20 Lessonsin C- Job Needs

  • Online Time value of money, debt, NPV and IRR in Excel Course - R1,400

  

  A mini course that focuses on the time value of money calculations in all its forms in Excel. Included is debt calculations and how to allow for prepayments, ad hoc withdrawals and changes in interest rate. How NPV and IRR work in Excel and the relationship between the two and the debt calculations. These calculations are particularly important for IFRS calculations.

  Preview this course - (2 preview lessons)

• Excel Charting/ Graphing course

  45 Lessonsin B-Excel Tools and formula, C- Job Needs

  • Excel Charting/ Graphing course - R1,100

  

  An online Excel charting/ graphing course covering how to understand charts and how to get them to do what you want.

  Preview this course - (2 preview lessons)

• Financial Calculations and compound interest in Excel

  15 Lessonsin C- Job Needs

  • Free Financial Calculations and compound interest in Excel - R0

  

  A mini course that focuses on the time value of money calculations in all its forms in Excel. Included is debt calculations, compound interest and how to allow for prepayments, ad hoc withdrawals and changes in interest rate. How NPV and IRR work in Excel and the relationship between the two and the debt calculations. These calculations are particularly important for IFRS calculations.

  Preview this course - (15 preview lessons)

• Pivot Tables in Excel

  43 Lessonsin B-Excel Tools and formula

  • Pivot Tables in Excel 2013 and higher - R990

  

  How to use Pivot Tables in Excel 2013 including tips and tricks for previous and subsequent versions of Excel. Pivot tables changes slightly from version to version but the core concepts stay the same. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (5 preview lessons)

• Data cleanup in Excel

  45 Lessonsin C- Job Needs

  • Data Cleanup in Excel - R1,100

  

  The most common task Excel is used for is to 'clean' information received from other systems to be usable in the business.

  Preview this course - (11 preview lessons)

• Excel What If Analysis

  15 Lessonsin C- Job Needs

  • Excel What If Analysis - R280

  

  The What If Analysis course shows you how to run what ifs and sensitivities in Excel using the built in tools like Data Tables, Goal Seek, Solver and Scenario Manager. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (8 preview lessons)

• Multi variable Excel data table- Excel sensitivities on steroids

  2 Lessonsin C- Job Needs

  • Excel 3+ way Data Table Template - R280

  

  If you build detailed financial models you may wish you could use the Data Tables features to compare more than the 2 allowed by Excel. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (1 preview lessons)

• Auditing an Excel spreadsheet

  26 Lessonsin C- Job Needs

  • Free Auditing a MS Excel Spreadsheet - R0

  

  A free course covering how to audit an Excel spreadsheet when you have limited time. So if you cannot review every single cell, we show where to look for the most likely spreadsheet errors. Need an updated version of a professional spreadsheet testing tool? Send an email asking about the updated Excel Auditing Tools.

  Preview this course - (26 preview lessons)

• Vlookup Explained- 1 Hr

  23 Lessonsin B-Excel Tools and formula

  • Vlookup tutorial - R280

  

  One of the most important formula in Excel is the VLOOKUP formula. It has a variety of practical uses and is the stepping stone into truly understanding how Excel thinks. If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

  Preview this course - (2 preview lessons)