Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Why you SHOULD be USING Custom Number Formatting in Excel. That video is uploaded by Leila Gharani at 2019-05-23T02:25:44-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [68Tet_8BNB8]
| Name | Why you SHOULD be USING Custom Number Formatting in Excel |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 23-05-2019 09:25:44 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 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 ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/custom-number-tips-file 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. 📊 Key Learning Points: - Thousand Separator & Zero Decimals: Learn to format numbers with thousands separators and control decimal points. - Blending Zero Values: Discover how to hide zero values without deleting them, maintaining your data's integrity. - Custom Formatting Rules: Understand the four-part rule of custom formatting for positive, negative, zero, and text values. - Placeholder Differences: Differentiate between the pound sign and zero as placeholders and their impact on data display. - Innovative Text Formatting: Incorporate custom text into numerical data without altering the underlying values, perfect for reports and summaries. 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://www.xelplus.com/courses/ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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! #excel 68Tet_8BNB8 |
| Category | Education |
| Tags | how custom formatting works | custom formatting basics | what is # and 0 in custom format | custom formatting syntax | hide 0 | excel custom formatting | add text to number in excel | hide zero in excel | add text to number format excel | XelplusVis | custom number format | Excel Tutorials | Leila Gharani | Excel 2016 | excel best practice | Excel 2013 | Excel 2010 | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts |
