Скачать или смотреть Excel's LET function in 3 Acts

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


Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

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