In this bonus dashboard tutorial, learn how to create an interactive and dynamic Excel dashboard with just one formula. We are going to get creative with the new LET function in Excel 365.

PS: This is originally published on my YouTube channel, but you can watch it here and download for free, as a member of Excel School + Dashboards program.
Lesson topics & concept coverage
This lesson demonstrates the potential and power of new Excel 365 functions. We are going to use below functions and features to build the dashboard
- 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
Hi there,
Unable to find the video or link !?
You will find this lesson inside MDAC lesson plan. Use that. Not this page.