↖ Excel Off The Grid Customer support

Modern Excel Formulas Crash Course

#1 Welcome & introduction

← 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 Advanced example & next steps
  15. #15 Wrap up
  16. #16 Completion certificate

Tips for success:

  1. For this free course the vidoes do not automatically proceeds to the next lesson.
  2. Work along with the videos, as this will help to embed the knowledge.
  3. If lessons are too fast, you can pause the video or reduce the speed to 0.75x or 0.5x.
  4. Can't watch with the sound on? Don't worry. Each video includes English Closed Captions.
  5. Experiencing issues with videos not playing (usually with the Firefox browser)? Try a different browser.

MAKE WORKING LATE A THING OF THE PAST

JOIN EXCEL OFF THE GRID TODAY

EXCEL ACADEMY INCLUDES:

Courses: On-demand training courses to give you the Excel skills you need to succeed.

Tools: Tools and templates so you can start automating Excel faster any other training program.

Community: Get your questions answered on the live Q&A calls and learn from others. 

Events and resources: Live masterclasses and access to ebook library.

LEARN MORE ➜

Monthly Plan

(Cancel Any Time)

$49 per month.

BUY NOW ➜

Annual Plan

(Best Value)

$490 per year

Special Offer $390 per year

For Power Query 5x5 Quick Start
participants only.

SPECIAL OFFER - BUY NOW ➜