Coursera Plus Annual is 40% Off — Ends July 13.

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

YouTube

Creating and Troubleshooting Excel Formulas - From LAMBDA Functions to Error Resolution

Simon Sez IT via YouTube

Start learning Write review
Boot.dev Ad

Stuck in Tutorial Hell? Learn Backend Dev the Right Way

Learn More → Noble Desktop Ad

Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn to create custom Excel formulas and effectively troubleshoot common spreadsheet errors in this 77-minute video tutorial. Master the LAMBDA function to build personalized Excel functions during the first half of the training, then explore comprehensive error-fixing techniques including solutions for #DIV/0!, #NAME?, and circular references. Download provided course files to practice hands-on with real examples while developing formula-building skills and learning essential troubleshooting strategies. Perfect for Excel users seeking to enhance their formula creation abilities and maintain error-free spreadsheets for more accurate data analysis.

Syllabus

- Using LAMBDA to Create Your Own Excel Functions
- How to Fix Errors in Excel

Taught by

Simon Sez IT

Reviews

Start your review of Creating and Troubleshooting Excel Formulas - From LAMBDA Functions to Error Resolution

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.