YoVDO

How to Use LAMBDA: Create New Formulas in Excel

Offered By: Simon Sez IT via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Microsoft Office 365 Courses Spreadsheets Courses Lambda Functions Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Introduction to Office 365 Development and APIs
Microsoft via edX
Office 365: Managing Identities and Services with Hands-on Labs
Microsoft via edX
Compliance in Office 365: eDiscovery
Microsoft via edX
Compliance in Office 365: Data Governance
Microsoft via edX
Microsoft Exchange Server 2016 - 5: Hybrid Topologies with Office 365
Microsoft via edX