Your power-packed agenda  

Manipulating

• Complete missing entries.
• Insert column to left of each in a range.
• Convert case of entered text.
• Enter numbers as text.

Working with lists

• Use AutoFilter to delete and format.
• Remove entries adjacent to blank cells.
• Provide list to select from.
• Validate existing data.
• Sort certain items to the top.
• See and create a unique list from a column.

Working with formulas

• Spot errors by displaying formulas.
• Build a long formula in parts and merge.
• Stop a workbook calculating on open.
• Be aware of calculation mode trap.
• Force all cells to calculate in case of bug.
• Lay out formula for clarity.
• Use R1C1 references for ease of editing.
• Include notes you can see with active cell.
• Create a compact input form.

Inserting non-keyboard characters

• Type (c) without conversion to ?
• Insert a non-keyboard symbol.

Entering data

• Make use of AutoComplete.
• Avoid typing =.
• Enter standard long text entries quickly.

Charting

• Create user-defined custom chart type.
• Change the series order.
• Combine chart types on two axes.
• Chart data in the opposite direction.
• Create a vertical line chart.
• Create Pie of Pie chart.
• Chart stacked beside not stacked.

Working with files

• Change the default folder.
• Get more from the recently-used file list.
• Know what folder a file is from.
• Use a workspace to open many files.
• Prevent a file being saved by accident.
• Create a backup as you save.
• Make commonly used files readily available.
• Create a new folder.

Formatting

• Wrap column heading text.
• Start a new line in a cell.
• Make space automatically expand to fit text.
• Display hours beyond days.
• Display min and sec in time display.
• Set the default format.
• Quickly indent text by one space.
• Avoid merged cells.
• Centre across columns.
• Colour cells depending on their value.
• Reset cell colour.
• Solve problem of no parentheses on negatives.

Navigating

• Jump quickly among Excel files.
• Jump to see next comment.
• Move around unlocked cells.
• Make Enter take you to the start column of next row.
• Go big distances quickly.
• Colour sheet tabs to help navigation.
• Use shortcut to get to Windows desktop.

Printing

• Print with continuous page numbers.
• Specify the number of the first page.
• Add to page number and total pages.
• Suppress print of colours, patterns etc.
• Get & to appear in footer.
• Have objects not print.
• Suppress the printing of errors.

Working with ranges

• Hide columns quickly.
• Spot the difference.
• Select differences between columns.
• Stop range extending unintentionally.
• Select current region.

Searching

• Search for a file.
• Search upwards with Find.
• Repeat the last Find.

Setting excel’s options

• Switch off those irritating options.

Working with toolbars

• Add a command to the Quick Access Toolbar In Excel
• Customize the Excel 2010 Ribbon.
• Keep a copy of toolbar settings
• Discover the dual nature of many buttons

Viewing

• Use Views to switch Filter Criteria.
• Quickly switch display of hidden columns.
• Know how hidden data can still be seen.
• Redisplay hidden column A.
• Quickly hide the rows of old records.
• Increase the size of the menu font.
• Change comment default font and colour.
• Show more of sheet and revert.

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.