Modern Excel Formulas

Example (Part #5)

Modern Excel Formulas Lessons Example (Part #5)

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

Lessons

  1. Welcome & introduction
  2. Download the example files
  3. From ranges to arrays
  4. Arrays & array functions
  5. Lifting
  6. Example (Part #1)
  7. Broadcasting
  8. Example (Part #2)
  9. Pairwise lifting
  10. Example (Part #3)
  11. Boolean logic
  12. Example (Part #4)
  13. Variables (LET Function)
  14. Example (Part #5)
  15. Lookup example
  16. Wrap up
  17. Feedback