Online Microsoft Excel Courses

Beginners Excel Course (1h 40m)

  • Introduction to Spreadsheets Part 1
  • Introduction to Spreadsheets Part 2
  • Introduction to Lookup Functions
  • Excel Macros Part 1
  • Pivot Tables 101

Intermediate Excel Course (6h)

  • Auditing Excel Workbooks
  • Automating Financial Statements
  • Benefits/Risks of Office 365
  • Beyond VLOOKUP
  • Breaking Down Excel Formulas
  • Budget Spreadsheets
  • Chart Speed Tips
  • Conditional Formatting
  • Custom Views
  • Dashboards Part 1
  • Dashboards Part 2
  • Dealing with Duplicates
  • Error-Prompts
  • Error-Proof Spreadsheets
  • Excel Logic Functions
  • Excel Nuances
  • Formatting Excel Data
  • Filtering Data
  • Interactive Spreadsheets
  • Intermediate Pivot Tables
  • Internal Control
  • Linked Workbooks
  • Macros Part 2
  • Optimize Property Management Reports (1hr)
  • Payroll analysis
  • Printing and Page Layout
  • QuickBooks/Excel Report Analysis Part 1
  • QuickBooks/Excel Report Analysis Part 2
  • Six Ways to Sum
  • Speed Tips Part 1
  • Speed Tips Part 2
  • Tackling Excel’s Table Feature
  • Taming Large Spreadsheets
  • What’s New in Excel 2019 (1 hr)
  • Waterfall Calculations
  • What-If Analysis
  • Zombie Excel

Advanced Excel Course (2h)

  • Advanced Pivot Tables
  • Dynamic Arrays
  • Macros Part 3
  • Macros Part 4
  • SQL for Excel Users
  • Excel Pranks
This course is run online through Masterclass Event's new online portal. Call us on +27 (0) 12 654 8615.
Leave a Reply

    Company details

    Name of authorised manager


    Terms and Conditions

    Payment Methods: Once payment has been received we will send each registered delegate the welcome link to begin the course.

    Cancellation and Transfer Policy: No cancellations will be accepted once payment has been received and the licences is for one user only and is non transferable. Masterclass Events and its subsidiaries hereby reserves all rights.

    Beginner Excel Course - R2,100.00 (excl. VAT)
    Intermediate Excel Course - R6,300.00 (excl. VAT)
    Advanced Excel Course - R2,500.00 (excl. VAT)

    Event Details
    • Start Date
      27th Jul 2020
    • End Date
      1st May 2022
    • Status
    Join our mailing list

      By clicking Join, you acknowledge that your personal information and any information shared in this form will be processed for direct communication and marketing from Masterclass Events (Pty) Ltd only. We will not distribute any of the information that you have shared with us to any third party. You do have the right to unsubscribe or opt-out of our direct marketing at any point in time.
      I accept the Terms and Conditions as above


      Brilliant, well above anything that I have been exposed to before.

      Standard Bank


      Exceptional. Not accustomed to this level of Service.

      Absa Bank


      Great – I would definitely choose Masterclass Events as a Training Provider.

      Impala Platinum