5 Boring Excel Functions That Are Actually Brilliant
From MyOnlineTrainingHub · · 11 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
How to when use ABS, SIGN, REPT, TRUNC, and CELL functions in Excel. ⬇️ Download the example file here and follow along: https://bit.ly/bbbr26file 👩🏫 Learn more Excel functions and formulas with my course: https://bit.ly/bbbr26course
REPT Function Tutorial: https://youtu.be/7vM2Y5PboWI
These might be some of the least exciting function names in Excel.
They sound more like something from a maths textbook than tools you would use in a real spreadsheet.
But each one solves a surprisingly common problem, from fixing misleading percentage changes to making reports easier to read. Plus, they’re available in all versions of Excel.
I’ll show you all five with quick examples you can try in the free practice file.
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 ============== 0:00 Five function names that sound painfully boring 0:26 ABS function 2:48 SIGN function 4:30 REPT function 5:44 TRUNC function 8:18 CELL function 11:41 The modern functions changing how people work
#Excel #ExcelFunctions #ExcelFormulas