How to Go from Pivot Tables to Dashboards Using Excel 2018

Topics

• 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

Who should Attend

• 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