7 Clever Excel Custom Formatting Tricks (Advanced)

TrumpExcel
TrumpExcel
223.2 هزار بار بازدید - 4 سال پیش - In this video, I cover
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
4 سال پیش در تاریخ 1399/10/30 منتشر شده است.
223,284 بـار بازدید شده
... بیشتر