Excel Genie ESP essentials

Download the GenieMini Excel add-in for tree Download

Course manual and files

Excel Genie ESP Essentials - course manual

Excel Genie ESP Essentials - course files

Course content

The need for standards

The Genie add-in to help apply the standards

Create a standard workbook

Format quickly and consistently with styles

Example files

StylesApply.xls

NamedStyles.xls

Exercise files

ExStyles.xls

ExStylesApply.xls

Insert subtotals instantly

Example files

SUBTOTAL.xls

ESPLinesConvention.xls

Exercise files

StylesApply.xls

Discover the benefits of range names - part 1

Example files

RangeNamesBigSheet.xls

ActBud.xls

Exercise files

ExRangeNames.xls

Discover the benefits of range names - part 2

Example files

RangeNamesBigSheet.xls

ActBud.xls

Exercise files

ExRangeNames.xls

Navigate quickly

Example files

AASalesComplete.xls

Conventions for layout of sheets within a workbook

Example files

AASales.xls

AASalesNew2.xls

AASalesBeforeParams.xls

AASalesBad.xls

AASalesBeforeDiagram.xls

Exercise files

ExReformat.xls

Conventions for layout of sheets within a workbook - Guide sheets

Conventions for layout of sheets within a workbook - Params sheets