Become an Excel PRO with this complete Dashboard Project πŸ“ˆ @chandoo_
Become an Excel PRO with this complete Dashboard Project πŸ“ˆ  @chandoo_
Uploaded September 2024 | Updated November 2026, 3 days ago
πŸ‘©β€πŸ’» Checkout my advanced Excel course at chandoo.org/wp/excel-school-program


πŸ“ Download files πŸ‘‰ chandoo.org/wp/free-call-centre-dashboard

In our final lesson of Excel module, we will be building a call centre performance dashboard as show-cased above. In this portfolio project, you will learn:

β–Ά Designing the dashboard color theme and fonts
β–Ά How to use Data model feature of Excel to connect datasets
β–Ά Creating KPIs and measures using Power Pivot and DAX
β–Ά Using Pivot tables to create all the dashboard calculations
β–Ά Making interactive Pivot Charts with slicers
β–Ά Applying conditional formatting to charts & tables
β–Ά Using XLOOKUP and images in Excel to show dynamic pictures

⏱ Video timestamps:
==================

0:00 - Demo of what we are going to build - call centre dashboard
1:35 - A closer look at the dataset and dashboard assets
2:57 - Set up dashboard color scheme and fonts
4:31 - Creating pivot tables
5:31 - Setting up the data model and relationships
7:29 - Calculating the DAX measures for various KPIs
12:47 - Making dashboard tiles
20:48 - Calls trend line graph
27:22 - Weekday trend bar graph
31:18 - Calls and amounts by rep (dynamic chart)
44:58 - Formatting slicers with styles
47:36 - Calls by customer demographics
50:19 - Rating distribution histogram
52:33 - Customer Revenue Analysis (table)
57:10 - Conditional formatting databars
58:51 - Highlighting selected "rep" in the table
1:01:34 - Adding the "picture" of selected rep
1:10:11 - Making dashboard title etc.
1:11:30 - How to learn more and become really good in Excel

πŸ“ Files:
=======

πŸ“ƒ Blank data file: chandoo.org/wp/wp-content/uploads/2024/09/sample-data-excel-portfolio-project.xlsx
πŸ“Š Completed workbook (+more): chandoo.org/wp/free-data-analyst-course
🎢 Full course playlist: youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
πŸ’» Full course webpage: chandoo.org/wp/free-data-analyst-course
πŸ‘©β€πŸ’» Advanced Excel course: chandoo.org/wp/excel-school-program

~

#Excel #Chandoo #fdac #freedataanalystcourse
Become an Excel PRO with this complete Dashboard Project πŸ“ˆYou dont need work email to use Power BI - Easy Fix 😎DONT tell my boss, but ChatGPT made this Excel dashboard 🀫How to Split Names in Excel Super Fast!Calculate Employee Tenure Easily with this Formula TrickπŸ’‘Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]Learn MS Access and Build your First Database TodayCompare Two Texts - Excel Formula HackFREE Adv. Masterclass on Power BI - Create a Sales Analytics Dashboard (with files πŸ“)Excel Drop Down Lists that Auto-Expand with Your Data - Easy Trick πŸ’‘Make a Gantt Chart in Excel with Just One Formula!Combine 2 Tables Quickly with this AMAZING Excel Formula
Chandoo |

Become an Excel PRO with this complete Dashboard Project πŸ“ˆ

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER