Interactive Excel Dashboard Reporting Through the course, participants will learn how to create interactive and maintenance free reports for their companies without using macros. They will also learn more advanced formula and functions which can be used to increase their productivity in their Excel reports.

Topics Covered

CHOOSE FORM CONTROLS PIVOT TABLE COUNTIF / COUNTIFS INDEX RANGE NAME CUSTOMISE TEMPLATE INDIRECT SUMIF / SUMIFS DATA VALIDATION MATCH SUMPRODUCT DROPDOWN BOX PIVOT CHART VLOOKUP and more…

Who should attend

Managers and Executives who are required to prepare Reports for Management

Pre-requisites

Before you sign up for the course, it is important to you read this. The course is not for everyone. Do not attend the course if you do not have at least 2 years of experience working with Excel. And to make sure that you are able to benefit from the course, please answer the following questions: a. Do you know how to create a VLOOKUP formula? b. Do you know how to combine formulas? c. Do you know how to create Pivot Table?

What you need to bring

Broadband min 512 kbps Personal Laptop / desktop"

Key Takeaways

Key Performance Indicator (KPI) report Business Dashboard Daily, Weekly or Monthly Snapshot Business Performance / Deck Report