Can I Make an Entire Dashboard with One Formula?
One formula = Excel Dashboard 😎
That is right. In this video, let me share a revolutionary approach to creating Excel dashboards using just ONE formula.
💥 Full video + Excel file: Join my Excel School program to get the full video and unlocked Excel workbook. Go here 👉 https://chandoo.org/wp/excel-school-p...
~
Excel 365's LET function offers a powerful and elegant way to create dashboards and business reports with just a single formula. In this advanced tutorial, let me share the approach with a full-length example. Your mind will be blown for sure 🤯
The approach:
============
◉ Writing big formulas with Advanced Formula Editor in Excel
◉ Using XLOOKUP to combine data
◉ LET function to create variables for the report
◉ Summarizing totals by sales person using BYROW and LAMBDA
◉ Using IMAGE() to get the image of sales persons
◉ Adding in-cell graphs using REPT function
◉ Generating indicators for icons
◉ Applying dynamic sort order with SORTBY function
◉ Filtering out top x values using TAKE function
◉ Generating 13 week trends using array SUM functions
◉ Adding sparklines
📁 Sample file: https://chandoo.org/wp/wp-content/upl...
⏱ In this video:
=============
0:00 - The amazing one formula Excel dashboard with LET function
1:01 - The setup & approach
4:28 - How to download the full workbook 📁
5:25 - Calculating extra columns like with XLOOKUP
9:13 - Getting to the totals by Salesperson level
11:30 - Using BYROW and LAMBDA to generate the totals
15:09 - Revenue bar graphs (with CF)
17:05 - Revenue bar graphs with REPT
20:46 - Profit KPIs
23:07 - Dynamic thousands formatting with TEXT function
25:20 - Dynamic sorting with SORTBY
30:55 - 13-week trend with MAKEARRAY, CF and Sparklines
📺 MORE DASHBOARDS
====================
Make Excel dashboard with ChatGPT - • DON'T tell my boss, but ChatGPT made ...
Excel dashboard in 28 minutes - • How to make an Excel Dashboard in 5 E...
How to create an interactive and beautiful dashboard in Excel - • Excel Dashboard like you have never s...
Project management dashboard in Excel - • Make an awesome Project Management Da...
Full Excel Dashboards course - https://chandoo.org/wp/excel-school-p...
~
#excel #dashboard
Watch video Can I Make an Entire Dashboard with One Formula? online without registration, duration hours minute second in high quality. This video was added by user Chandoo 25 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 35,920 once and liked it 1 thousand people.