Excel Dashboard for Beginners: AI & Pivot Tables Mastery
Quadri Ilebiyi
Regardez ce cours et des milliers d'autres
Regardez ce cours et des milliers d'autres
Leçons de ce cours
-
-
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
-
-
- --
- Niveau débutant
- Niveau intermédiaire
- Niveau avancé
- Tous niveaux
Généré par la communauté
Le niveau est déterminé par l'opinion majoritaire des apprenants qui ont évalué ce cours. La recommandation de l'enseignant est affichée jusqu'à ce qu'au moins 5 réponses d'apprenants soient collectées.
6
apprenants
--
À propos de ce cours
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
Projet de cours pratique
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
Notes attribuées au cours
Pourquoi s'inscrire à Skillshare ?
Suivez des cours Skillshare Original primés
Chaque cours comprend de courtes leçons et des travaux pratiques
Votre abonnement soutient les enseignants Skillshare
Apprenez, où que vous soyez
Suivez des cours où que vous soyez avec l'application Skillshare. Suivez-les en streaming ou téléchargez-les pour les regarder dans l'avion, dans le métro ou tout autre endroit où vous aimez apprendre.
