Top 10 Excel Formatting Tips and Tricks

preview_player
Показать описание
Here are 10 super simple Excel formatting tips and tricks that can save you time when working with data in your spreadsheet.

Contents 0:00
1. Pos/Neg Numbers 0:17
2. Conditional Labeling 2:05
3. Center without Merging 2:51
4. Transpose 3:32
5. Special Formatting 4:06
6. Hide Zero Values 4:41
7. Format Painter 5:27
8. Clear Formatting 5:56
9. Color Formatting 6:30
10. Bullet Formatting 7:34

#seletraining #excel #tipsandtricks
Рекомендации по теме
Комментарии
Автор

I like how you can display text when a cell has a zero value, very cool!

HowToAnalyst
Автор

I really do appreciate you sharing your excel knowledge👍

kerisitiano
Автор

OK, #3 and especially #10 alone was worth the price of admission for me! I've wanted bullet points for ever! Thanks a lot!

rgarlinyc
Автор

Hi Jason. Great list of tips and tricks! And thanks for showing people how to use Center Across Selection vs. Merge & Center which almost always leads to problems on the worksheet. Thanks for sharing :)) Thumbs up!!

wayneedmondson
Автор

The last point is a lifesaver. thanks for the video

samuelnyiro
Автор

These are really helpful! Thanks Sele :)

TylerStanczak
Автор

New subscriber. Awesome tips. Thank you!!!

KathyaKalinine
Автор

A very useful video, thank you for sharing the tips and tricks!

manmanmanmm
Автор

I really need this video for Excel reference. I keep forgetting them when I don't use Excel for a while 😅
Thanks for the video.

TechTubeTVOfficial
Автор

Hi Jason, really useful and well presented! Thanks Andrea

globetrotter
Автор

Very informative vlog and by the way gr8 voice 👏🏼👍🏼

funnybones
Автор

Thank you for this great tutorial. I wanna add some good tricks as blow;
Hide Zero (#;)
Black bullet shortcut Alt+6+7+8 ...👍

teoxengineer
Автор

Very useful, thanks for sharing, could you please make another video to explain other useful characters like “@“ for making selections in custom formats, thanks.

FaisalKhan-pctk
Автор

Is there a way to keep the numbers like this 1, 000 ... i hate when excel make it 1000 ... especially with large numbers

LOOFE
Автор

the 2 people who disliked this video have anger issues lol

roywit
Автор

In last tip it is not possible to paste symbol in custom segment (ctrl+v)

tijanajovanovic