Curriculum Tag: Free

Feedback Your feedback plays a direct role in shaping the academy. By telling us what worked and what could be improved, you help us make future resources more valuable for the whole community.

This lesson does not include a video. Download the support files for the course. The Modern Excel Formulas – Example Files.zip includes: Make sure to unzip the files in an easy-to-find location. Download files

Summary Congratulations, you’ve completed the course. We’ve looked at the concepts of: These features are the foundation for all calculations within Excel.

Summary This video looks at one final example using XLOOKUP to show how to apply the techniques from the course. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Lookup example

Summary This video shows how to combine broadcasting and lifting within the LET function to create a complex single cell formula. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Summary In this video we look at the LET function for creating variables. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example The LET function assigns calculation results to names that can be reused within a formula. The Syntax for LET is: Names must start with a letter, or an underscore, and cannot conflict with other … Read more

Summary This video applies boolean logic into the example project. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Summary This video looks at how Boolean logic can be applied within Excel. The term boolean logic means it uses true/false values with the calculation. TRUE or FALSE are automatically converted to 1 or 0 when used in an arithmetic calculation. Combining TRUE/FALSE and multiplication in a calculation simulates IF logic for numerical values. Any … Read more

Summary This video applies Pairwise Lifting in the example project. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example

Summary In this video, we look at Pairwise Lifting which expands on the lifting concept presented earlier. EXAMPLE FILE: Modern Excel Formulas – Start.xlsx > Example Pairwise lifting occurs when multiple scalar arguments are provided with multiple values in a range or array. Calculation occurs based on the relative position of the values. Function arguments calculate … Read more