Modern Excel Formulas

Download the example files

Modern Excel Formulas Lessons Download the example files
Modern Excel Formulas

This lesson does not include a video.

Download the support files for the course.

The Modern Excel Formulas – Example Files.zip includes:

  • Modern Excel Formulas – Start – The start files to work along with examples in the videos.
  • Modern Excel Formulas – Complete – The completed files from the end of the course.

Make sure to unzip the files in an easy-to-find location.

Download files

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