Spreadsheet modeling or scenario modeling is one of the common uses of Microsoft Excel. People, especially in financial sector use MS Excel to do a lot of modeling. While excel has such powerful features like goal seek and scenarios, it also has a very useful feature called “cell styles” that you can exploit to make your spreadsheet models more user friendly.
Here is a small screencast to get you started. Excel 2007 comes with some great styles to mark various types of cells in the model, viz, input, output, calculation, warning, explanation etc.
What is your experience with cell styles?
I think they are easy to use and add consistent (and professional) look to the workbooks. What do you think?
Browse more quick tips and learn something fun before you take a sip.