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: 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 - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial