02 4967 5631

0416 056 759


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


Excel Intermediate