Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

How to Use LAMBDA: Create New Formulas in Excel

Simon Sez IT via YouTube

Start learning Write review
Coursera Ad

Google AI Professional Certificate - Learn AI Skills That Get You Hired

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn how to create custom functions in Excel using LAMBDA in this 36-minute tutorial. Explore the concept of variables, use LET in formulas, and create simple LAMBDA functions. Discover how to design your own reusable functions and apply them to practical examples. Master the process of sharing and copying LAMBDA functions to enhance your Excel workflow efficiency. Follow along with downloadable course files and navigate easily through different sections using provided timestamps.

Syllabus

- Course Introduction
- The Concept of Variables
- Use LET in Formulas
- A Simple LAMBDA
- Create Your Own Function
- Practical LAMBDA Example 1
- Reuse the Function
- Practical LAMBDA Example 2
- Sharing or Copying LAMBDA
- Conclusion

Taught by

Simon Sez IT

Reviews

Start your review of How to Use LAMBDA: Create New Formulas in Excel

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.