Say Goodbye to Ugly Excel Numbers with These Tricks (FREE Cheatsheet)
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
Make Excel numbers look professional in seconds with 10 custom number format codes. š©āš« Become an Excel Expert with my course: https://bit.ly/formats26course ā¬ļø Download the example file here and follow along: https://bit.ly/formats26file
Most people think Excel formatting is just commas, decimals and dates. But custom number formats can make numbers behave visually in ways most Excel users never realize are possible.
They can turn numbers into text without a formula, add arrows and colors without conditional formatting, hide values without deleting them, fill cells with dots or lines automatically, and show units without converting numbers to text.
The best part is, underneath, the values are still numbers, so your formulas, PivotTables and charts keep working.
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 The Excel formatting tricks most people never find 0:37 Turn thousands and millions into clean, readable numbers 3:09 Color-code values without conditional formatting 5:20 Display text instead of the actual value 6:39 Make cluttering zeros disappear (without deleting them) 7:24 Add up and down arrows to your variances 10:07 Format phone numbers so Excel stops breaking them 11:02 Bend dates into any format you need 12:28 Add units like kg or km without breaking your numbers 13:13 Hide numbers in plain sight for meetings 14:00 Auto-fill cells with lines and dots for forms 15:11 7 everyday Excel tricks to work twice as fast
#Excel #ExcelTutorial #ExcelTricks