MICROSOFT EXCEL
Excel Dynamic Dashboard Reporting
Microsoft Excel Dynamic Dashboard Reporting is a comprehensive course that equips participants with the skills to construct clear and easily understandable dashboards. It is targeted towards managers and professionals requiring data analysis and presentation. Dashboard reports offer a clear and concise view of business information, making it easily readable, understandable, and updatable. By condensing various results into a single page for comparison, these reports simplify the reporting process and reduce the time required to assess organisational performance.
3-Day Course
Max 15 Learners
Virtual, On-Site or Hybrid
Pre-requisites
Participants must have advanced knowledge and skills in Excel.
Why Attend?
With the huge amount of data available to us every day, a well-built and designed dashboard report is one of the best ways to interpret and communicate large quantities of information. You will learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs using Excel.
What Will You Gain?
After this course, you will learn how to:
- Organise and format lists
- Capture data correctly in excel
- Apply custom Number formatting
- Insert text functions
- Work with text
- Use flash fill to save time
- Manage and apply conditional formatting
- Insert and format Excel tables
- Create and customise Sparklines to enable you to analyse trends
- Create PivotTable Reports
- Apply PivotTable Report Options
- Create a PivotChart for an existing PivotTable
- Dashboard Reporting
- Use Slicers to filter data
- Use a Timeline to filter by time period
What Learning Materials Are Included?
We supply the following for virtual and face to face training:
- Comprehensive learner manual
- Digital cue cards with quick tips and shortcut keys
- Highly practical, integrated and engaging learning experience
For all virtual sessions we provide an end-to-end service including:
- Scheduling and hosting of all Microsoft Teams sessions
- Delegate invitations and reminders
- All related training correspondence and IT support during workshops
Took my skills to a whole new level!
I really enjoyed the course, lots of tips and made my work so much easier to do. I attended an advance course (with another company), and it was information overload. With Key Steps, I feel the examples used were better and more practical. The course kept my attention and has helped me take my skills to a whole new level. I recommend this to everyone using Excel. Thanks so much! I gained practical knowledge through the use of the training examples and shortcuts. Thank you!
Learned new tricks!
The trainer was great! The workshop was great! I learned new tricks and so many things that I didn’t know.