Dashboard Reporting & Advanced Data Analysis with Excel (Lahore)

COURSE DESCRIPTION

In today’s challenging business environment, one of the most sought after skill for professionals is their ability to quickly analyze, summarize, present and report on the available data. This course is designed with a practical, easy-to-learn approach towards unleashing the power of Microsoft Excel to build interactive management dashboards and advanced data analysis and reporting features. It aims to equip participants with adequate knowledge and skills to understand how to create interactive dashboards that facilitate the reporting of key performance indicators (KPIs).

COURSE CONTENTS

• Introduction to Dashboards
• Preparing and Analyzing Dashboard Data
• Building Interactive Dashboards with Form Controls
• Advanced Charting & Formatting Techniques
• Creating Dashboards with Pivot Tables & Slicers
• Using Macros to Create Interactive Dashboards

LEARNING OUTCOMES

After the workshop, you will be able to:

• Able to produce high quality interactive dashboards
• Master the art of charting and visualizations
• Become more proficient in using complex Excel data analysis and reporting features

TARGET AUDIENCE

This course is ideally suited for participants who understands key spreadsheet concepts and are intermediate users of Microsoft Excel. Business analysts, reporting analysts, sales & marketing executives and project managers or anyone with the responsibility to perform data analysis and business reporting.

About Instructors

Muhammad Aleem Habib

IT & Project Management

Working as a Deputy General Manager at PIM. His areas of specialization are IT, Project and General Management.

Reviews