Building Business Spreadsheets using Excel - Softcover

Adkins, Kathleen; Auger, Jacque; Matchett, Alastair

 
9781891112522: Building Business Spreadsheets using Excel

Synopsis

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9781891112553: Build Business Spreadsheets Using Excel

Featured Edition

ISBN 10:  1891112554 ISBN 13:  9781891112553
Publisher: Adkins & Matchett, 2000
Softcover