Loading Events

Workbook Design

Location: Online Webinar (Zoom, WebEx, Google Meet, MS Teams)

Objective:

What defines a good spreadsheet (workbook)? Good spreadsheets have many common traits: They always works as intended, can be relied on and they can be used many times.  The session will get you started on the way to designing reliable spreadsheets and workbooks.

Agenda:

Three type of Spreadsheets

  1. Quick and dirty
  2. Well thought
  3. Hard to use and understand

Steps to Creating Spreadsheets:

  1. Action Plan
  2. Documentation
  3. Designing the layout
  4. Navigation
  5. Ranges and Data
  6. Formulas
  7. Testing