I Bet You’ve Never Used These Excel Functions (But You Should)
From MyOnlineTrainingHub · · 15 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
11 weird Excel functions you've never heard of that solve real problems. ⬇️ Download the example file here and follow along: https://bit.ly/strange26file 👩🏫 Advanced Excel Formulas course: https://bit.ly/strange26course
Excel has over 500 functions, and some of the weirdest ones are surprisingly useful.
In this video, we explore 11 lesser-known formulas that solve unique spreadsheet challenges—from automated unit conversions and hidden formula comments to an unlisted date formula you won't find in Excel's function menu. For each formula, you'll learn what each argument means, real-world use cases, and key quirks to keep in mind.
LEARN MORE ===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS ============== 00:00 Hidden Excel functions you probably haven't seen 00:39 №1: Unit conversions without Google 02:35 №2: Reveal formulas and spot errors 03:52 №3: Find sneaky text pretending to be numbers 05:42 №4: Auto-document your workbook 08:36 №5: Hide notes directly inside formulas 09:40 №6: Roman numeral conversions 10:24 №7 & 8: Convert numbers into words 12:09 №9 & 10: In-sheet translation 12:34 №11: The hidden function Excel won't list 14:59 5 Excel functions every professional should know
#Excel #ExcelFunctions #ExcelFormulas