Course description
Microsoft Excel Level 4: Dashboards
Master Data Visualisation: Microsoft Excel Level 4 Dashboards (2 Half Days)
Struggling to keep track of key performance indicators (KPIs) scattered across multiple systems? This Microsoft Excel Level 4: Dashboards course is your solution!
Take control of your data and learn to create compelling dashboards directly within Microsoft Excel.
Throughout this Microsoft Excel Level 4 course, you'll:
- Master Dashboard Design Principles: Learn the golden rules of crafting effective dashboards that tell a clear story with your data.
- Unlock Advanced Formatting: Discover powerful formatting techniques to ensure your dashboards are visually appealing and easy to understand at a glance.
- Microsoft Excel Level 4 Formulas for Dashboards: Leverage advanced formulas in Excel Level 4 to manipulate data, calculate trends, and present insights with clarity.
- Charting Expertise: Go beyond basic charts and master techniques for creating impactful visualisations that effectively communicate complex data.
- Sparklines & Conditional Formatting: Master advanced visualisation tools like Sparklines and Conditional Formatting to add depth and clarity to your Microsoft Excel Level 4 dashboards.
- Interactive Dashboards with Slicers: Learn how to incorporate slicers to create dynamic dashboards that allow users to explore data interactively.
- Protecting Your Work: Discover best practices for safeguarding your sensitive data within your Excel Level 4 dashboards.
By the end of this Microsoft Excel Level 4 Dashboards course, you'll be able to:
- Consolidate data from various sources into a single, informative dashboard.
- Craft compelling visualisations that effectively communicate data insights to management.
- Make data-driven decisions with greater speed and confidence.
- Impress stakeholders with your advanced Excel Level 4 dashboard creation skills.
Don't settle for static reports! Elevate your data presentation skills with this Microsoft Excel Level 4 Dashboards course. Enroll today and unlock the power of data visualisation in Microsoft Excel!
Upcoming start dates
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
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....