Advanced Excel Dashboards
- 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.
- Use advanced features to create dashboards in Excel.
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,132 people .
- Over 14,056 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
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.
Training Course Content
Planning a Dashboard
Who is the audience?Detail level
Time scale considerations
Managing Dashboards
Efficient dashboard updatingManaging 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 and 2016)
Advanced charts for Dashboards
Waterfall ChartSpeedometer Chart
Gantt Chart
Forecasts and Trend analysis in Dashboards
Linear and seasonal data sourcesStatistical formulas for Dashboards
Slope, Variance,Multiple page Dashboard
Creating interactivity using macros
PowerView (2013 and 2016)
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.8
Based on 8 reviews.
Write a review!
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
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 do...