|
Understand the need for standards:
- Comparison of good and bad spreadsheets.
Discover the ESP add-in:
- Attach the add-in.
- Use the add-in.
Apply conventions to range names:
- See the benefits of range names.
- Navigate with names and use them in formulae.
- Discover the AbleOwl naming conventions.
- Create, modify and delete range names.
- Use names to toggle frozen panes.
- Quickly hide and unhide rows, columns and sheets.
- Create print area names with comments and use Print Manager.
Create a standard workbook:
- Create a new workbook as a copy of a standard workbook.
Change Guide sheet entries:
- Include reference information.
- Enter Input-Process-Output information.
Change Params sheet entries:
- Understand the purpose and benefits of the Params sheet.
- Discover the Params sheet entries and their uses.
- Insert a new parameter and name it with the AbleOwl ESP convention.
|
|
Format with named styles:
- See the benefits of named styles.
- Master the use of the Style box.
- Discover the AbleOwl ESP convention for named styles.
- Use the Styles Manager.
- Use ESP add-in buttons to apply named styles.
- Copy styles to a workbook that does not have them.
- Create a style.
- Change the default workbook to include the styles.
Insert data sheets and arrange the flow:
- Understand sheet tab naming, colouring and positioning conventions.
Use good typographical style:
- Discover rules for indentation, lines, fonts, colour, shading, underlines, case, alignment, bold, titles positioning, row heights, column widths, rotation, merged cells
Apply ESP to an existing workbook:
- Merge styles.
- Insert standard non-data sheets.
- Set the colour palette.
- Insert column titles component.
- Position Menu sheet hyperlink picture.
- Narrow row and put bottom border above total.
|