The UK's Leading Professional Training & Business Solutions Provider

Email or CALL NOW on 01952 581550

Excel Dashboards

Course Overview

If the numbers you need to track are spread out across different systems, learn how to have everything on one screen so all you need to do is give it a glance. Yes, it’s time to make a dashboard.

It’s like the instrument panel for your business. Your car has one. Planes have one. Let us help you make one for your business too.

This course is will enable you to present business data in Excel without using Power BI. You’ll learn more advanced techniques to display the data for Management.

Watch a snippet of what’s involved in our Excel Dashboards course above.

Course Content

We offer various Live Online training courses so please get in touch if you are interested in a different topic!

Who is this for?

This One Day course is specifically designed for office users, managers, accountants and data analysts. Delegates on this course should have existing advanced knowledge of Excel, and we will turn you into an Excel expert.

Pre-requisites: Delegates should have completed up to and including Excel Level 3 skills, (Advanced formulas) or equivalent experience, to ensure you can participate in this training.

These skills are not difficult to learn but you need a firm foundation in the basics so you can get the most from this course.

How much does it cost?

This course costs £550 + VAT

     
Imagine Training Ltd is rated 5 out of 5 based on 1425 reviews from around the Web.
2020-01-17
     
I would advise other colleagues to take the course everyone I spoke to learned something new from it. The trainer was very good and went at everyone’s pace. The manual will doubtless be useful.
2020-01-14
     
Good upbeat trainer. Very knowledgeable. At times a bit fast for me to follow but soon explained.
2020-03-11
     
This course has enabled me to save time while running repeat tasks and using shortcuts and formulas to make the job easier.
2020-05-18
     
Clear, Informative, well presented. Despite delivering in one hour what is usually a 6 hour course, still managed to give lots of detail.
2020-03-11
     
The course will help me streamline processes and provide better data analysis. I think the course is excellent and provides a great level of knowledge.
2020-02-19
     
This training course in my opinion, would be beneficial for people starting out in Customer Services. The course has given me tips on how to further my training, although bespoke this to the company’s needs.
2019-12-18
     
I would recommend this course to anyone thinking of using Excel, after they’ve done the preceding courses.
2019-12-10
     
The experience was great with fun and interesting examples. Would definitely suggest it to other colleagues in the field.
2019-12-10
     
Highly recommend the course, it’s a good way to improve all colleague confidence and skill levels with using excel, which is a under used tool in everyday working life.
2020-01-29
     
Excellent course.
2020-03-19
     
I enjoyed the training. I think that Karen delivered the session very well and to the best of her ability – given that teaching via online can be very difficult. She made sure that all of the participants were fully engaged and took equal turns of control.
2020-03-11
     
I plan to create my own macros to speed up my projects. Vlookup & Macros had the most impact as I use them on a daily basis.
2020-01-28
     
I learnt how pivot charts will be useful in my job role. Gave me more confidence in Excel.
2020-01-17
     
The course was very interesting. I wrongly assumed I knew what I needed to know about Word but walked away with much more knowledge than I anticipated.
2019-12-18
     
Excellent – highly recommended.
2020-01-10
     
Excellent as per all imagine courses I’ve been on. Would highly recommend people to attend.
2020-02-19
     
My opinion on the session was mostly positive. I took more away from the workshop than I had to begin with. It got me thinking about some of the calls I take and how best I can integrate into my conversations with the customers so I come off as the best I can for BJS and for myself. The method that was showed to us on the day, especially with the Positive, Minus, Positive technique, is something I am going to use.
2019-12-10
     
I think it’s fantastic! Want to go on to learn more about formulas and further my education in Excel!
2020-02-11
     
I have learnt about shortcuts using the keyboard which is a much faster way of working and how to create different tables using information I've gathered.
2020-01-10
     
It was a good basic overview of the office package.
2020-01-28
     
Gave me a better knowledge of Excel and how to use the tips & tricks and shortcuts.
2020-03-11
     
The course has helped me to understand Macros and Formulas.
2020-03-11
     
I am going to take what I have learnt and experiment with a few ideas. Maybe a longer course so you can go into more detail.
2019-12-10
     
Highly recommend.
2020-02-27
     
The training delivered was specific for our shortfall in skills required for job.
2020-01-28
     
Better understanding of Excel, Pivot Tables etc.
2020-01-17
     
Perhaps at a slightly lower level than I would have benefited (I only suggested myself attending as a refresher if we had a space to fill), but I did pick up some useful hints & shortcuts to make it worthwhile. There is always something you can learn.
2020-01-29
     
lots of useful information.
2020-01-28
     
The course gave me a better understanding of Excel functions and allowed me to speed up on operations.
2020-01-17
     
Karen was very clear and thorough explaining shortcuts etc. and gave us enough time to practice & implement what we were taught. The course was an appropriate length and suitable for everyone’s capabilities. I would recommend the course to colleagues
2020-03-11
     
The course will improve my Excel skills especially with formulas, data tables and V Lookups
2020-01-28
     
I will be more in depth when doing my PC work and using the shortcuts.
2020-01-28
     
I will use the knowledge gained to improve production of information.
2020-02-07
     
I was very surprised how much I learnt and took away from this training, I would recommend this course to any person that uses Excel, even if you think you know it all, there is always more to learn.
2020-01-29
     
Great course
2020-01-14
     
I thought the course was excellent and covered a good range of basic Word skills.
2020-01-10
     
Very useful to have an overview as it ensures nothing is missed and the software is used to its full potential
2020-02-04
     
I did enjoy the training session. I hope that all I have learnt will be used as soon as out IT sort the access issues. The only minor drawback of the training was that I feel we need it more time practically to use the system and given tasks in the training. That would give us more confidence in what we have learnt. Allan is very experienced and knowledgeable about the system and gave us very good examples of the usage of the SharePoint.
2019-12-10
     
Very good course and very informative. I would recommend it fully to others, worthwhile to put all staff through this training.
2020-01-10
     
Encourage others to learn about this skill set.
2020-03-11
     
The course improved my efficiency working with Excel documents.
2020-01-14
     
I found the course to be excellent and provided a sound foundation to basic Word skills.
2020-02-06
     
I thought the training day was great, everything that was taught was done in a very professional way and was spaced out well with plenty of time to get a good understanding of everything that was being shown. Getting involved with the learning helped massively with understanding and remembering everything we was being taught. I would definitely recommend this course to my colleagues.
2020-02-25
     
I had a great day, learnt loads and looking forward to using what I have learnt.
2020-01-28
     
The course had an impact as my knowledge of Excel was limited but I can now use it with more confidence.
2020-01-17
     
Extremely relevant course
2020-01-28
     
I learnt more of Excel and how to develop my role.
2020-01-10
     
I believe it was a great course, especially for people who already know a lot about outlook as it is good for refresher training also. You may think you know it all, but there will always be something that will stump you.
2020-02-27
     
Simply love it 😊
2020-01-14
     
I enjoyed the training today, I have learnt a few more things I did not know which is always a help. I would recommend other to attend. Yes there were things I already knew but quite a few I did not. Once put into practice they will help me in me everyday.