Add to basket or enquire
Microsoft Excel Dashboard is a page in Excel that contains information and data in forms of charts, tables and views to help higher officials in an organisation to track key KPIs or metrics. It has evolved into a crucial technique to make decisions in the business world and hence, could be a great way to progress in your career if you excel in creating mind-blowing dashboards in the spreadsheet application. If you came here wanting to learn dashboard designing to spruce up your skills, this course has got you all covered.
This video course will first off by exploring the features and constraints in Excel to consider it in your dashboard designing process. You will then be taught on how to connect to MS Access, MS SQL server and PowerPivot to import the data stored in them to the Excel dashboard. How to use relationships and hierarchies to use data from various sources in your dashboard and to knit them together will also be further discussed in this course, followed by guidelines on how to implement the KPIs to track if the business has achieved its goals and objectives.
You will then move onto work with PivotTables and PivotCharts to present the imported data in Excel, along with an insight into the techniques and methods used to style the data in Excel dashboard to make it more appealing. The subsequent modules will educate you on how to implement slicers, timeline slicers and hyperlinks to improve the dashboard interactivity and on how to create drill-downs, filters, tiles and multiples using Power View. You will also be walked through how to publish your dashboard in Microsoft SkyDrive and Office 365 SharePoint to use it in the decision making process. By the end of this course, you will have a well-grounded knowledge in dashboard designing to make significant progress in your career.
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
Module 1: Dashboard Outputs And Inputs
Module 2: Implementing PowerPivot
Module 3: Working With Pivottables
Module 4: Constructing Your Framework
Module 5: Stylizing Your Data
Module 6: Adding Interactivity
Module 7: Utilizing Power View
Module 8: Publishing Your Dashboard
Method Of Assessment
The course is assessed online with a final, multiple-choice test, which is marked automatically. You will know instantly whether you have passed the course.
Those who pass this test will get a certificate in Microsoft Excel 2013 Dashboard Design
Who is this course for?
This course might interest individuals looking to improve their knowledge on Excel to make progress in their career
- Learners must be age 16 or over and should have basic understanding of the English Language, numeracy, literacy and ICT.
- A working knowledge on Excel is required to follow up on this course
- Business Analyst – £30,407 per annum
- Financial Analyst – £31,090 per annum
- Data Analyst – £25,972 per annum
- Strategic Planning Manager – £48,006 per annum
- Business Consultant – £37,658 per annum
Questions and answers
Currently there are no Q&As for this course.Be the first to ask a question.
Rating and reviews
There haven't been any reviews for this course yet.Leave a review
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.