Beginner LevelOffice Productivity

Excel Dashboard for Beginners: AI & Pivot Tables Mastery

Create stunning Excel dashboards fast with Pivot Tables, charts, slicers, AI and AI tools like Microsoft Copilot AI.

Created by Coding Creative Guru

2.5 hours

Video Content

Lectures

245

Students

5.0

Rating

5.0

(245 students enrolled)

What you'll learn

✓Build professional Excel dashboards from raw data using Pivot Tables

✓Analyze and summarize data quickly with AI-driven pivot recommendations

✓Visualize business metrics with charts, slicers, and timelines

✓Leverage Microsoft Copilot AI and other AI tools to generate insights

✓Design interactive dashboards to support decision-making

✓Export and share dashboards for reports and presentations

Course Content

8 sections • 22 lectures • 02:31:10 total length

01 Welcome & Dashboard Basics

4 lectures • 06:21

Welcome to the course02:02

What is Dashboarding & why it matters03:00

Download Resource files & template01:18

Resource Files00:01

02 Preparing your Data for Dashboarding

2 lectures • 20:42

Cleaning and Formatting Raw Data14:12

Turning Raw Data into a table06:30

03 Creating Powerful PivotTables

2 lectures • 20:38

Building a Basic PivotTable (using AI)04:14

Building and Formatting PivotTable for Dashboard use16:24

04 Add Charts that impress

4 lectures • 31:32

Create and format Column Charts12:00

Create and Format Bar Chart07:10

Create and Format Line Chart04:48

Create and Format Doughnut Chart07:34

05 Designing a Stunning Dashboard Layout

3 lectures • 29:52

Setting up the Dashboard Layout07:43

Link Charts to Dashboard06:41

Building the Metrics15:28

06 Adding Interactivity

2 lectures • 15:01

Inserting Slicers & Timeline06:43

Linking Slicers & Timelines to Charts and Dashboard08:18

07 Dashboard, AI, Copilot

2 lectures • 14:36

Dashboard + AI05:22

Dashboard + Copilot AI09:14

08 Finalizing and Sharing your Dashboard

3 lectures • 12:28

Using Map in Excel05:05

Exporting as Template04:14

Sharing your Dashboard03:09

Description

Do you want to create stunning, interactive Excel dashboards even if you’re a complete beginner?

This course will teach you how to build professional Excel dashboards from raw data using Pivot Tables, charts, slicers, Timeline, and powerful AI features including Microsoft Copilot AI. Whether you’re a student, business professional, freelancer, or entrepreneur, mastering these skills will help you analyze data quickly and make smart, data-driven decisions.

You’ll start by learning how to clean and organize your data for easy analysis. Then, you’ll dive into creating Pivot Tables, one of Excel’s most powerful tools, enhanced by AI recommendations that help you choose the best summaries and layouts automatically.

Next, you’ll add visual elements like charts, slicers, and timelines to create dashboards that are not only insightful but also interactive and user-friendly. Plus, you’ll learn how to use Microsoft Copilot AI and other AI tools integrated in Excel to generate instant data insights, automate formula writing, and speed up your workflow.

By the end of the course, you’ll have a complete, professional sales dashboard that can be customized for any project or business need. You’ll also gain confidence using AI-powered Excel features that make data analysis faster and smarter.

Perfect for beginners and professionals alike, this course will boost your Excel skills and prepare you for the future of data analysis and business reporting.

Enroll today and start transforming raw data into beautiful, actionable Excel dashboards!