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/excelschoolp...

~

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 fulllength 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 incell 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/wpcontent/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 13week 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 Interactive & Beautifu...  
How to create an interactive and beautiful dashboard in Excel    • How to create a fully *INTERACTIVE* a...  
Project management dashboard in Excel    • Make an awesome Project Management Da...  

Full Excel Dashboards course https://chandoo.org/wp/excelschoolp...

~

#excel #dashboard