With that in mind, you should spend about 80 percent of your time planning your spreadsheet and about 20 percent implementing it.Although this can seem extremely inefficient in the short run, we can assure you that the long-term gain will far outweigh the short-term pain and that the planning gets easier after you've done it for a while.Remember that spread-sheets are about making it easy for users to get correct information, not just about presenting information that looks good only once.
Here are, in no particular order, some of the most common mistakes users make when setting up a spreadsheet: The first three items on the preceding list add up to one thing: you should always try to keep related data in one continuous table.Time and time again we see spreadsheets that do not follow this simple rule and thus are limited in their ability to take full advantage of some of Excel's most powerful features, including Pivot Tables, subtotals, and worksheet formulas.In such scenarios, you can use these features to their full potential only when you've laid out your data in a very basic table.Excel users know that workbooks are a powerful metaphor.But many users are equally aware that dealing with workbooks can cause a huge number of snags.
The hacks in this chapter will help you avoid some of these snags while taking advantage of some of the more effective but often overlooked ways in which you can control your workbooks.
Before we leap into the hacks, though, it's worth taking a quick look at some basics that will make it much easier to create effective hacks.
Excel is a very powerful spreadsheet application, and you can do incredible things with it.
Unfortunately , many people design their Excel spreadsheets with little foresight, making it difficult for them to reuse or update the spreadsheets they've so carefully built.
In this section, we provide several tips you can follow to ensure that you're creating spreadsheets that are as efficient as possible.
need to add more data or formulas to your spreadsheet because chances are good that you will.