Excel Dashboard for Beginners: AI & Pivot Tables Mastery
Quadri Ilebiyi
Assista a este curso e milhares de outros
Assista a este curso e milhares de outros
Aulas neste curso
-
-
1.
Welcome to the course
2:00
-
2.
What is Dashboarding & why it matters
3:00
-
3.
Download Resource files & template
1:18
-
4.
Cleaning and Formatting Raw Data
14:12
-
5.
Turning Raw Data into a table
6:30
-
6.
Building a Basic PivotTable (using AI)
4:14
-
7.
Building and Formatting PivotTable for Dashboard use
16:24
-
8.
Create and format Column Charts
12:00
-
9.
Create and Format Bar Chart
7:10
-
10.
Create and Format Line Chart
4:48
-
11.
Create and Format Doughnut Chart
7:34
-
12.
Setting up the Dashboard Layout
7:43
-
13.
Link Charts to Dashboard
6:41
-
14.
Building the Metrics
15:28
-
15.
Inserting Slicers & Timeline
6:43
-
16.
Linking Slicers & Timelines to Charts and Dashboard
8:18
-
17.
Dashboard + AI
5:22
-
18.
Dashboard + Copilot AI
9:14
-
19.
Using Map in Excel
5:05
-
20.
Exporting as Template
4:14
-
21.
Sharing your Dashboard
3:09
-
-
- --
- Nível iniciante
- Nível intermediário
- Nível avançado
- Todos os níveis
Gerado pela comunidade
O nível é determinado pela opinião da maioria dos estudantes que avaliaram este curso. Mostramos a recomendação do professor até que sejam coletadas as respostas de pelo menos 5 estudantes.
4
Estudantes
--
Sobre este curso
Create stunning Excel dashboards fast with Pivot Tables, charts, slicers, AI and AI tools like Microsoft Copilot AI.
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.
Start transforming raw data into beautiful, actionable Excel dashboards today!
Download the resource files: https://drive.google.com/drive/folders/1O9L4To-ZryMfw0dqa1E8TeXYKKBXTwIB?usp=sharing
Projeto prático de curso
Project Instructions
Download the resource files: https://drive.google.com/drive/folders/1O9L4To-ZryMfw0dqa1E8TeXYKKBXTwIB?usp=sharing
For your class project
- After downloading the Resource Files from the link above then, practice along with me in the course as I teach you practically from scratch how to build a Dashboard with Hands-on Real-World Projects
Submit your final result as an excel file
Nota do curso
Por que fazer parte da Skillshare?
Faça cursos premiados Skillshare Original
Cada curso possui aulas curtas e projetos práticos
Sua assinatura apoia os professores da Skillshare
Aprenda em qualquer lugar
Faça cursos em qualquer lugar com o aplicativo da Skillshare. Assista no avião, no metrô ou em qualquer lugar que funcione melhor para você, por streaming ou download.
