• 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

Genesis-Posts

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

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

Mastering Excel: PowerApps

by

Most of the PowerApps data is built in the lesson but if you want the same sample data you saw in the ContactList exercise, you can download the workbook by clicking this link: https://markmoorebooks.com/downloads/

If you have no idea what this page is about or how you got here, the sample workbook is for the Excel lesson Mastering Excel: Power Apps. You can see it here on Amazon:

Mastering Excel: Power Apps

Filed Under: Uncategorized

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