Become an Excel PRO with this complete Dashboard Project 📈

👩‍💻 Checkout my advanced Excel course at https://chandoo.org/wp/excel-school-p... 📁 Download files 👉 https://chandoo.org/wp/free-call-cent... 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: https://chandoo.org/wp/wp-content/upl... 📊 Completed workbook (+more): https://chandoo.org/wp/free-data-anal... 🎶 Full course playlist:    • FREE Data Analyst Course   💻 Full course webpage: https://chandoo.org/wp/free-data-anal... 👩‍💻 Advanced Excel course: https://chandoo.org/wp/excel-school-p... ~ #Excel #Chandoo #fdac #freedataanalystcourse