This event has passed.
Workbook Design – OCTOBER26
October 26, 2020 @ 10:00 am - 12:00 pm
| $199.00Workbook 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
- Quick and dirty
- Well thought
- Hard to use and understand
Steps to Creating Spreadsheets:
- Action Plan
- Documentation
- Designing the layout
- Navigation
- Ranges and Data
- Formulas
- Testing