Excel Help Recommended Reading

Starting Points -- These books include all of the basic skills that most users of Excel need to know and do it under 400 pages.


Excel 2000 For Windows® For Dummies® by Greg Harvey
If you are new to Excel and need to learn key facts about its features then this book is an excellent choice.  The no-nonsense approach provides the key facts without being wordy, covering the subject in fewer than 400 pages (compared to the typical Excel book's 1000+ pages).  It's a quick read that will give you an overall grasp of the subject.

Price It Now at  and or

Microsoft Excel 2000 : Step by Step by Catapult Inc.
This book is organized into lessons that are designed to be completed in eight hours of study. It's about the same length as the Dummies book above.  If you want to learn the basics and like the structure of a lesson-by-lesson approach, then this could be the best choice for you.

Price It Now at  and or 

 

The Best Programming Books -- These selections offer training tips for programming Excel using Visual Basic for Applications. 

Microsoft® Excel 2000 Power Programming with VBA by John Walkenbach
This is the book I recommend most often to people who are learning to program Excel with Visual Basic for Applications. You'll find instructions on building custom forms, automating charts, menus and toolbars.  The examples are thoughtfully crafted and the book contains practical coding tips. Buy this version if you are working in Excel 97 or 2000.

Price It Now at  and or

Microsoft® Excel 95 Power Programming with VBA  by John Walkenbach
This is the Excel 95 version of the book described directly above. If you are unable to upgrade to Excel 97 or 2000 -- there are significant programming improvements in  these more recent versions -- then this is the book to use.

Price It Now at  and or

 

We All Buy Those 1000+ Page References -- You may not read the whole thing, but an Excel reference like the ones below can be a worthwhile tool that provides valuable examples and instructions.

Special Edition Using Microsoft Excel 2000 by Patrick Blattner
The "Using" series by Que continues to provide a good source of step-by-step instruction and examples for all of Excel's non-programming features. Weighing in at over 1300 pages, this book's complete coverage of each topic makes it a comprehensive reference guide.

Price It Now at  and or

Running Microsoft Excel 2000 by Dodge and Stinson
Like the "Using" book above, this book is an exhaustive reference guide.   Published by Microsoft Press, it covers the elements on the non-programming side of Excel.

Price It Now at  and or

Microsoft® Excel 2000 Bible by John Walkenbach
This 1350 page reference, written by the author of some of the best advanced Excel books, covers all of Excel's non-programming features in depth. This is an excellent resource to use when you need to look up complete instructions on how to use an Excel feature.

Price It Now at  and or

 

Advanced Training on the Non-Programming Side of Excel

Excel 2000 Formulas by John Walkenbach
This book proves that you do not need to program with Visual Basic for Applications to be an Excel expert -- there is a wealth of  Excel formula techniques you can use without programming.  This book provides both basic and advanced instruction and works well for either Excel 2000 or Excel 97. Most of the book can also be used with Excel 95.

Price It Now at  and or

 

Advanced Books for Experienced Excel Users

Excel 2000 MOUS Study Guide by Courtner and Marquis
Microsoft Office User Specialist -- MOUS -- is a nationally-recognized level of certification that can be earned by the experienced Excel user.  This book covers all the topics on the MOUS exam in a brief, no-nonsense format.
More information on MOUS is available from Microsoft at www.mous.net .

Price It Now at  and or

MBA's Guide to Microsoft Excel 2000 : The Essential Excel Reference for Business Professionals by Stephen L. Nelson
This book is for experienced users of Excel who are looking for ideas on how maximze Excel's features in a business environment.  You will find sample workbooks for business planning, break-even analysis, forecasting sales, capital budgeting, amortization and depreciation. Also included are quick reviews of Excel basics and charting.

Price It Now at  and or

Financial Modeling by Simon Benninga
If you want to use Excel to perform complex financial modeling, this book, written by a Professor of Finance, provides pages of the relevant financial formulas and shows how these formulas can be implemented in Excel.  This advanced, applications-oriented book covers financial statement modeling, valuation, analysis of leasing, portfolio models, option pricing models and return on bonds.

Price It Now at  and or

 

       

Please request information by E-Mail to lacher@lacher.com

Consulting | Excel Examples

Last modified: September 16, 2010