Navigate quickly

• Move around quickly with shortcuts. (Ctrl+Down arrow, Ctrl+Home, Ctrl+End, Home, End Enter).
• Use windows to see two different sheets on screen together.
• Change Excel options so that you work more efficiently.

Know your way around formulas

• Use SUBTOTAL to create reliable subtotals.
• Create formulas more easily with the Function Wizard.
• Enter formulas rapidly with absolute cell-addressing.
• Calculate stats with AVERAGE, MIN, MAX, COUNT, COUNTA.

Format quickly and consistently

• Format faster and consistently with named styles.
• Copy styles from one workbook to another.
• Include styles in the default workbook.

Discover the benefits of range names

• Get around quickly with names.
• Select ranges quickly to copy or print.
• Build clear formulas quickly.
• Locate names easily by naming with a convention.

Good spreadsheet design tips

Create a Params sheet
• See the benefits of one sheet for storing settings.
Structure sheets for clarity
• Name and colour sheet tabs to show the flow of data.
• Set the order of sheets for ease of understanding.
Document for ease of use and maintenance
• Include step-by-step procedures on the Guide sheet.
• Create a flow-of-data diagram to enable comprehension.
• See other uses for drawing tools.

Prerequisites

All Excel users except beginners. You should be comfortable with the course agenda items of the Solid grounding (Excel fundamentals) course. This is a course that advanced Excel users should also attend, as it covers spreadsheet design conventions, good practice and use of styles for formatting. Even advanced users probably won't know 80% of this.

• Be assured the advice you get is well-proven and utilised.
• Feel free to ask questions.
• Get time away from the office and constant interruptions.
• Enjoy a friendly environment where you don’t feel you’re holding others up.
• Instantly apply what you’ve learned on return to work.