How to Go from Pivot Tables to Dashboards Using Excel 2018 is a webinar that covers topics such as:
- Creating Key Performance Indicators (KPIs)
- Dashboard design guidelines - Best practices for reporting business metrics
- Adding linked tables, charts and slicers (filters) to the data model
- Creating PivotTables, PivotCharts and Slicers to create dashboards
- Leverage visual analysis for striking visual displays and greater impact
- Graphical presentation of business performance measures - best practices
- Select visualizations that best communicate the message your KPI needs to convey
- Choosing color and typography
- Improving the user experience - professional-level navigations via links and filters
- Choose the right chart for your data - which type of chart will best display your data
- Displays, key trends, comparisons and data graphically or in small tables
- Fully interactive - the user can filter data and change the view themselves
- Reviewing the completed dashboard
How to Go from Pivot Tables to Dashboards Using Excel 2018 is intended for:
- Financial Analysts, Budget Directors and Staff, CPAs, Auditors, Administrators and Managers
- Financial Professionals Including CFO`s, Controllers, Accounting and Finance Managers and Staff
- Engineers and Production Managers who prepare reports using Excel
- HR and Sales professionals who prepare reports using Excel
- IT Professionals Who Want an Fun, Easy Way To Prepare KPI Dashboards