Skip to content

Microsoft Excel - Dashboard

GoSkills

Summary

Price
£199 inc VAT
Or £66.33/mo. for 3 months...
Study method
Online
Course format What's this?
Video with subtitles and transcript
Duration
12 months · Self-paced
Qualification
No formal qualification
CPD
21 CPD hours / points
CPD What's this?
Certificates
  • Certificate of achievement - Free
  • Certificate of completion - Free
21 students purchased this course

Add to basket or enquire

Overview

Take your Excel skills to a whole new level by learning how to build dynamic Excel dashboards to show off your data. This online course will teach you the data visualization skills you need to design any dashboard in Excel exactly the way you want.

CPD

21 CPD hours / points
Accredited by The CPD Certification Service

Description

In 42 practical tutorials you will:

  • Understand the goals of data visualization.
  • Learn to use conditional formatting, from data bars to icon sets to add finesse to your dashboard.
  • Review the Excel logic functions which are key to adding dynamics to your dashboard.
  • Explore the 5 rules of effective charting.
  • Start by building bar charts, column charts, pie charts and line charts to display your data.
  • Build more complex charts like scatter plots, combination charts and more to really tell your story.
  • Add interactivity to your dashboard with the MATCH () and INDEX () functions.
  • Leverage pivot tables within your dashboard to add even more interactivity.
  • Learn “black magic” dashboarding tricks, like using Emojis and VLOOKUP to further enhance your data.

Who is this course for?

This online course is designed to teach people who are familiar with Microsoft Excel to use Excel more effectively for work and study. It includes 42 lessons, beginner, intermediate and advanced level lessons delivered in bite sized, engaging video tutorials by an award-winning Microsoft Excel MVP instructor, Ken Puls.

Requirements

You should come to this course with a comfort level of building IF functions at a minimum, and knowledge of Pivot Tables is an asset, but not a requirement. At the end of the course, you will have gained the practical skills you need to create beautiful, functional and interactive Excel dashboards.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Certificates

Certificate of achievement

Digital certificate - Included

Certificate of completion

Digital certificate - Included

Reviews

4.3
Course rating
80%
Service
100%
Content
80%
Value

Legal information

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.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Accountancy courses, Microsoft 365 courses, Accounting courses, Online courses