↖ Excel Off The Grid Customer support

MODERN EXCEL FORMULAS

#3 Arrays & array functions

← Previous lesson     |     Next lesson →

Work along with the course: Download example files  

 

Lessons:

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