98.9% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Advanced Excel Dashboards
Face to face / Virtual closed & onsite training. Restaurant lunch included at STL venues.
Designed for Excel 365
- 1 day Instructor-led
Syllabus
Who is this course for?
This Advanced Excel Dashboards course is ideal for those looking to develop their existing dashboards skills in Excel. Roles that would benefit from this training include BI (business intelligence), data managers, data analysts, or Project Managers.
Objectives
By the end of this course you will be able to:
- Use advanced features to create dashboards in Excel.
- Become proficient in the planning, creation and maintenance of advanced Excel dashboards.
Prerequisites
Completion of our Excel Dashboards for Business Intelligence course or equivalent knowledge of the following:
- Basic charts
- PivotTables
- Named Ranges
- Form Controls
- Absolute & Relative cell references
Functions:
- If and Nested Ifs
- Sumifs, Countifs & Averageifs
- Vlookup and Hlookup
- Index & Match
Course Syllabus
Planning a Dashboard
Who is the audience?
Detail level
Time scale considerations
Managing Dashboards
Efficient dashboard updating
Managing sources
Source data for reporting
Prepare data (flat lists)
Link to external data sources
Multiple data sources dashboard (PowerPivot)
Reports based on data models (2013 & 2016)
Advanced charts for Dashboards
Waterfall Chart
Speedometer Chart
Gantt Chart
Forecasts & Trend analysis in Dashboards
Linear & seasonal data sources
Statistical formulas for Dashboards
Slope, Variance,
Multiple page Dashboard
Creating interactivity using macros
PowerView (2013 & 2016)
What you get
"What do I get on the day?"
Arguably, the most experienced and highest motivated trainers.
Face-to-face training
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
Lunch, breaks and timing
A hot lunch is provided at local restaurants near our venues:
- Bloomsbury
- Limehouse
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Refreshments
Available throughout the day:
- Hot beverages
- Clean, filtered water
- Biscuits
Virtual training
Regular breaks throughout the day.
Learning tools
In-course handbook
Contains unit objectives, exercises and space to write notes
Reference material
Available online. 100+ pages with step-by-step instructions
24 months access to Microsoft trainers
Your questions answered on our support forum.
Training formats & Services
Training Formats & Services
Training formats available
|
Testimonials
Summary
FastNet Ltd
Chris Lamb,
Finance Director
This course was spot on, a great follow up to the previous BI/Dashboards one I did a few weeks ago. Its definitely worth booking these close to one another and puttin thiings into practice back at work in the meantime to get the best of the courses.
Jens was great and this time was perfectly timed in terms of pace, however the final part I thought was too much copying what was being typed from his instructions so we weren't really learning as such, and we weren't looking at how the background of the design of the dashboard was done. I think what would be good would be an excersise using some base data for us to try and design our own dashboard or perhaps formulate a choice of 2-3 things - then have some time to do so, then all look at each others' work.
Advanced Excel Dashboards
HSBC
Alexander Orlov,
Project Manager
Amazing, thank you , will keep in touch and will see you back shortly
Advanced Excel Dashboards
Aesica Pharmaceuticals
Veronica Glyn,
Product Stream Engineer
Brilliant course, Paul has saved us a lot of time with useful hints and tips.
Paul explained many methods for making our dashboards flexible and easy to update so that it does not require a lot of constant maintenance.
Similarly, whilst Paul went through the course material he also showed us how to lay our work out in a methodical way so that it would be easy to fault find and easy for others to check.
Advanced Excel Dashboards
Get On-site/Closed quote
Excel range
Excellent
HSBC
Project Manager
Alexander Orlov
I was looking for a specific training for my data analytical team to equip them with more tools to slice and dice the data, building more trust worthy sophisticated propensity models, using SQL, VBA and Excel. I came across with STL training and my research and expectations were match by 100%. Spot on! Great professionals! Highly recommended for all banking and financial professionals that are using Excel on BAU basis.
Resources
Promotions
Latest Tweet
Thanks. Your download will begin shortly.
Please help us
Share or create a link to this manual today!
Just follow these simple instructions...
