On course for success

Advanced Microsoft Excel

Programme Overview

This course introduces Microsoft Excel users to the advanced features of the software application, in addition to the usual features such as creating and editing charts; modifying chart options; working with multiple worksheets and workbooks and use financial and logical functions. Participants will learn how to sort and manage data in lists; filter and query data; lookup and database functions, and PivotTables. In-class exercises will involve the use of data tables and scenarios to make projections about data and use Goal Seek and Solver to analyze data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.

Who Should Attend

Anyone whose chosen field of work requires the involvement of extensive and detailed use of the more complex MS Excel skills and functions. Participants have to demonstrate competence with all topics in the Basic and Intermediate Syllabus.

Programme Objectives

By the end of this programme, participants will be able to use Microsoft Excel’s in-built features to import, analyse and present their data.

Participants are expected to follow-along with the guided examples in the training manual as well as complete all assigned exercises. While participants are expected to perform all tasks themselves, they are encouraged to discuss possible solutions amongst themselves to support individual learning.

Participants are encouraged to share actual problems they face in using Microsoft Excel in their daily work. In this way practical solutions can be created and shared with the entire class. A digital training manual will be provided provided. Participants are encourage to print a hard-copy if it will support their learning. Digital exercise files will also be provided.

Programme Outline

Modules Programme Description
Introduction to Power Query Learn how to use Microsoft Excel’s newest an most exciting tool to import and transform frequently changing data from external sources.
Data Tools Learn the tools that Excel provides to help clean your data including automatically splitting into columns, intelligence-based automatic pattern filling and data validation.
Data Analysis with PivotTables Deepen your knowledge of PivotTables by learning different ways you can summarize an
present the PivotTable data
Logical Functions A revision on the IF(), OR() and AND() functions
Text functions A revision on PROPER(), UPPER(), LOWER(), CONCAT()/CONCATENATE(), LEFT(), RIGHT(), MID(). Learn about LEN(), FIND(), SEARCH(), REPLACE(), SUBSTITUTE()
Formula Auditing Learn how to investigate why your functions and formulas are displaying errors.
Nested Functions A powerful technique involving using functions within other functions.
Conditional Formatting

Learn how to make specific data stand out using a variety of colour formatting, data bars and icons.

Goal Seek & Scenarios Learn how Excel can help you handle what-if situations to display the possible data you need.
Forecast Sheet Apply Excel’s powerful forecast functionality to statistically predict future data.

Programme Delivery

Date Time
20 June 2022 (Day 1)

8:30 AM – 12:15 PM
1:30 PM – 5:00 PM

21 June 2022 (Day 2)

Your Investment

Package Stakeholder Non Stakeholder
Normal Price $ 490.00 (10% SBS) $ 590.00

 

Download Brochure Here
▲ Top