The best solution for Training Courses UkA hands-on one-day course with free pre-course online skills testing
Note: this Excel Dashboards course is CPD certified.
It is delivered as a classroom course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.
Full details of modules and topics covered in this one-day course
This course covers 2010, 2013 and 2016 versions
This is a one-day training course structured into 7 modules
This advanced one-day training course teaches delegates how to create interactive Excel dashboards, that update with the click of the Refresh button, or with a simple copy and paste of your new data into your spreadsheet.
Anyone with an advanced knowledge of Excel who wants to learn how to create dashboards which will enhance their spreadsheets with easily understood and interactive data displays.
Excel Dashboards provide insight, analysis and even alerts. They are interactive and dynamic, and have a wide range of applications, providing help with project management, customer service, KPI management, forecasting and so on.
They usually fit on one page, displaying key trends, comparisons and data in small graphs or tables. This makes them easy to read and digest the information. They are also often interactive, which allows the user to filter data and switch views themselves.
- Overview of how dashboards are so useful
- Inserting a Simple Chart
- Using Sparklines with Dashboards
- Using Tables to Dynamically Link Charts & Lists
- Linking Charts Across Worksheets
- The OFFSET Function
- Nested IF Statements Using the AND and OR Operators
- The MATCH Function
- Creating Bespoke Navigation Bars
- Creating Dashboard Links
- Using Named Objects
- Organising Data in Data Tables using IFs
- Using Table Formulas to Make Dynamic Charts
- Using More Table Formulas with Conditional Formatting
- Using OFFSETs, VLOOKUPs and Name Range Lists
- Adding a Data Bar into your Dashboard
- Creating a Window Chart
- Creating an Advanced Comparison Chart
- Creating a Timeline Chart
- Looking at Macros and the Visual Basic Interface
- Configuring Controls using Macros
- Ironing out Minor Issues in your Dashboard with VBA
- The Select Case
Don't see a date you want?
[Duration: one day]
- Working with Functions and Formulas
- Outlining, Grouping and Sub Totals
- Protecting Your Spreadsheet
- Presenting Data with Charts
- Formatting Financial Data
- Data Tools: Managing Your Data
- Formula Auditing
- LOOKUP Functions
AVERAGE REVIEW: 4.7 out of 5 BASED ON 12 REVIEWS
All Activia training courses uk has been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.
Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.
Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.
For training at your offices, we can deliver classes of up to 10 delegates, though with bigger class sizes you must understand that there is less time for questions from delegates, and this may affect the quality of their experience.
Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
Also note: If you are a private individual you must pay by credit card at the time of booking.
Note: Please allow 1 - 2 working days for your confirmation and invoice.
If you are coming to our centre, dress code is smart casual. Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:
Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !
For training at your offices, this itinerary can be varied by prior arrangement.
With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.
Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.