FILLING DATA

• Filling a Series
• Filling a growth series
• Filling backwards
• Difference between AutoFill and Fill Commands
• Using a custom fill list

MOVING DATA

Moving cells and ranges

• Moving data to other worksheets
• Moving data to other workbooks
• Saving a new workbook
• Frequently used formulas
• Saving a new workbook
• Checking spelling
• Printing options

LOGICAL FUNCTIONS

• Using IF to display text
• Using IF o calculate values
• Nesting IF functions
• Using IFERROR
• Using TRUE and FALSE
• Using AND
• Using OR

SELECTING TECHNIQUES

• Selecting contiguous ranges
• Selecting non-contiguous ranges
• Selecting rows and columns
• Using ranges with the keyboard

FORMULA TECHNIQUES

• Creating a nested function
• Editing a nested function
• Copying a nested function
• Using concatenation
• Pasting values from formulas

NUMBER FORMATTING TECHNIQUES

• Using other currencies
• Formatting dates and times
• Creating custom formats

CONDITIONAL FORMATTING

• Formatting cells containing values
• Clearing conditional formatting
• Creating a formatting rule
• Top Ten items
• Using data bars and colour scales
• Creating sparklines
• Editing sparklines

PAGE SETUP

• Using built-in and custom margins
• Centring on a page
• Changing orientation
• Setting paper size
• Inserting and removing page breaks
• Setting rows to repeat print titles
• Printing gridlines
• Scaling to a percentage
• Tips for printing larger worksheets

WORKSHEET TECHNIQUES

• Inserting and deleting worksheets
• Copying a worksheet to another workbook
• Renaming a worksheet
• Moving a worksheet
• Changing worksheet tab colours
• Hiding and unhiding rows and columns
• Hiding and unhiding a worksheet
• Freezing rows and columns
• Splitting windows
• Viewing side by side
• Row and column formatting
• Changing column width and row height
• Hiding rows and columns
• Unhiding rows and columns

FINDING AND REPLACING

• Finding text
• Finding cell references in formulas
• Replacing text and values
• Using Replace to change formulas
• Using Go To Special

SORTING DATA

• Alphabetical sort
• Numerical sort
• Sorting on more than one level

FILTERING DATA

• Applying a filter
• Clearing a filter
• Creating compound filters
• Creating custom filters
• Using wildcards

CHARTING TECHNIQUES

• Showing data labels
• Choosing the chart type
• Modifying an embedded chart
• Changing the chart type, layout and style
• Formatting the plot area
• Changing text formatting