Excel’s LET function in 3 Acts

/in /by

One of Excel’s newest functions: LET()
Incredible! This function allows the Excel user to create complex formulas that are easier to create and easier to read. But they do require the user to think several steps ahead.

In this video I show 3 examples and make 2 cases in favor of using LET:
– Very basic
– Recycle. This is when we have to do a complex calculation and then do it again later in the formula.
– Clarity. Here, when a complex formula is needed, it’s easier to set up the variables first and then do the final calculation using only the variables. This can be easier to real in several distinct chunks rather than a massive jungle of parentheses or use of helper columns.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2