Skip to content Skip to footer

Microsoft Office – Excel Intermediate

JHB. Date: 05 - 06 October

Course Navigation

Master using formulas and functions to make Excel work for you with this free online Excel Intermediate course.

Microsoft Excel 2013/16/19/21 intermediate course starts where our Microsoft Excel 2013/16/19/21 for Beginners course finishes. It will introduce you to a number of basic Excel concepts such as commenting, navigating the workbook, and working with printing. You’ll get an overview of the formulas and functions used in excel, learn the tips and tricks in working with multiple workbooks and finding errors, and study Excel as a Data Analysis tool.

Session 1 – Introduction to Formulas

Identify the elements of a formula, identify the default order in which calculations occur, match absolute, relative and mixed references, inserting an Excel formula and choosing the correct formula.

Session 2 – Data Cleaning

Excel puts special emphasis in cleaning data which comes in either text or numerical format. It has built a whole host of TEXT and DATA functions to allow us to manipulate large amounts of information.

Session 3 – Charts & Objects

Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.

Session 4 – Advanced Formulas

How to create advanced formulas and nested functions.  Nested functions refer to one or more functions being placed inside another. Doing this extends the capabilities of the formula.

Session 5 – Decision Tables

Show how to share data between multiple worksheets, including tips for adding, moving, and navigating worksheets. Produce a structured Excel Workbook with advanced formulas.

Session 6 – Pivot Tables

Excel has put special emphasis in using PIVOT TABLES to analyze large data sets

This masterclass runs for 1 day

R 7 999.00
Group discount available on request.

Our Microsoft Office – Excel Intermediate 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.

All Excel users. Anyone interested in learning excel and saving huge amounts of time in their daily use of Excel.

Course Categories

Promo Video

Course Gallery

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