Learning Options for this Course
This course can be taken at our Training Centre in Dublin 2. Socially distanced learning. Full interaction with expert trainers.
Daytime or evenings using iLiveLearning. Full interaction with the trainer, just like in the classroom. Software provided.
Self-paced online course on our Learning Hub with Assessment and Certification. 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
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.
A very good working knowledge of Excel is required.
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.
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
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
Contact us - we'll reply to you quickly
By clicking send, you agree for us to contact you about your enquiry.