Building Business Spreadsheets using Excel [Paperback]

Kathleen Adkins (Author), Jacque Auger (Author), Alastair Matchett (Author)

Book Description

Publication Date: May 5, 1998 | ISBN-10: 189111252X | ISBN-13: 978-1891112522 | Edition: 1

How to build business spreadsheets like a pro.

Problem-based learning builds skills through real-life problems.

Learn Excel's best features for working accurately and efficiently.

Tips and checklists help:

Check work for accuracy and integrity
Find and solve common errors
Give spreadsheets a professional look
Solve printing problems
Structure spreadsheets to answer business's common "what-if" questions

CONTENTS

Part 1: Learn Excel From the Ground UP

Understand Excel's screen and how to use it most efficiently.

Use Excel's fastest and most accurate procedures to:

Enter, edit and copy data
Create and copy formulas
Format and print spreadsheets

Part 2: Build Business Spreadsheets

A problem-solving approach based on realistic business situations:

Calculation of percentages, markups, discounts, and prices
Financial Calculations: Present and Future value, Net Present Value, Internal Rate of Return
Budget Forecasting
Projections of Financial Statements
Cash Flow Statement Construction
Includes the most-used business formulas and functions:

Growth Formulas
Percentage Derivation
SUM, AVERAGE, IF, MAS
FV, PV, IRR, NPV
Lists of checking protocols, Excel tips, and productivity enhancements.

Editorial Reviews

About the Author

Kathleen Adkins' seminars on power modeling are in demand at major investment banks in New York and London. She has taught modeling skills to thousands of financial analysts, associates, traders and financial managers on both sides of the Atlantic. Before founding her own training firm in 1984, she directed management training for a Fortune 1000 company. She has been active in computer based training since its inception.

Product Details

• Paperback: 233 pages
• Publisher: Adkins & Matchett Ltd; 1 edition (May 5, 1998)
• Language: English
• ISBN-10: 189111252X
• ISBN-13: 978-1891112522
• Product Dimensions: 7.8 x 5.1 x 1 inches
• Shipping Weight: 1 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #3,780,108 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

32 of 34 people found the following review helpful:

5.0 out of 5 stars Excellent guide for increasing productivity/speed/accuracy, March 30, 2000

By A Customer

This review is from: Building Business Spreadsheets using Excel (Paperback)

Adkins' book is packed with little-known shortcuts and tips on Excel functionality. The author doesn't waste time reviewing the more obvious points of the program, but gets right down to it with all the do's and dont's of creating a financial model.

The book is easy to read & well-organized, so it's more like a reference guide than a textbook...the appendices at the back are great for quick reference--I've been an analyst for two years and STILL use it. (there are also little exercises throughout for those who need more help).

If you want to be a success as an analyst, you should definitely check this one out--I can't tell you how critical these shortcuts have been at crunchtime. Knowing how to get around a spreadsheet really, really fast makes a difference when you are still at the office at 11 pm (or later). Definitely worth the investment.

5 of 6 people found the following review helpful:

2.0 out of 5 stars A bit too basic, August 8, 2002

By A Customer

This review is from: Build Business Spreadsheets Using Excel (Paperback)

Basically, an introduction to Excel with a some real life examples at the end - examples the likes of which you'd get in just about any basic Excel course/book

2 of 3 people found the following review helpful:

5.0 out of 5 stars Great book, however needs update for Office 2007, May 20, 2006

By 

California reader - See all my reviews

This review is from: Building Business Spreadsheets using Excel (Paperback)

This is the best introduction to Excel spreadsheets I have ever seen (out of several I own). If you want to learn how to create professional financial spreadsheets easily, get this book. It covers function keys and typing short-cuts in Excel not easily found elsewhere. The book's only shortcoming is that it does not explain how to create charts or graphics. Nevertheless highly recommended. Postcript Feb 2010: Unfortunately the advent of Excel 2007 made the hot key/short-cut advice in this book obsolete. Microsoft angered a lot of Excel users with their 'ribbon' change to the new Excel. The book needs to be updated to cover Microsoft Office 2007.