Most Excel users suspect they could be a whole lot more efficient: they could solve their problems more easily, take on more complicated tasks, save more time through automation. But who’s got time to learn how? John Walkenbach has made it easy. He’s bundled his 200 favorite Excel tips and tricks into one surprisingly simple guide.
It’s all bite-size: You’ll never have to wade through oceans of dense prose. And you’ll find something useful on nearly every page: about data entry, formatting, formulas, functions, charts, data analysis, printing, customization, error correction, and much more.
Want to copy dozens of formulas exactly, without manually changing relative references to absolute? Generate a series of dates that automatically updates when you change the first date? Format individual characters within a cell? Create a drop-down list within a cell, without VBA? Print non-continuous ranges on a single page? Convert miles to kilometers? Keep formulas from displaying errors such as #REF or $DIV/0!? Walkenbach shows how. You’ll find solutions to more complicated problems here, too: for example, parsing lists of names into columns for first, middle, and last name.
Wouldn’t it be nice if you could create a chart that automatically expands whenever you add new data points -- say, for new months, quarters, or years? Walkenbach walks you through the process: both in Excel 2003, where it’s pretty easy, and in older versions where it’s a bit more challenging. (By the way, this book’s designed for Excel versions from 2000 to 2003, but most of it’ll apply to Excel 97, too.)
Walkenbach has earned the nickname Mr. Spreadsheet for a reason: Practically nobody knows more about using spreadsheets. See for yourself. Bill Camarda, from the September 2005 Read Only