• Skip to main content
  • Skip to secondary navigation

Mastering Excel

The best place to learn Excel

  • Contact Me
  • Mastering Excel
  • Mastering Excel Macros
  • Infographic
  • All Books

Mark Moore

LET, LAMBDAs and Dynamic Arrays

by

Hi there,

Welcome to another lesson in the Mastering Excel series. This one is a little different in that it does not focus on only one formula. The power of LET, LAMBDAS and many other formulas is how they interact with each other. This lesson covers LET, LAMBDAS and several other helper functions. Each helper function is useful in its own right but here we explore how combining them gives us a lot more power. We can now do things that the ‘old’ Excel could never do.

Follow Along Workbooks

If you already have the book and you are looking for the follow along workbooks. Input your information below and I will send it to you in a few minutes. I won’t spam you. I send email tips and tricks every few weeks and I let you know when a new lesson is published. That’s all.

If you don’t see the sign up form below, try disabling any ad blockers. I promise you the form is there.

Filed Under: Uncategorized

iPhone

by

The lighter side of Excel…

Filed Under: Jokes

You’re on your way

by

Filed Under: Uncategorized

Infographic – Sum Across Sheets

by

Filed Under: Infographic

Infographic – VeryHidden

by

Filed Under: Infographic

Mastering Excel Dynamic Arrays

by

Please go to the new and improved sign up page to get your follow along workbookshttps://markmoorebooks.com/book/mastering-excel-dynamic-arrays/

Filed Under: Uncategorized

  • Page 1
  • Page 2
  • Page 3
  • Interim pages omitted …
  • Page 12
  • Go to Next Page »