excel level II

Course Description

Prerequisite: excel level I

Excel Lab: Advanced Techniques & Data Lifecycle in Practice (A102) builds upon the functionalities learned in the Excel Lab: From Excel Beginner to Guru (A101) course and broadens your understanding and experience in deploying Excel in the workplace to make data driven decisions.

Learning these techniques from scratch usually equates to hours of googling and frustration as you search for real examples rather than theory. In this course, we focus on the most relevant and practical methodologies to help you solve real-life business problems that ensures you are able to rapidly up-skill and drive actionable insight from data.

Participants will leave with a full proficiency in how to solve real-world business problems using Excel.

Course Agenda

Session 1: Introduction to the Data Lifecycle

Session 2: Index-match

Session 3: Excel Tables & Array formulas

Session 4: Analysis

Session 5: Modelling

Session 6: Dashboards