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.
Excel as a BI Tool - Creating a Dashboard 2019 covers topics such as:
- 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
Excel as a BI Tool - Creating a Dashboard 2019 is intended for:
- 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