Excel: Creating a Dashboard with Power Query (Microsoft 365)

Creating an Excel dashboard from scratch can feel overwhelming. How do you start? What if you have a lot of data? How do you set up the calculations? In this course, follow along with Excel MVP Leila Gharani as she shows you how to design an interactive Excel dashboard from scratch. Learn to use Power Query, the Excel Data Model, and PivotTables to get it all set up fast. Discover how to import and create a connection to the data and refresh it with one click using Power Query. Leila also shows how to use Power Query to clean data and set up calculation logic. Then, with the Data Model, you can create relationships between the data sets. Finally, learn how to extract the information you need using PivotTables and display it with linked shapes and pictures and PivotCharts. You can discover dozens of useful Excel dashboard tips and tricks along the way. Start creating your own data-rich dashboards today.

This course was created by Leila Gharani. We are pleased to offer this training in our library.

Learn More

Related Classes

Choosing a Linux Distribution

Scott Simpson

Linux distributions provide a set of tools and decisions about how a Linux system should operate. There are thousands of…

Google Cloud Foundations

Mark Johnson

When it comes to understanding how Google Cloud works, it’s easy to get lost in the details and feel like…

.NET 6 Deep Dive

Walt Ritscher

This course takes a deep look into the changes to .NET with the release of .NET 6, the latest release…

Become a Digital Trust & Safety Leader

Tiffany Xingyu Wang

Trust and Safety (T&S) is quickly becoming a priority for all digital platforms and brands. A lack of T&S measures…

Using Power BI with Excel

Madecraft

Are you ready to take your skills as a data analyst to the next level? Power BI is an easy-to-use…

Deploying and Configuring Core TCP/IP Services

Joli Ballew

Need to configure TCP/IP networking? In this course, Joli Ballew covers installing and configuring core TCP/IP services. She shows you…

Excel: Dashboards for Beginners

Jordan Goldmeier

Did you know that you can quickly create a dashboard in Excel even if you’re pressed for time? While many…

Java Essential Training: Syntax and Structure

Angie Jones

Java is one of the most popular programming languages in the world, running on billions of devices across the globe.…

Managing Resources with Azure Policy

James Millar

Azure Policy is a governance and compliance tool that helps to enforce organizational standards and to assess compliance at-scale. In…

Microsoft Teams: Working with Files

Nick Brazzi

Microsoft Teams changed the way we work. With Teams, you can share files in a one-on-one chat, during a Teams…

What Business Leaders Need to Know about Web3 (+ Metaverse)

Cathy Hackl

In the same way that social media, ecommerce, and even the internet itself were once seen as passing fads but…

Crisis Communication Planning After a Ransomware or Other Cybersecurity Attack

David Oates

Cyberattacks are a huge problem, but you can prepare your organization with a multi-faceted communications program to inform and reassure…

Azure AI Fundamentals (AI-900) Cert Prep: 3 Computer Vision Workloads on Azure

Emilio Melo

Computer vision enables computers and systems to derive information from digital images, videos, and other visual inputs and take actions…

MongoDB Essential Training

Naomi Pentrel

MongoDB is a NoSQL document database with an expressive and intuitive query language. While MongoDB is easy to get started…

Learning Python Generators

Megan Amendola

Generators are a concept unique to Python. They’re incredibly helpful if you know how and when to use them. Simply…

Git Code Challenges

Ray Villalobos

You’ve used Git and maybe have your own workflow established. How much do you know about the broader possibilities though?…

AI 2041: Five Visions for Our Future (Book Bite)

Next Big Idea Club

What will the world look like in 20 years? Will it be shaped by artificial intelligence? And if so, how,…

Kotlin Essential Training: Object-Oriented and Async Code

Nate Ebel

If you’re looking to get up and running with Kotlin, the powerful programming language from JetBrains, join instructor Nate Ebel,…

Network Programming in C

Dan Gookin

Are you a C programmer looking to explore networking programming? In this course, instructor Dan Gookin provides an overview of…

Microsoft Security, Compliance, and Identity Fundamentals (SC-900) Cert Prep: 4 Understanding Microsoft Security and Compliance Capabilities

Pete Zerger

Are you looking for work in the security space or preparing to earn your Microsoft Security, Compliance, and Identity Fundamentals…