Dashboard Reporting with Excel

Summary

Excel is an ideal tool for creating high-impact dashboards in businesses of all sizes. In this course, learn how to build Excel-based dashboards that extract information from accounting applications, and databases, and to present this data as actionable information in a dashboard setting.

Venue details:  
, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
25 June 2020 09:30
End date & time:  
25 June 2020 17:00
Price:  
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
9.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damian O'Neill

Description

Product type:  
CPD course
Category:  
Technology and data

Who should attend

The course is aimed at Intermediate users of Excel and PowerPoint who want to take a systematic approach to Data Visualisation and assists in identifying areas for further study and practice. This course is an ideal foundation for our advanced courses in Dashboard Reporting, PowerPivot and Power B.

Course overview

  • The Benefits of Dashboard Reporting
  • Dashboards? Or Scorecards?
  • How to Create Mini-Charts for Dashboard Reporting
  • Charting Techniques for Dashboard Reporting
  • Using Charts with Worksheets
  • Using Excel's Camera Tool
  • Funnelling Data into Dashboard Reports
  • Using Spreadsheet Databases for Dashboard Reporting
  • How to Build Dashboard Reports in Excel
  • Make It All Fit
  • Magazine-Quality Dashboard Designs

Key learning outcomes

By the end of this course, participants wil be able to:

  • Produce professional, interactive dashboards
  • Link dashboards to accounts packages or relevant databases