Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

EXCEL HACKS, TIPS AND TOOLS FOR STREAMLINING YOUR SPREADSHEETS

Excel Hack Examples (2ND Edition)

By D & R Hawley of OzGrid.com

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.   This book caters for users of Excel 2003 (and prior versions) and Excel 2007, so code examples in both versions of Excel are available.

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

Excel Hacks Workbook Download Examples

You're looking at the examples for the second edition of our Excel Hacks Book. For the examples from the first 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. With the growth of the Web over the last few years Microsoft has developed features that enable you to get your information into and out of your spreadsheets and into and out of other programs.



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Add to Google Search Tips FREE Excel Help

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft