Build Business Spreadsheets using Excel 2nd Ed.

Kathleen Adkins

Publisher: Adkins, Matchet and Toy, 2000, 233 pages

ISBN: 1-891112-55-4

Last modified: May 21, 2007, 2:39 a.m.

Contents

Part 1: The Basics

  • For people who are new to spreadsheets and Excel. Get started right with a step-by-step guide that shows you how to:
    • Enter, edit, and copy data
    • Create and copy formulas
    • Format and print spreadsheets

Part 2: Build Business Spreadsheets

  • A series of problems covering:
    • Percentages, markups, discounts, pricing, growth
    • Date math and financial math
    • Budget and financial statement projection
    • Models vs. calculations
  • The problems include:
    • Excel features that help solve the problem and how to use them
    • Problem analysis and assumption development
    • Integrity checking
    • Business presentation and formatting

Appendices

  • The best business shortcuts
  • Common business formulas and functions
  • In-depth guide to formatting and printing
  • Excel troubleshooter
  • Useful features and commands
  • Construction, proofing and checking techniques

Answers

  • Answer section shows correct spreadsheet construction as well as the right answers to each problem

Features

  • Shows you how to avoid the worst mistakes in business spreadsheet construction
  • Offers checklists and tips to help you find errors and check for spreadsheet integrity
  • Gives you valuable pointers on how to work efficiently and quickly
  • Helps you choose appropriate formats for your work
  • Shows you how to set up your spreadsheet for easier revision, editing, and troubleshooting
  • Explains the importance of "what-if" scenarios in business and how to build "what-if" flexibility into every spreadsheet

Design

  • Problem-based approach gives you practice in analyzing, building, and checking real-life spreadsheets
  • Periodic tests show you how you're doing
  • A workbook, not a list of features
  • Demonstrate Excel commands in appropriate contexts: shows you when to use them, not just how to use them
  • Learn by doing:
    • Introduction
  • Part 1. Foundation skills
    1. Orientation
    2. Enter, delete, edit data
      • Test 1
    3. Menu commands
      • Test 2
    4. Formulas
      • Test 3
    5. The COPY command
      • Test 4
    6. Moving things around
      • Test 5
    7. Presentation
    • Final test, part 1
  • Part 2: Problem sets
    1. General business problems
      • Set 1: Simple models
      • Set 2: Data analysis
      • Set 3: Date math
      • Set 4: Growth calculations
    2. Financial math problems
      • Set 5: PV and FV
      • Set 6: NPV and IRR
    3. Financial projections
      • Set 7: Secondary calculations and plug accounts
      • Set 8: Financial statement projection, single sheet
      • Set 9: Multiple sheets
      • Set 10: Financial statement projection, multiple sheets
  • Appendices
    • Appendix A: Efficiency
    • Appendix B: Common business formulas and functions
    • Appendix C: Excel troubleshooting
    • Appendix D: Guide to formatting
    • Appendix E: Other useful commands and features
    • Appendix F: Printing
    • Appendix G: The A-B-C-D of spreadsheet design
    • Appendix H: Standards and checking
  • Answers
    • Part 1
    • Part 2
      1. General business problems
      2. Financial math
      3. Financial projections

Reviews

Build Business Spreadsheets using Excel

Reviewed by Roland Buresund

Very Good ******** (8 out of 10)

Last modified: May 21, 2007, 2:54 a.m.

This is the book that you really need when studying to an MBA! Excellent tool for learning MS-Excel as well as all these pesky formulas and problem statements that you need all the time in Finance class. Recommended. Also part of Financial Business Box.

Comments

There are currently no comments

New Comment

required

required (not published)

optional

required