Skip to main content
AmigoFish

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.

Watch on YouTube

Not rated yet

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

Back to MyOnlineTrainingHub · Report a problem