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.