As large number of hacks in this book require working examples, we have included these in the hope that they will help owners of Excel Hacks save time by copying working examples directly into their own Excel Workbooks.
Should you have any question at all about anything in the book, please post your question to our Free Excel Forum in the Excel HELP category. You must first Register Here, only an email, username and password is required.
You may also wish to browse our list of Frequently Asked Questions on Excel. For many more free Excel Workbook Downloads, please go to Free Excel Downloads 1, Free Excel Downloads 2
You're looking at the examples for the first edition of our Excel Hacks Book. For the examples from the second edition click here
Chapter 1 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.
Chapter 2 Although Excel comes with a wide variety of standard features for managing and analyzing data, the boundaries of these features are often frustrating. The hacks in this chapter provide numerous ways in which you can escape these boundaries and make Excel a much more powerful tool.
Chapter 3 Probably the biggest advantage to using named ranges is that formulas become a lot easier to read and understand, not only to you but also to others who need to work with your spreadsheets. Using named ranges (easily one of Excel’s most useful features), you can reference a range of cells and give it a specific name. From that point on, you can reference the range via the name rather than its range address. Although named ranges are powerful, you can go beyond the standard range names in Excel in many ways. See Also: Dynamic Ranges
Chapter 4 PivotTables are one of Excel’s most powerful attractions, though many people don’t know what they do. PivotTables display and extract a variety of information from a table of data that resides within either Microsoft Excel or another compatible database type. PivotTables are frequently used to extract statistical information from raw data. You can drag around the different fields within a PivotTable to view its data from different perspectives. See also: Excel Pivot Tables
Chapter 5 Charts are one of Excel’s most popular features, giving spreadsheets visual power beyond mere calculations. Although Excel’s chart capabilities are impressive, many times you’ll want to go beyond the functionality provided by the software to create charts that are more responsive to changes in data, or you simply will want to go beyond the range of options Excel most obviously provides. The hacks in this chapter enable you to do all of this and more. See Also: Andy Pope Excel Information
Chapter 6 Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused. What’s more, the formula and function capabilities built into Excel might not always be what you want, further complicating the situation. Fortunately, there are a lot of ways you can keep your formulas and functions sane.
Chapter 7 Macros make it wonderfully easy to automate repetitive tasks in Excel, but the way they’re created and the facilities for using them are sometimes problematic. Fortunately, Excel is flexible enough that you can fix those problems and create new features with a minimum of effort.
Chapter 8 Excel has long had connections to other members of the Microsoft Office family, as well as to databases. With the growth of the Web, Excel developed HTML export capabilities as well, making it easy to publish information created in Excel. Over the last few years, however, Microsoft has developed features that enable you to use Excel as a frontend to information published anywhere, and to get your information out of Excel and into other forms—whatever forms you want, given whatever data you have. At the same time, a number of developers have created ways to get information into and out of Excel spreadsheets without using Excel, and these also have become important gateways.
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft