Dashboard reporting using 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:  
Dublin, Professional Training, Unit 22 Westland Square, Pearse Street, Dublin
Start date & time:  
20 November 2019 09:30
End date & time:  
20 November 2019 17:00
Price: €468.75  (€375.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
12.00
CPD hours:  
7.00
Speaker details
First nameLast name
Damian E O'Neill

Description

Product type:  
CPD course
Category:  
Information technology

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 help identify areas for further study and practice.This course is an ideal foundation for our advanced courses in Dashboard Reporting, PowerPivot and PowerBI.

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 will be able to:

  • produce professional-looking, interactive dashboards
  • Link the dashboards to accounts packages or relevant databases.

Speaker Bio

Professional Training is a group of experienced specialists providing focused training in IT and Management skills. Our trainers use a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation by our course participants. We have delivered a range of CPD programmes with Chartered Accountants Ireland since 1997. Website: www.professional.ie