- +27 (11) 439 3900
- info@maccauvlei.co.za
- Madison Avenue, Aspen Business Park
R11,443.65 (Excl. VAT)
This course builds on the foundational knowledge introduced in Microsoft Office Excel® 2016: Part 1. It is designed to guide learners along the path to creating advanced workbooks and worksheets that enhance organizational intelligence. Participants will learn how to analyse large volumes of data, transform it into meaningful insights, and present information in a way that supports informed decision-making. These skills are critical for organizations aiming to remain competitive in today’s data-driven environment.The course aligns with Microsoft Office Specialist (MOS) exam objectives, supporting learners in preparing for both the Excel 2016 Exam and the Excel 2016 Expert Exam. A strong emphasis is placed on hands-on, practical application to ensure learners can confidently apply their skills in real-world scenarios.
Lesson 1: Working with Functions
• Working with ranges
• Using specialised functions
• Working with logical functions
• Working with date and time functions
• Working with text functions
Lesson 2: Working with Lists
• Sorting data
• Filtering data
• Querying data with database functions
• Outlining and subtotaling data
Lesson 3: Analysing Data
• Creating and modifying tables
• Applying intermediate conditional formatting
• Applying advanced conditional formatting
WHO SHOULD ATTEND?
This course is intended for learners who already possess foundational knowledge and skills in Excel 2016 and wish to deepen their ability to analyse, manage, and present data more effectively.
Choose Intake & Study Mode