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-course
✅ 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/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial
