Skip to Main Content
Excel Hacks
book

Excel Hacks

by David Hawley, Raina Hawley
March 2004
Beginner content levelBeginner
304 pages
7h 2m
English
O'Reilly Media, Inc.
Content preview from Excel Hacks

Chapter 1. Reducing Workbook and Worksheet Frustration

Hacks #1-15

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.

The 80/20 Rule

Perhaps the most important rule to follow when designing a spreadsheet is to take a long-term view and never assume you will not need to add more data or formulas to your spreadsheet because chances are good that you will. With that in mind, you should spend about 80% of your time planning your spreadsheet and about 20% 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 the planning gets easier after you’ve done it for a while. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Hacks, 2nd Edition

Excel Hacks, 2nd Edition

David Hawley, Raina Hawley
101 Ready-To-Use Excel Macros

101 Ready-To-Use Excel Macros

Michael Alexander, John Walkenbach
Excel Annoyances

Excel Annoyances

Curtis D. Frye

Publisher Resources

ISBN: 059600625XErrata Page