Excel Dashboards Course
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.
Advanced
2 Day Course
Certification Awarded
Online \Resources
Learning Options for this Course
Classroom
This course can be taken at our Training Centre in Dublin 2. Socially distanced learning. Full interaction with expert trainers.
Virtual Classroom
Daytime or evenings using our iLiveLearning platform. Full interaction with the trainer – just like in the classroom. Software provided.
Self-paced eLearning
Self-paced online course with Assessment and Certification. Learn anytime, anywhere from any device. 1 Year access. Software required.
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
For Dates, Pricing & more info, please enter your details and we'll get back to you quickly.