Excel-Based Dashboards Webinar

• Implement building blocks of Excel-based dashboards such as Open Database Connectivity, conditional formatting, tables and data models, defined names and dynamic defined names, form controls, and Excel’s RANK function
• Identify the processes for creating, formatting, and manipulating charts in Excel; additionally, enhance reader’s comprehension of trends by using Sparklines for trend analysis
• Define the relevance of and create PivotTables and PivotCharts in Excel-based dashboards for use in dashboards; additionally, apply specific PivotTable and PivotChart features
• Describe how to assemble an Excel-based dashboard using the techniques learned throughout this program

• Advanced Excel techniques for extracting and summarizing dashboard data
• Creating visualizations for more effective communications
• PivotTables and PivotCharts in Excel-based dashboards
• Building and sharing Excel-based dashboards