The amazing ONE formula Excel dashboard with LET function
30.3 هزار بار بازدید -
3 هفته پیش
-
One formula = Excel Dashboard
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 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/excel-school-p...
~
#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 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/excel-school-p...
~
#excel #dashboard
3 هفته پیش
در تاریخ 1403/04/05 منتشر شده
است.
30,338
بـار بازدید شده