This course teaches participant on how to create interactive Excel instrument board that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet. Excel Dashboards provide insight, analysis and even alerts. They are interactive and dynamic, and have a wide range of applications, providing help with project management, customer service, KPI management, forecasting and so on. They usually fit on one page, displaying key trends, comparisons and data in small graphs or tables. This makes them easy to read and digest the information
Inserting a Chart
Sparkline’s with Dashboards
Tables to Dynamically Link Charts & Lists
Linking Charts Across Worksheets
The OFFSET Function
Nested IF Statements Using the AND and OR Operators
VLOOKUPs
The MATCH Function
Creating Bespoke Navigation Bars
Creating Dashboard Links
Using Named Objects
Organizing Data in Data Tables using IFs
Table Formulas to Make Dynamic Charts
Table Formulas with Conditional Formatting
OFFSETs, VLOOKUPs and Name Range Lists
Adding a Data Bar into your Dashboard
Creating a Window Chart
Creating an Advanced Comparison Chart
Creating a Timeline Chart
Macros and the Visual Basic Interface
Configuring Controls using Macros
Ironing out Minor Issues in your Dashboard with VBA
The Select Case
Creating Professional Dashboards
Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
Create visualizations charts
Find subjects you're passionate about by browsing our online course categories. Start
learning with top courses Built With Industry Experts.