Can I Make an Entire Dashboard with One Formula? @chandoo_
Can I Make an Entire Dashboard with One Formula?  @chandoo_
Uploaded June 2024 | Updated November 2026, 11 hours ago
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 ๐Ÿ‘‰ chandoo.org/wp/excel-school-program

~

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: chandoo.org/wp/wp-content/uploads/2024/06/one-formula-dashboard-data.xlsx

โฑ 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 - youtu.be/mp18miYmmJY
Excel dashboard in 28 minutes - youtu.be/35VnP0Rz71I
How to create an interactive and beautiful dashboard in Excel - youtu.be/bG1Qha-Ii7A
Project management dashboard in Excel - youtu.be/FXnyKU6xZeI

Full Excel Dashboards course - chandoo.org/wp/excel-school-program

~

#excel #dashboard
Can I Make an Entire Dashboard with One Formula?Dynamic Moving Averages with *new* MAP FunctionHow to make an interactive TOP 10 Chart with Power BI (using parameters)ONLY Excel pros use this INDEX MATCH trick ๐Ÿ’กTOP 10 XL Functions #excelLearn For Loop in Python Properly (with sample code ๐Ÿ‘ฉโ€๐Ÿ’ป)Auto Format Excel numbers in thousands / millions / billions - 2 TRICKS๐Ÿ’กWhat is ETL with a clear example - Data Engineering ConceptsHow I made a COLOURFUL slicer in Power BI ๐ŸŽจHow to make the perfect CALENDAR TABLES ๐Ÿ“… in Power BICreate a HR Dashboard with Tableau - Full TutorialAutomatically Extract BOLD Text with VBA [Adv. Excel]
Chandoo |

Can I Make an Entire Dashboard with One Formula?

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER