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

YouTube

Excel's Hidden Features - Spills, Arrays, and Named Ranges

Simon Sez IT via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Unihackers Ad

Launch Your Cybersecurity Career in 6 Months

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Discover advanced Excel techniques in this comprehensive tutorial video. Learn to fix spill and name errors, convert formulas to values, manipulate text and numbers, create named ranges, calculate subtotals, work with spills and arrays, and utilize filter functions with OR and AND operators. Master these essential skills to enhance your Excel proficiency and streamline your data analysis workflows.

Syllabus

- Fix the Spill Errors
- Fix the Name Error
- Convert Formulas to Values
- Converting Text to Numbers
- Convert Numbers Stored as Text
- Creating Named Ranges
- Calculating SUBTOTAL
- Spills and Array
- Filter Function: OR Operator
- Filter Function: AND Operator

Taught by

Simon Sez IT

Reviews

Start your review of Excel's Hidden Features - Spills, Arrays, and Named Ranges

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.