Dashboard and Report Design Principles Using Excel
Tuesday, January 28, 2025
Webcast or Webinar, Online
2:00 PM - 5:38 PM (opens at 1:30 PM) EST
4Credits
Technical Business
Registration is Open
Members
$129.00 Regular Price
Non-Members
$159.00 Regular Price
CPE PowerPass Users
Click the "Apply PowerPass" button to use your PowerPass for the applicable course below.
$80.00 Members / $112.00 Non-Members
Don't have a CPE PowerPass? Click
here to find out more about the CPE PowerPass program.
Course Type: Webcast
Course Code: 24/AC744264
Level: Intermediate
Vendor: ACPEN
Field of Study: Computer Software and Applications
Overview:
If you...
- Produce or revise dashboards and reports
- Find your current reports and dashboards confusing
- Are frustrated by the length, complexity and structure of your existing reports
- Have many different styles of dashboards and reports in use and want to simplify things
- Need to create a consistent “house style” that can be replicated by different teams
- Want to look like a star by creating reports and dashboards that your internal customers love
... this workshop can help. In this session we explore the principles of what makes reports and dashboards easy, or hard, to understand, distil this into a simple set of rules and show you how to apply these rules using Excel.
Objectives:
- Understand the principles of good dashboard and report visual design
- Be able to review and identify issues with existing information dashboards and reports
- Know how to apply those principles using Excel
Major Topics:
- How to design charts for fastest possible user understanding and ease of use
- Review of case studies for group critique
- Developing a design standard for your organization
- Designing tables for rapid understanding and efficient space use
- How to use commentary, maintaining a consistent style and level of detail
- Using layout to support long-term memory and improve understanding
- The impact of trend methods on user understanding and a brief introduction to a statistically valid method for trend analysis.
- How to apply these techniques using Excel
Major Topics:
- How to design charts for fastest possible user understanding and ease of use
- Review of case studies for group critique
- Developing a design standard for your organization
- Designing tables for rapid understanding and efficient space use
- How to use commentary, maintaining a consistent style and level of detail
- Using layout to support long-term memory and improve understanding
- The impact of trend methods on user understanding and a brief introduction to a statistically valid method for trend analysis.
- How to apply these techniques using Excel