logo

Building Interactive Dashboards Using Microsoft Excel

feature icon

Self-paced course

Price

Rating

Overview

The class is about learning the process of setting up an interactive dashboard using Microsoft Excel. This includes data collection methods, data formatting, creating pivot tables, creating charts, and putting it together into one branded interactive dashboard. It will also go over the use of the correct charts and a little theory behind it.

This class is for students who know their way around in Excel. It’s not a beginners guide to Excel, but rather how to use Excel to put the theory of information visualization into practice. If you have some experience with Excel, mainly in creating tables, formatting and basic formulas, this class is suitable for you. If you are new to Excel, it is recommended to start getting familiar with the program before taking this class.

This class will help you understand (read: not just learn) what creating a dashboard really means. Aside from the tips and tricks learned in Excel, the thought about correctly presenting data, making the sheet error-proof and optimizing the learnings from the data is valuable for reporting with Excel. It helps to more effectively communicate information to yourself, clients and/or colleagues.

You'll need Microsoft Excel 2010 or older to take this class. There’s one small feature that will be discussed that is only available in Windows versions.

Similar courses

course image
Improve Your PowerPoint & Design skills! Get Amazing Presentations Done. Fast & Efficient
logo
Skillshare
course image
Microsoft PowerPoint: Learn PowerPoint Basics!
logo
Skillshare
course image
Beginners Guide to Microsoft Excel - Data Entry
logo
Skillshare
course image
Excel Functions for Accountants
logo
Skillshare
course image
Learn Power Query for Excel & SAVE Time
logo
Skillshare
course image
Microsoft Excel Formulas You Need to Know in 30 Minutes!
logo
Skillshare

Featured articles

Sep 12, 2022

WATCH these YouTube videos if you can't start learning a language

5

0
1
4K

Sep 12, 2022

How Memrise works + reviews [2022]

6

0
1
4K

Sep 12, 2022

5 tips to learn languages with YouTube videos [2022]

7

0
1
3K

Sep 12, 2022

How I Became a Marketing Manager at Microsoft

8

0
1
2K

Sep 24, 2022

How Edureka works + reviews [2022]

3

0
2
2K

Sep 27, 2022

How Codecademy works + reviews [2022]

3

0
2
2K
course image
feature icon

3520 students

feature icon

English

feature icon

Beginner

Provided by

Authored by