Excel – Business Intelligence and Data Insights with Dashboards 2018

Topics

• Using Pivot Tables to summarize data
• Best practice for setting up data sources
• Using formulas to create KPI summaries
• Visual communication using charts
• Automating the dashboard with a simple macro
• Creating interactive filters with Slicers
• Using protection to prevent accidental changes

Who should Attend

Any user of Excel who hav intermediate level of Excel knowledge and preferably know how to create a basic pivot table and wants to learn how to create Excel dashboards.