Premium Only Content
Why you SHOULD be USING Custom Number Formatting in Excel
23 May 2019 Excel Intermediate Functions & Features (For ALL Excel Versions)
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials
Learn the basics of Excel's custom number formatting and how you can use it for best impact in your reports in this Excel tutorial:
1. The custom formatting rule
2. Practical uses of Excel's custom number formatting
3. How to hide zero values in Excel
4. Custom formatting tricks
5. The proper way to add text to numbers so that values can still be used in formulas
If you have a choice between custom formatting or conditional formatting - always go with custom formatting. Processing times are faster with custom formatting. Conditional formatting is volatile.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-custom-number-formatting_1/
Many thanks to Michael for writing the detailed blog post and creating the Workbook so we can understand custom formatting better!
LINKS to related videos: Smart uses of custom formatting: https://youtu.be/tGY70sdpaLc
More tricks with custom formatting: https://www.xelplus.com/smart-uses-of-custom-formatting/
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
3:29:42
BrookieMonster
12 hours ago $36.91 earnedChristmas Stream: Marvel Rivals with CallmeSeags 🎄
123K29 -
LIVE
TheSaf3Hav3n
3 days ago| RUMBLES FIRST SUBATHON IS HERE!!! | DAY 4 |
993 watching -
3:14:33
Joe Donuts Gaming
14 hours ago🟢 Live : Christmas is Here!! | Fortnite, Caroling, Light Tours and Donos !!
59.3K13 -
6:02:38
CLUJ
13 hours agoCHRISTMAS EVENING HYPE!! LETS HAVE FUN GAMING!!
60.4K7 -
9:57:19
a12cat34dog
15 hours agoI AM FINALLY BACK :: PUBG: BATTLEGROUNDS :: RUMBLE NOW HAS GIFTED SUBS!!! [Merry Christmas] {18+}
36K7 -
3:55:42
STARM1X16
14 hours agoMerry Christmas Fortnite
115K11 -
2:45:33
Sgtfinesse
14 hours agoMerry Christmas Night
84.3K19 -
3:51:18
tacetmort3m
1 day ago🔴 LIVE - (MERRY CHRISTMAS) TIME TO SPREAD DEMOCRACY - HELLDIVERS 2 OMENS OF TYRANNY
49.9K2 -
2:46
BIG NEM
18 hours agoDiscovering RAKIJA: The Holy Liquer of the Balkans
36.3K3 -
1:11:38
Film Threat
22 hours agoCHRISTMAS DAY CHILL STREAM WITH CHRIS GORE | Hollywood on the Rocks
154K34