Interactive Dashboard Reporting Using Excel
Workshop Overview
Create state-of-the-art business intelligence by connecting and transforming a variety of data sources into interactive and visually attractive reports and dashboards that will wow your audience.
You will learn practical examples that you can use in your daily work environment by applying powerful tools and techniques such as Power Query, Power Pivot and Dynamic Array formulas. This will result in effective, visually stunning, and interactive charts, tables, and maps which you can use to intelligently explore your data and provide the insight you need to act diligently.
Workshop Outline
Benefit of Attending this Workshop
- SET UP a robust model to cater for automatic updates.
- IMPORT & TRANSFORM data from multiple sources into a cleansed data model using Power Query.
- CONNECT to a variety of data sources anywhere, anytime using Power Pivot.
- CREATE interactive pivot tables, pivot charts, slicers and timeline without formulas.
- ADD features such as conditional format and interactive form controls.
- CREATE advanced charts such as Sparklines, maps, waterfall chart, histogram and combined chart.
- DEVELOP impressive, visually rich, and interactive reports and dashboards.
Who Should Attend to This Workshop
The training course is suitable for:
• Anyone who wants to advance their knowledge by using the latest Excel tools.
• Users who want to stand out from the crowd by presenting visually appealing dashboards that will wow your audience.
• Anyone responsible for preparing Excel based dashboards, scorecards or KPI reports:
o General Managers
o Finance Managers
o Business Controllers
o Financial Controllers
o Accountants
o Data Analysts
o Business Analysts
o Sales Managers
o HR Managers
Course Date
Testimonials
Course Info
- Claimable : HRDCorp Grant Claimable
- Venue : Kuala Lumpur, Malaysia
- Certificate of Attendance will be issued
- Customization: Course Content can be customised for in-house trainings