Duration:½ day
Standard:Advanced
Prerequisites:none

This session demonstrates the use of LET both in standard and array calculations to break down the complexity and to improve calculation performance through managing redundancy in references and calculations.  Ideally complexity is best handled by breaking a calculation down into multiple steps, but there are times where a multi-step calculation is desired for layout reasons, or because in some cases, redundancy in calculations can be sidestepped.

Approaches to building and testing LET calculations are demonstrated along with approaches to break them down to aid in auditing and understanding them.

Participants should be familiar with Excel and comfortable working with formulas and functions such as IF, INDEX, MATCH, LOOKUP or VLOOKUP or or XLOOKUP, and SUMPRODUCT.