Skip to main content

Posts

Showing posts from March, 2012

Spreadsheet Tips (2): How to Structure Your Spreadsheet?

As I have mentioned in my previous article about spreadsheet tips (" Spreadsheet Tips (1): More Flexible MOP Template "), you don't need to be an Excel expert or having a blackbelt in VBA in using the tips I have shared. In fact, the more "sophisticated" your spreadsheet is, the higher possibility your spreadsheet will drive your life into misery. In this article, I will share some simple rules in formatting your spreadsheet and structuring your spreadsheets. Oops, am I refraining you from becoming Picasso or Van Gogh in your office? Tip (1): Apply Standard Rules of Formatting One of the best ways to make your spreadsheets more efficient is to apply standard formatting rules when you setup a spreadsheet template. Why? By having standard formatting rules, you don't need to spend time to figure out which colors / border style / font face & size will make your spreadsheet nicer. Also, you don't need to have headache anymore when you need to combine