logo

Create an Excel Dashboard with Power Query (Office 365)

feature icon

Self-paced course

Price

Rating

Overview

Creating a Dashboard in Excel from scratch can feel overwhelming. But it does not have to be!

In this class we will use Excel Power Query together with Excel's data modeling and Pivot Table tools to get it setup REALLY fast.

In this class you will learn:

  • Import from Text/CSV and Excel files
  • Apply regional settings to make sure dates and numbers are shown correctly
  • Use Excel's data model and Power Pivot
  • How to create an interactive dashboard that can be refreshed with the click of a button
  • How to use Pivot Charts and Pivot Slicers
  • Useful Excel Dashboards Tips and Tricks

The techniques we cover in this class will give you additional ideas to apply to your own reports to give them an edge and make them more professional.

Follow along with me and create this interactive dashboard from scratch!

Skills you will gain

Similar courses

course image
Excel for the Real World: Gain the Basic Skills of Microsoft Excel
logo
Skillshare
course image
PowerPoint For Beginners
logo
Skillshare
course image
Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals!
logo
Skillshare
course image
Microsoft Excel 2016 Bootcamp - Zero to Hero Training
logo
Skillshare
course image
Microsoft Powerpoint entry level course
logo
Skillshare
course image
(2022) Microsoft Office- Learn Excel from very basics-NEW
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

1095 students

feature icon

English

feature icon

Beginner

Provided by

Authored by