Building Business Spreadsheets using Excel

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.

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.