Duration: 60 minutes


Create a Dashboard with Excel (IMED50Z)

Presented By: Mike Thomas

Event Description

Dashboards and Reports provide the ideal way to present an overview of a business. Through them, they offer a valuable insight into the Key Performance Indicators upon which a business is measured. Dashboards are often used to provide a visual summary which enables decision makers to determine the future direction of a business.

Although there are many tools that can be used to create a Dashboard, Excel is commonly used due to its power, its flexibility and the fact that most people have it installed on their computer or mobile device. Find out how to make Excel's awesome power work for you in this informative session with expert Mike Thomas.

Training Highlights:

Amongst the topics that will be covered in this session are:

  • Connecting Excel to a data source
  • Creating Tables in Excel
  • Creating Pivot Tables
  • Pivot Charts and Sparkline Charts
  • Slicers and Filters
  • Conditional Formatting
  • Dashboard-specific Functions


By following real world examples, attendees will understand the practical steps needed to create a professional and eye-catching dashboard. The example worksheets will be made available to all attendees.

Who Should Attend

Any user of Excel who wants to learn how to create a Dashboard. Attendees should have an intermediate level knowledge of Excel. The training will be delivered using Excel 2016 for Windows although much of the functionality is available in Excel 2013 and 2010 and also Excel 2016 for Mac.

About Our Speaker(s)

Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website theexceltrainer.co.uk

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.


Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or service@proedtech.com. You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team