14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN)
What makes an Excel spreadsheet look good is all a matter of opinion, right? Well, I’m not so sure.
I think there are certain things you can do to any Excel spreadsheet to make it look better.
In this video, I share 14 Excel formatting tips and techniques that you can start using now to create beauty in Excel. It’s a follow-up to our popular ‘Make Excel Beautiful’ video.
🔥FREE EXCEL DATA ANALYSIS CRASH COURSE
https://tinyurl.com/2p9f8w9e
💼FILE DOWNLOAD LINK
https://tinyurl.com/nhdbfj78
14 MORE EXCEL FORMATTING TIPS
00:00 Make Excel Beautiful?
00:20 Excel Data Analysis Minicourse
01:00 Classy indentation
01:30 Format formulae differently
02:00 Protect formulae(?)
03:32 Format dropdowns differently (Input Message)
05:00 All upper case for header (and column groupings)
Merging cells can be dangerous!
07:24 Keep zoom level consistent (custom navigation?)
08:15 Try on different monitor / screen resolution
09:00 Consider conditional formatting (but manage it carefully!)
10:26 Reduce no. zeroes (#,##0.0,)
12:14 Symbols (eg. $) needed in cells?
12:38 Force Excel to show decimal places (?)
13:34 Build up a format store (copy formats from here)
14:40 Control sheet tab colours
📺1st VIDEO IN THE SERIES
• 14 Excel Formatting Tips (Make Excel ...
🔥FREE EXCEL DATA ANALYSIS CRASH COURSE
https://tinyurl.com/2p9f8w9e
Watch video 14 MORE Excel Formatting Tips (Make Excel Beautiful AGAIN) online without registration, duration hours minute second in high quality. This video was added by user Tiger Spreadsheet Solutions 12 January 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 19,591 once and liked it 206 people.