Excel as a BI Tool - Creating a Dashboard 2019

Excel as a BI Tool - Creating a Dashboard 2019 is a webinar that provides knowledge on how to create a stunning, interactive professional-looking dashboard using Excel.

Topics

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

Who should Attend

• CPAs
• Accountants
• Financial consultants
• CFOs
• Banking
• Controllers
• Insurance
• Finance
• Telecom
• Education
• Marketing
• IT
• Investments
• Sales
• Medical Devices
• Pharmaceutical
• Aviation
• FDA
• Retail
• Energy
• Logistics & Supply Chain
• Human Resource
• Audit
• Accounts