Advanced Microsoft Excel

Introduction

This hands-on course is designed for those users who have already attended the Introduction in Excel training (or have gained the appropriate knowledge in the workplace) and wish to produce more complex worksheets and reports. And still for individuals who want to advance and explore their knowledge and skills in usage of M/S Excel.

Trainees will advance their skill set by learning how to analyze and audit, worksheet data, utilize what if analysis tools, use advanced functions, create their own custom views, collaborate/link  data with others, create and manage macros and data analysis and management using pivot table (power pivots)

Learning outcomes

By the end of the session, learners will be able to analyze and handle data analytics and modeling using pivot tables, power pivot, VLOOKUP, Index/Match and record and run macros among others

Audience

It is essential that individuals who have successfully completed the Excel Intermediate course or has gained similar knowledge within work environment using excel tools and functions and applying the functionality details in the Excel intermediate and want to advance on multiple M/S excel functions and analysis.