reed.co.uk Courses

Header

Check out our Christmas deals

Microsoft Excel 2013 Dashboard Design


Global Edulink

Summary

Price
Save 65%
£69 inc VAT (was £199)
Offer ends 10 December 2019
Study method
Online, self-paced
Duration
3 Hours
Access to content
365 Days
Qualification
5 CPD points / hours
Additional info
  • Exam(s) / assessment(s) is included in price

Add to basket or enquire

Overview

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.

Course media

Description

Access Duration

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.

Course Curriculum

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.

Certification

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

Requirements

  • 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

Career path

  • 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

Modals

Mobile Navigation