Unlock Excel's Hidden Features: Spills, Arrays, and Named Ranges

Welcome to another Excel tips and tricks tutorial video! We combined ten of our best Excel tutorials into one step-by-step Microsoft Excel training video for beginners. These Excel tips and tricks are ideal for beginners, but also for intermediate Excel users.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 - Fix the Spill Errors
00:04:08 - Fix the Name Error
00:09:20 - Convert Formulas to Values
00:12:28 - Converting Text to Numbers
00:16:28 - Convert Numbers Stored as Text
00:18:59 - Creating Named Ranges
00:23:22 - Calculating SUBTOTAL
00:26:56 - Spills and Array
00:37:49 - Filter Function: OR Operator
00:44:41 - Filter Function: AND Operator

🌍 Get unlimited training with Simon Sez IT’s 160+ courses ⏩ https://www.simonsezit.com/courses/

🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ video ⏩ https://www.simonsezit.com/ssit-first...

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for Excel beginners 👉   • Microsoft Excel Beginner's Training T...  

✅ Excel 2021 Tutorials for Intermediate Users here 👉   • Excel 2021 Tutorials for Intermediate...  

✅ Microsoft Excel Tips and Tricks 👉   • Microsoft Excel Tips and Tricks  

✅ Microsoft Office 2021 and Office 365 Training here 👉   • Microsoft Office 2021 and Office 365 ...  

💬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simon-sez-it  
FaceBook:   / simonsezit  

🔔 Subscribe to our channel:
https://www.youtube.com/simonsezittra...

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)