-
Business
Microsoft Excel Dashboard
-
Attendance/Duration
Delivery Method: Face to Face delivery
Course Duration: 6 hours (1 day)
Delivery Method: Online Delivery
Course Duration: 4 hours total. 2 x 2 hours live interactive tutorial sessions
-
Cost
For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk
Whats Involved
This course is suitable for those with a good working knowledge of Excel at intermediate level.
In management information systems, a dashboard is an easy to read, often single page, real-time user interface, showing a graphical presentation of the current status and historical trends of an organisation’s key performance indicators to enable instantaneous and informed decisions to be made at a glance.
Excel Dashboards allow the user to slice big data sources into easy to understand information formats.
This course will cover the following:
- Designing the dashboard
- Using formulas and formatting
- Creating pivot tables and charts
- Creating slicers
- Working with data across multiple worksheets
- Recording macros to enable interactivity
- Protecting the dashboard
By the end of this course participants will have a better understanding of how to present and analyse data to help users make informed decisions.
Funding and Fees
For further information please email businessgrowth@ayrshire.ac.uk
Enquiries
For further information please email businessgrowth@ayrshire.ac.uk
