Excel Dashboard for Beginners: AI & Pivot Tables Mastery
Quadri Ilebiyi
Ve esta clase y miles más
Ve esta clase y miles más
Lecciones en esta clase
-
-
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
-
-
- --
- Nivel principiante
- Nivel intermedio
- Nivel avanzado
- Todos los niveles
Generado por la comunidad
El nivel se determina según la opinión de la mayoría de los estudiantes que han dejado reseñas en esta clase. La recomendación del profesor o de la profesora se muestra hasta que se recopilen al menos 5 reseñas de estudiantes.
9
Estudiantes
--
Proyecto
Acerca de esta clase
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
Proyecto de clase práctica
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
Valoración de la clase
¿Por qué unirse a Skillshare?
Mira las galardonadas Skillshare Originals
Cada clase tiene lecciones cortas y proyectos prácticos
Tu membresía apoya a los profesores de Skillshare
Aprende desde cualquier lugar
Ve clases sobre la marcha con la aplicación de Skillshare. Progresa en línea o descarga las clases para verlas en el avión, el metro o donde sea que aprendas mejor.
