Advanced Excel Dashboards
Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... 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.
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?
Time scale considerations
Efficient dashboard updating
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
Forecasts and Trend analysis in Dashboards
Linear and seasonal data sources
Statistical formulas for Dashboards
Multiple page Dashboard
Creating interactivity using macros
PowerView (2013 and 2016)
Prices from £748. Promotional rates often available the further ahead you book. Contact us for quote.
Best in-class training - Be delighted, not just satisfied
We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch, to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....
Find a course for you!
Find out more about this Advanced Excel Dashboards course - simply fill out your details:
Find more courses here