Bonus – Making an Excel Dashboard with just ONE Formula (LET function)

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

Watch the lesson [1 Video, 34 minutes]

Author: Chandoo

My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions. I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here. I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.

2 thoughts on “Bonus – Making an Excel Dashboard with just ONE Formula (LET function)”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.