7 Clever Excel Custom Formatting Tricks (Advanced)

In this video, I cover some amazing Excel Custom Formatting tricks that you can use in your day to day work. Custom formatting allows you to show the cell content in a specific way, while at the same time, it doesn't change the value in the cell. It only changes the way a value is being displayed in the cell. ** Download file: https://bit.ly/38RuHC9 ------------------------------------------------------------------------------------------------------------------------------------------------- 00:00 Intro 00:12 Excel Custom Formatting Overview 01:06 Hide Cell Values in Excel 03:38 Hide Zeros (or replace 0's with text) 05:50 Conditional Custom Formatting (Show Text Based on Cell Value) 07:55 Showing Dates in different formats (Month name or Day name) 10:53 Show Negative Numbers in Red 13:19 Show numbers in Millions or Billions 15:59 Automatically Add Checkmark or Bullets before Text ------------------------------------------------------------------------------------------------------------------------------------------------- ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c... ✅ Free VBA course - https://bit.ly/excel-vba-course ✅ Free Power Query Course - https://bit.ly/power-query-course ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... #Excel #ExcelTips #ExcelTutorial