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 HERE
FILE DOWNLOAD LINK

CLICK HERE TO WATCH THE VIDEO


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


FREE EXCEL DATA ANALYSIS CRASH COURSE