Okebiz Video Search



Title:7 Clever Excel Custom Formatting Tricks (Advanced)
Duration:19:14
Viewed:50,124
Published:19-01-2021
Source:Youtube

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

SHARE TO YOUR FRIENDS


Download Server 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
10 Amazing (Less Known) Excel Tricks You Should Know 10 Amazing (Less Known) Excel Tricks You Should...
17:34 | 108,520
10 Super Neat Ways to Clean Data in Excel 10 Super Neat Ways to Clean Data in Excel
18:47 | 437,435
4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1 4 SMART Ways to use Custom Formatting instead o...
16:12 | 589,942
25 AWESOME Excel Keyboard Shortcuts (You Should Know)! 25 AWESOME Excel Keyboard Shortcuts (You Should...
17:36 | 58,341
Don't Use Excel Filters! Use This Incredible Excel Formula Instead ... Don't Use Excel Filters! Use This Incredible Ex...
09:32 | 195,224
5 Awesome Excel Keyboard and Mouse Tricks 5 Awesome Excel Keyboard and Mouse Tricks
08:25 | 19,681
10 Excel XLOOKUP Function Examples (Better than VLOOKUP & INDEX/MATCH) 10 Excel XLOOKUP Function Examples (Better than...
25:40 | 41,101
When Should you Use the Hash Sign (#) in Excel Formulas? When Should you Use the Hash Sign (#) in Excel ...
10:53 | 230,671


coinpayu