“Dashboard Reporting & Advanced Data Analysis with Excel” by PIM


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).


  • 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


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


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.

Date: 2-3 August, 2021
Time: 9am – 4pm
Venue: PIM, Karachi
Event Link: https://www.pim.com.pk/product/dashboard-reporting-advanced-data-analysis-with-excel-karachi/

Leave a Reply