SIGN UP to view the video

Course Description

Get up to speed on the LET and LAMBDA functions in Microsoft 365. In this CPE course Excel expert David H. Ringstrom, CPA sets the stage by explaining the concept of using range names in any version of Excel. Range names simplify formula writing and create navigation aids. The LET function lets you create nicknames, similar to range names, within formulas. These nicknames can stand in for inputs, or even calculations, so that you don't have to repeat portions of a formula. Conversely, the LAMBDA function enables you to create custom worksheet functions in Excel without having to write any code. LAMBDA functions can be transferred between workbooks in Excel.

David demonstrates every technique at least twice in this excel CPE course: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

In this online Excel CPE program following major topics are covered:

Create your own custom worksheet functions without writing any code in Microsoft 365 with the LAMBDA function.
Documenting IF functions by using LET to assign nicknames to the inputs.
Exploring the risks and benefits of participating in the free Microsoft Office Insider program.
Incorporating decisions into calculations with Excel's IF function.
Navigating directly to inputs by using Excel's Name Box, and then returning to the previous location in the workbook via the Go To command.
Streamline formula writing with by creating nicknames for repetitive values with the LET function in Microsoft 365.
Transforming cell references into range names by way of the Apply Range Names to Formulas command.
Using range names to streamline formulas and bookmark key inputs within a workbook.

Key Takeaways

To define the arguments used in the LET function.
To Recall the steps necessary to create range names in Excel.
To State how to use the LAMBDA function to create custom worksheet functions
To Create bookmarks and nicknames for key inputs by way of the Create Names from Selection feature.

Suitable For

CPA - Mid Size Firm
CPA (Industry)
Young CPA
CPA in Business
Entrepreneurial CPA

Qualifies For

1 CPE credit of Computer Software & Applications for all CPAs

FAQ

Excel Accountant Courses are online.
The self-study webinar format allows you to access the material online 24/7 and study at your own pace.
As per NASBA guidelines, you have one year from date of registration to complete each program.
Complete your final exam at any time and get CPE Credit instantly. You can retake the exam multiple times without any additional charges.
Course have minimum passing score of 70% and test takers will not be provided feedback on failed exams.

Refund/Cancellation Policy

For more information regarding refund, complaint and program cancellation policies, please contact our offices at 646-688-5128

In case any of the course or live webinars gets cancelled we would be refunding you the entire amount (if paid).

NASBA Approved MY-CPE LLC, 1600 Highway 6 South, Suite 250, Sugar Land, TX, 77478

Excel Accountant division of MY-CPE LLC (Sponsor Id#: 143597) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.

David Ringstrom, CPAChartered Professional Accoutants

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach around 175 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and m

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach around 175 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more. I am the lead author for the Idiot's Guide; Introductory Accounting book.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

ore. I am the lead author for the Idiot's Guide; Introductory Accounting book.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

4.4

Average Rating

43%

57%

Michael Suthers Oct 26th, 2023

Easy to follow

Glen Sanatar Nov 26th, 2022

Nice

Jaxton Lindsey PFS Jun 15th, 2022

A few weeks ago, I was tasked with creating a function for a small business. I had to write the whole code manually in Excel until I found this course. It was so easy to use and made it possible for me to create new custom worksheet functions now!

Addison Davis Jun 9th, 2023

Webinar was fine when explaining how the formulas work. After all, that is what this entire webinar was about. More than half of the video was talking about compatibility issues and updates. This is basic knowledge that should have been explained very briefly.

Neil Smith Dec 29th, 2022

Looking forward to using in 365

SIGN UP to view the video

Course Description

Key Takeaways

Suitable For

Qualifies For

FAQ

Refund/Cancellation Policy

NASBA Approved MY-CPE LLC, 1600 Highway 6 South, Suite 250, Sugar Land, TX, 77478

David Ringstrom, CPAChartered Professional Accoutants

Comments

4.4

Michael Suthers Oct 26th, 2023

Glen Sanatar Nov 26th, 2022

Jaxton Lindsey PFS Jun 15th, 2022

Addison Davis Jun 9th, 2023

Neil Smith Dec 29th, 2022

Details

Popular Category

Excel Courses

Building Resilient Budget Spreadsheets

Minimizing Errors within Excel Spreadsheets

Automating Excel-based Financial Statements

Introduction to Excel Macros Part 1

Introduction to Excel Macros Part 2

Introduction to Pivot Tables in Excel

LET & LAMBDA Functions

SIGN UP to view the video

Course Description

Key Takeaways

Suitable For

Qualifies For

FAQ

Refund/Cancellation Policy

NASBA Approved MY-CPE LLC, 1600 Highway 6 South, Suite 250, Sugar Land, TX, 77478

David Ringstrom, CPAChartered Professional Accoutants

Comments

4.4

Michael Suthers Oct 26th, 2023

Glen Sanatar Nov 26th, 2022

Jaxton Lindsey PFS Jun 15th, 2022

Addison Davis Jun 9th, 2023

Neil Smith Dec 29th, 2022

Details

Popular Category

Excel Courses

Building Resilient Budget Spreadsheets

Minimizing Errors within Excel Spreadsheets

Automating Excel-based Financial Statements

Introduction to Excel Macros Part 1

Introduction to Excel Macros Part 2

Introduction to Pivot Tables in Excel

Connect with Us