Modern Excel Formulas

Wrap up

Modern Excel Formulas Lessons Wrap up

Summary

Congratulations, you’ve completed the course.

We’ve looked at the concepts of:

  • Lifting
  • Pairwise lifting
  • Broardcasting
  • Boolean logic
  • Variables

These features are the foundation for all calculations within Excel.

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