Welcome

Who this is for.

Goal

Acceptance Tests

Design

Why design? Why use pencil and paper?

Existing workbook

Print out samples of all pages.

Types of data

Input data, Constants/Parameters, Calculations and Output

Design of Input

Why design? Why use pencil and paper?

Design of Parameters

Why design? Why use pencil and paper?

Design of Calculations

Why design? Why use pencil and paper?

Design of Output

Why design? Why use pencil and paper?

Insert and rename sheets

Working at the worksheet level

Populate with Inputs

Use your initial work to create a 2-column worksheet of input cells

Populate with constants

Use your initial work to create a 2-column worksheet of constant and parameter cells.

Create calculations

Use your design (paper) to create formulas using the “point” method

Summarize results

Create formulas to extract the high points of your calculation.

Styles

Avoid local formatting; use Excel’s additive styles.

Range Names

Avoid cell references; use named ranges.

Functions

Be aware of the number of Excel’s built-in functions

Page layout

Headers and Footers, paper size, zooming.