Jump to course:

Excel Dashboards

Overview

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.

  • Learn to create newsletters, adverts and other common documents
  • Create templates for pages to improve productivity and consistency
  • Understand how to create special effects with colour and transparency
  • Understand graphic file formats and print terminology
  • Use templates and styles to speed up creating and updating documents
  • Learn different report strategies
  • Work with conditional formats
  • Learn to concisely summarise data in Excel
  • Design feature rich dashboards
  • Learn to use Excel’s data validation
  • Work with lists and any other form of database
  • Build robust cross checked spreadsheets
  • To be able to use Excel to build powerful and clear Dashboards from a wide variety of data sources.
    Experienced Excel users who have Microsoft Office Specialist Expert level or who have attended our Excel Level 2 course.
    2 Days

     

    Course Testimonials

    ”I found this course to be very good. The instructor was very knowledgable and professional and had a very good teaching manner. She was also patient and supportive.”
     
     

    Start Dates

    Looking for course dates? Find dates for your course here.


    Find a Date