John Walkenbach's Favorite Excel Tips and Tricks

John Walkenbach is a leading authority on spreadsheet software, and principal of J-Walk and Associates Inc., an Arizona-based consulting firm that specializes in spreadsheet application development. John is the author of about 40 spreadsheet books, and has written more than 300 articles and reviews for a variety of publications, including PC World, InfoWorld, PC Magazine, Windows, and PC/Computing. He also maintains a popular Internet Web site (The Spreadsheet Page, www.j-walk.com/ss), and is the developer of the Power Utility Pak, an award-winning add-in for Microsoft Excel. John graduated from the University of Missouri, and earned a Masters and PhD from the University of Montana.

Introduction. Part I: Basic Excel Usage. Part II: Data Entry. Part III: Formatting. Part IV: Basic Formulas and Functions. Part V: Useful Formula Examples. Part VI: Charts and Graphics. Part VII: Data Analysis and Lists. Part VIII: Working with Files. Part IX: Printing. Part X: Customizing Toolbars and Menus. Part XI: Spotting, Fixing, and Preventing Errors. Part XII: Basic VBA and Macros. Part XIII: Conversions and Mathematical Calculations. Part XIV: Sources for Excel Information. Index.