Course details
In This course you will learn how to create dash boards using Excel
Excel is a great tool for creating and analysing dashboards.
Pre-Requisites
Excel Intermediate
Course Outline
- Introduction
- Dashboard Do's and Don't's
- Data Layout Creating Dynamic Dashboards
- Merging and Consolidating Data Using Shapes to make Charts more attractive
- Using Alerts to draw attention to dashboards
- Module 6 - More Dashboarding
- Creating KPI Dashboards
- Project Management
- Dashboards Publishing Excel Dashboards to the Web
- Working with your Data
- Understanding Data Quality issues
- Gathering data from different sources
- Linking Data
- Merging and Consolidating Data
- Excel Hints and Tips when working with data
- Analysing Data
- Using the dashboards with Excel Pivot Tables
- Using external data sources such as The Web
- Dashboarding with Microsoft Access information
- Build Your Own Dashboard
- This last session will be used to build some relevant Dashboards. Delegates are encouraged to bring examples of the dashboarding they would like to create during the training.
Course Location
About Leading Edge
Leading Training offers a large range of exciting short courses. Training in Information Technology, Web Design and Development (programming), Linux , MS Office/ Open Office, Management and Business Skills. Part-time and full time study available for selected courses.
The Leading Edge Enhanced Learning Model combines a number of modes of learning over a period of time to ensure the maximum Return On Investment for the intervention. The model has four stages : Pre-Assessment and consulting, Priming and framing, face to face instruction, Post Assessment and spaced repetition.
See all Leading Edge courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel Certification Levels 1-3 Courses Distance Learning Ltd.ZAR 906
ZAR 1,812Duration: Upto 40 Hours - Microsoft Excel: Automated Dashboard Academy for Health & FitnessZAR 227Duration: Upto 5 Hours
