Building Business Spreadsheets using Excel

By Kathleen Adkins

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. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 189111252X
• ISBN13: 9781891112522
• Release Date: May 1998
• Publisher: Adkins & Matchett Ltd
• Length: 233 Pages
• Weight: 1.55 lbs.
• Dimensions: 8.5" x 11.0"

Customer Reviews

Great book, however needs update for Office 2007

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...

Excellent guide for increasing productivity/speed/accuracy

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...