Course description
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! This TWO HALF DAY course will enable you to present business data in Excel without using Power BI. You’ll learn more advanced techniques to display the data to the management team.
Suitability - Who should attend?
Who is this for?
This TWO HALF 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.
Training Course Content
- The differences between Dashboards & Reports Questions before you start
- Dashboard design principles
- Golden Rules
- Formatting numbers effectively
- Custom Number formats
- Useful Formulas for Dashboards
- Data tables
- Charts
- Sparklines
- Charts that show trending
- Side-by-side comparison charts
- Secondary axis
- Conditional Formatting
- Using Symbols to enhance Reporting
- Camera Tool
- People graphs
- Pivot Tables
- Creating
- Sorting
- Filtering
- Re-arranging
- PivotCharts
- Issues with file size
- Pivot Table reports
- Interactivity with slicers
- Dynamically rearranging pivot table data
- Grouping & bucketing data
- Showing performance against target
- Macros
- Useful macros for dashboards
- Navigation buttons
- Form Controls
- Time slicers
- Protecting your dashboards
- 10 Questions before distributing your dashboard
Reviews
Average rating 4.9
Karen Turner has got good level of knowledge. Great speaker.
The training was well tailored to the requirements.
Request info
Imagine Training
Welcome to Imagine Training, empowering businesses through comprehensive Microsoft 365 training with a particular emphasis on Excel Training. As we navigate through the rapidly evolving digital age, our mission is to ensure your organisation not only keeps pace but excels....