Skip to content Skip to footer

Advanced Microsoft
Excel Masterclass

Unit standards: 116943, NQF Level 4, 3 Credits
JHB | Dates: 14 - 15 Feb | 15 - 16 Apr 2024

Course Navigation

It’s time to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application Ms Excel
Discover methods to dramatically reduce the time you spend on spreadsheets

  • Develop practical solutions to your business problems through superior spreadsheet design
  • Upgrade your spreadsheet skills with advanced data management techniques
  • Consolidate worksheets from different sources into one workbook
  • Develop efficient techniques for using charts
  • Use spreadsheet skills for advanced financial applications
  • Create, format, and troubleshoot pivot tables
  • Analyse data accurately using pivot tables and slicers
  • Adopt logical methods to solve complex problems by analysing data accurately using pivot tables Controls over Financial Statements
  • Efficient working with related worksheets and workbooks by benefitting from new reporting and presentation techniques

Session 1 – Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

Session 2 -Applying Conditional Logic

  • Use Lookup Functions
  • VLookup and HLookup
  • Combine Functions
  • Use Formulas and Functions to Apply
  • Conditional Formatting

Session 3- Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

Session 4- Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature

Presenting Your Data Visually

  • Use Advanced Chart Features
  • Create Sparklines

Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-InsMasterlass

This masterclass runs for 2 days

R 7 699.00
Group discounts available on request.

Our Advanced Microsoft Excel Masterclass is available in a variety of formats to best match your needs

In-House training: We bring the training to your location. Available with customized features created to meet your requirements.

Virtual Training: Delivered totally online, our virtual sessions are designed to keep participants engaged through relevant training, activities for practice, and ongoing reinforcement.

  • Accountants | Auditors | Creditors Managers | Accounts Receivable Depts. | Accounts Payable Depts. | Finance Managers | Operation Managers | Project Managers | HR Managers | Business Executives | Consultants | Head of Departments | Finance people and anyone who uses Excel to analyses and manipulate data and extensively for business reporting

Course Categories

Promo Video

Course Gallery

Open chat
Need Help
Prospen Africa
Good day. What can we assist you with today?