This Excel book section will be expanded and re-ordered based on your feedback and reviews of your favorite Excel books. Do you have a favorite page-worn treasure to recommend? Please add it at the bottom of this page.
Excel 2003 BibleWhether you’re just discovering Excel or are already a power user, there’s no better instructor than "Mr. Spreadsheet," John Walkenbach. From basic formulas, functions, and chart creation to data analysis, custom number formats, data validation, and Excel programming with VBA, this is the comprehensive resource for Excel 2003. No matter what your level of expertise, you’ll benefit from hundreds of examples, exercises, tips, techniques, and workarounds, all served with a generous helping of the master’s expert advice.The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" featuresThe definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and moreCovers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting informationExplores Excel programming for those who want advanced informationCD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach''s Power Utility Pak - Amazon book review
Excel HacksYou don''t need to know everything that Excel can do in order to use it effectively, but if you''re like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things-from data analysis to worksheet management to import/export-that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way. -Amazon book review
Microsoft Excel 2003 Step by StepThis practical, hands-on tutorial expertly builds your skills with Microsoft Office Excel 2003—one step at a time! With STEP BY STEP, you work at your own pace through easy-to-follow lessons and practice exercises to learn exactly the tools and techniques you need. Master the tools for organizing, processing and presenting data; make data come alive with Microsoft PivotTable® and PivotChart® dynamic views; use data analysis tools for better decision making; tap external data sources; add hyperlinks; create macros; and help keep data secure as you share—and collaborate on—Excel documents over the Web. The book also helps you prepare for the Microsoft Office Specialist exam and makes a great on-the-job desk reference. The companion CD includes practice files you can use as you learn, as well as the Microsoft Office System Reference pack, which contains templates and clip art, an eBook of Step by Step, and four other eBooks: the Microsoft Office System Quick Reference; the Insider’s Guide to Microsoft Office OneNote 2003; the Microsoft Computer Dictionary, Fifth Edition; and Introducing the Tablet PC. Designed for beginning and intermediate level users, STEP BY STEP puts you in charge of developing the skills you need, exactly when you need them! -Amazon book review
Microsoft Excel 2002 FormulasExcel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, this one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-so-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets — and make the most of Excel. Your Road Map to High-Performance Excel Formulas - Back Cover Copy
Excel 2002 for DummiesFriendly guide to using Excel 2002 spreadsheet software, offering tips on the new fill and formatting features, as well as Excel classics like using formulas and functions, creating worksheets and entering data, and working with charts, databases, and hyperlinks. Includes navigational aids, top ten lists, and tear-out cheat sheets. Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you''ll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel.- Amazon Book Review
Mr Excel on ExcelDesigned for accounting and other business professionals, this guide to Microsoft Excel provides information on this feature-rich product that will make users more proficient. Described in detail are the techniques that were introduced since the switch from Lotus to Excel took place in the 1990s. Tips designed to make Excel use more efficient include how to prevent duplicate data entry, deleting unwanted links, importing and refreshing data from the Internet, and adding a running balance column to a pivot table. Other advanced techniques include combining the Vlookup function with a combo box to extract data, comparing lists without using formulas, and adding comments to formulas. Also included are instructions on features such as formulas that calculate loan payments, writing a program, and VBA techniques. -Amazon book review
Holy Macro! It''s 1,600 Excel VBA ExamplesThis CD-ROM contains every snippet of Excel VBA code you will ever need. Each example includes a question, answer, the VBA code and a sample Excel workbook demonstrating the code. Completely searchable, this reference is a must for anyone who needs to write Excel macros. -Amazon book review
Do you have a favorite or indispensable Excel Book to recommend or review? Please add your review or suggestions below.