Course manual and files

Excel Genie ESP Essentials - course manual

Excel Genie ESP Essentials - course files

	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 ExSUBTOTAL.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

	Put entries behind panes and switch quickly
	Example files BigSheetNavigate.xls SmallSheetNavigate	Exercise files ExRangeNames2.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