Your power-packed agenda  

Copying

• Copy down to match adjacent column.
• Use the End key to great effect.
• Learn 2 ways to make multiple copies quickly.
• Copy in one trip instead of two.
• Copy the cell above.
• Discover range names for repetitive copying.
• Use windows to speed up copying.
• Learn mouse techniques to copy, move and insert.
• Copy column widths across sheets.
• Copy visible cells only.
• Copy only formulas.
• Copy across non-adjacent sheets.

Working with ranges

• View and modify from any corner.
• Select a large blank range quickly.
• Fill a large range quickly.
• Select multiple ranges.

Using fastest methods for regular tasks

• The best ways to insert and delete rows quickly.
• Insert & delete multiple sheets, rows, columns.
• Insert rows in multiple places.
• Use the repeat key.
• Use Alt for one-hand menu selections.
• Insert rows in multiple places.

Using drawing objects

• Annotate with text box, arrow and callout.
• Make several objects into one for ease of moving.
• Select and format several objects simultaneously.
• Use shortcut for hiding objects.
• Do word-processing on the spreadsheet.

Working with files

• Open, save and close multiple files quickly.
• Use shortcut for File Save As.
• Maximize Open dialog box.
• Toggle file list display.
• Use My Places to navigate folders effectively

Formatting

• Shade alternate rows.
• Copy formats to a large range.
• Know the best ways to use the Format Painter.
• Format formula cells differently.
• Understand number formats to create what you need.
• Display in round thousands.
• Hide zeroes.
• Display fractions.
• Use number format to replace unwanted display.
• Widen a column to best fit.
• Use the Fill handle to clear, insert and delete.

Navigating

• Double-click to go to end of list.
• Get to a cell quickly and return.
• Get around quickly with named ranges.
• Navigate sheet tabs quickly.
• Know how to view elsewhere and return.
• Get to the last active cell of column or row.
• Know the useful shortcut keys.
• Maximise and restore quickly.
• Control the drag speed of the mouse.

Printing

• Use names to set print ranges.
• Copy page-setup settings to other sheets.
• Discover special effects.
• Remove all page breaks.

Viewing

• Display two of several open files.
• Display two different sheets.
• Zoom the screen size.
• Freeze panes rather than split screen.
• Synchronize scrolling between windows.

Charting

• Link chart titles to cells.
• See an outline of a graph as you rotate it.
• Plot missing data points.
• Alter source by dragging chart point.
• Insert series and data points by dragging.
• Delete accidentally graphed blank series.

Editing

• Don’t get muddled in Edit, Enter or Point mode.
• Get rid of unwanted hyperlinks.
• Edit a formula by dragging borders.
• Know the useful editing keys.

Working with formulas

• Enter SUM quickly with shortcut.
• Make another sheet the first of a summed range of sheets.
• Debug by splitting into parts.
• Check spreadsheet for error.
• See full precision of formula by two key presses.
• See the result of part of a formula.

Manipulating

• Multiply a range of numbers.
• Remove formulas from a range.
• Convert numbers to text and vice-versa.
• Reset all input cells to zero.

Who should attend:

• Those who have been using spreadsheets for some time and are quite familiar with the basics of formula construction, formatting and printing.