Excel Review Materials


Listed here are recommendations for reference guides, tutorial texts, video and CD-ROM training materials, and Excel-information websites. They're intended for Fuqua MBA students looking for review and practice materials for Microsoft Excel.

Note: The links provided here may change, but were accurate as of Spring 2002.


Excel Tutorial & Reference Guides 

       Excel 2000

       Excel 2002

  • Excel 2002 Skill Builder
    Greg Harvey, Mind Over Media Skillbuilder eBooks. Downloadable beginner's guide to Excel 2002. Intended to be tiled on screen with an Excel program window. 232 pages

  • Excel 2002: The Complete Reference
    Ivens and Carlberg, Osborne, reference text.
    ISBN 0-07213-2450, paperback, 759 pages

  • Excel 2002 Formulas
    John Walkenbach, Wiley, formula reference.
    ISBN 0-76454-800-X, paperback, 825 pages, CD ROM
  • Special Edition Using Microsoft Excel 2002
    Blattner, Que, reference text.
    ISBN 0-78972-5118, paperback, 953 pages
  • Microsoft Excel Version 2002 Inside Out
    Dodge, Microsoft Press, reference text.
    ISBN 0-7356-1281-1, paperback, 1104 pages, CD ROM
  • Microsoft Excel 2002 Step by Step
    Frye, Microsoft Press, beg/int tutorial guide.
    ISBN 0-7356-1296-X, paperback, 352 pages, CD ROM
  • Microsoft Excel X/2002: Illustrated Complete
    Cram, Course Technology, beg/int tutorial guide.
    ISBN 0-61904-5051, paperback

  • Microsoft Excel X/2002: Comprehensive
    Ageloff, Course Technology, intensive tutorial guide
    ISBN 0-61902-092-X, paperback, 808 pages
    This text offers a case-based, problem-solving approach especially recommended for a good MBA pre-program review. It's not necessary to go through the entire book. Instead, we recommend you focus on the discussions and complete the primary exercises from the following list of sections. The data files used in the exercises may be downloaded from the publisher's website. See the textbook for complete instructions.
        Tutorial 1: Using Excel to Manage Financial Data
        Tutorial 2: Working with Formulas and Functions
        Tutorial 3: Developing a Professional-Looking Worksheet
        Tutorial 4: Working with Charts
        Tutorial 6: Working with Multiple Worksheets and Workbooks
        Tutorial 7: Developing an Excel Application
        Tutorial 9: Data Tables and Scenario Management
        Tutorial 10:Using Solver for Complex Problems

       Recommended Video/CD-ROM Excel Courses

Excel Websites

Paula Ecklund
Duke's Fuqua School of Business
2002-2003