Building Business Spreadsheets using Excel

By Byron W Cheever

Book Overview

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"