Overview
What does the course cover?
Dashboards provide a visual way to view data. Excel Dashboards teaches the skills needed to structure a spreadsheet so that data can be presented using powerful and visually appealing charts and graphs which dynamically update when data changes or users modify settings.
Aims
Why take this course?
You’ll be able to produce professional feature rich Dashboards that explore your organisations data and provide compelling Excel Dashboards that will allow managers to step back from the details and see the key trends and relationships that drive their companies.
Audience
Who would benefit?
Experienced Excel users who have Microsoft Office Specialist Expert level or who have completed our Excel Level 3 course and want to progress to the next level.
Skills You’ll Learn
What you’ll be able to do after the course
- Learn different report strategies
- Work with conditional formats
- Learn to concisely summarise data in Excel
- Design feature rich dashboards
- Learn to use Excel’s data validation
How You Can Apply These Skills
What you’ll be able to use these skills for
- Build robust cross checked spreadsheets
- Work with lists and any other form of database
- Create precise and dynamic mini-charts
- Create a range of mini-charts, heat-maps, dials
- Design spreadsheets for team use
Certification
When you pass you will receive an internationally recognized accreditation certificate like this:
What’s next?
Upon completion, you can move onto Excel VBA, or sign up to become an Excel Master.
Careers that require these skills at this level?
Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.
Want to start learning today?
Joining is simple, easy and risk free with our 7 day money back guarantee.
