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

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.