Advanced MS 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 as well as using 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 analyse data. Participants will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros, and import and export information and documents.
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.
Pre-Requisite
Demonstrate competence with all topics in the Basic and Intermediate syllabus.
Who Is This Programme For?
Anyone whose chosen field of work requires extensive and detailed use of the more complex MS Excel skills and functions such as marketing, accounts & finance, sales, data analytics, etc.
Methodology
Face-to-face training.
Programme Outline
| Day 1 | Day 2 |
| Module 1: Introduction to Power Query | Module 6: Formula Auditing |
| Module 2: Data Tools | Module 7: Nested Functions |
| Module 3: Data Analysis with PivotTables | Module 8: Conditional Formatting |
| Module 4: Logical Functions | Module 9: Goal Seek & Scenarios |
| Module 5: Text Functions | Module 10: Forecast Sheet |
Programme Delivery
| Date | Time |
| 17 - 18 May 2023 |
8:30 AM – 12:00 PM |
Your Investment
| Package | Stakeholder | Non Stakeholder |
| Fee | $ 490.00 | $ 590.00 |
| Group Fee (Min 3 Pax) | $ 450.00 | $450.00 |