Learn how to turn raw data into business intelligence to help you make more informed decisions. This virtual training course will focus on learning how to set up a dashboard using tools in Excel to extract meaningful information from large datasets. A dashboard is a powerful visual display of the most important status and performance indicators of your project or business. The course is suitable for Excel versions 2007, 2010 and 2013.
2007, 2010, 2013
You will learn how to:
- Work with Excel data in lists and tables
- Use Validation Rules to create a simple drop-down list user interface
- Use SUMIF and SUMIFS functions to extract the dashboard data
- Create dynamic charts
- Test and modify your dashboard
Overview of Excel dashboards
Why use dashboards
Types of dashboards
Setting up the dashboard elements
Optimising a list
Building an analysis sheet
Using SUMIF and SUMIFS
Extracting unique values
Building dynamic charts
Creating a chart
Modifying a chart
Bringing it all together
Testing the dashboard
Changing variable data and seeing the results
This course will suit you if you work with large data sets in Excel and want to create a simple and dynamic Dashboard which can be used for analysis and reporting.
Successful completion of a TP3 Excel Introduction course or the Creating and Using Simple Formulas online course.
TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.