Home » Courses » Office Productivity » Microsoft Excel Courses » Excel Dashboards

Excel Dashboards Course

This Excel Dashboards Course runs from our Dublin Training Centre

Dashboards are designed to take large amounts of data and display it in a single page of concise results.  This Excel Dashboards Course is a great way of taking your Excel Skills to the next level.

g

Advanced

2 Day Classroom Course

Certification Awarded

Includes Free Online Course

Skills You will have at the end of the Course

  • Learn different report strategies
  • Work with Advanced conditional formats
  • Learn to concisely summarise data in Excel
  • Design feature rich dashboards
  • Learn to use Excel’s data validation
  • Use even more advanced Functions

Course overview

Business managers need access to accurate data – presented in a clear and understandable way. IACT’s Excel Dashboard course teaches the skills needed to use this data to build powerful reports on any aspect of your business using Excel. Carefully built dashboard reports will help you clearly see insights into any aspect of your business. IACT’s Excel Dashboard course teaches the skills needed to build dynamic feature rich reports in Excel. Whether you are working with the latest release of Excel – or using an earlier version – this course will teach you the skills needed to produce professional feature rich Dashboards that explore your organisations data and provide compelling Excel Dashboards that will allow managers to step back from the details and see the key trends and relationships that drive their companies. Excel is an excellent tool for creating these reports.

 

Requirements

A very good working knowledge of Excel is required.

Certification

At the end of the course, you’ll be Certified by the Irish Academy of Computer Training

Who would benefit

This course is recommended for experienced Excel users who are familiar with Microsoft Office Specialist Expert level or for people who have completed our Excel Advanced Course and want to progress to the next level.

Why take the Course

You’ll be able to produce professional feature rich Dashboards that explore your organisations data and provide compelling Excel Dashboards that will allow managers to see the key trends and relationships that drive their companies.

Online Option

Yes

Course curriculum

Day 1
Day 1:
Topic 1: Table Style & Named Range
Topic 2: Offset
Topic 3: Form Controls
Topic 4: Sumifs/Countifs
Topic 5 Mini Charts
Lab: Building a basic Dashboard
Day 2
Day 2:
Topic 6: Match and Index
Topic 7: Arrays
Topics 8: Date Functions and Spinner Tool
Topic 9: Basic and Dynamic Camera
Topic 10: Sparklines
Topic 11: Extras
Lab: Build an Advanced Dashboard

To get Dates, Pricing & more info please enter your details and we will get back to you.

Or call us on 01 434 7600 

Course Enquiry

  • This field is for validation purposes and should be left unchanged.

*Required info. We treat your data with care, please see our Privacy Policy for more details

IACT - Ireland's leading training provider