02 4967 5631

0416 056 759

TOUR OF EXCEL

  • Starting Excel
  • The Word screen
  • Using tabs and ribbons
  • Backstage View
  • Dialog boxes
  • Using the Quick Access Toolbar

CREATING A NEW WORKBOOK

Typing text and numbers

  • Typing dates
  • Typing formulas
  • Saving a new workbook
  • Frequently used formulas
  • Saving a new workbook
  • Checking spelling
  • Printing options

USING WORKBOOKS

  • Navigating
  • Using Go To
  • Data editing
  • Overwriting cell contents
  • Editing in the formula bar
  • Clearing data and formatting in cells

SELECTING TECHNIQUES

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

FORMULAS

  • Understanding how formulas work
  • Creating formulas for multiplication, division, addition and subtraction
  • SUM function
  • AVERAGE function
  • MIN and MAX functions
  • COUNT function
  • Entering and editing a function manually

COPYING DATA

  • Fill and AutoFill commands
  • Copying from one cell to another
  • Copying relative formulas
  • Drag and drop moving



FORMULA REFERENCING

  • Absolute versus relative referencing
  • Creating absolute references
  • Creating mixed references

FONT FORMATTING

  • Live Preview
  • Changing font style, size and colour
  • Bold, italic and underlining
  • Changing background colour
  • Using the Format Painter

CELL ALIGNMENT

  • Aligning right, centre and left
  • Rotating text
  • Indenting cells
  • Vertical alignment
  • Wrap text

ROW AND COLUMN FORMATTING

  • Changing column width and row height
  • Hiding rows and columns
  • Unhiding rows and columns

NUMBER FORMATTING

  • Applying general formatting
  • Currency formatting
  • Percentages formatting
  • Date formatting
  • Using the thousands separator

PRINTING

  • Print Preview
  • Printing a selection
  • Printing an entire workbook
  • Specifying the number of copies

CREATING CHARTS

  • Creating a new chart
  • Choosing the chart type
  • Modifying an embedded chart
  • Changing the chart type, layout and style
  • Resizing and dragging a chart
  • Copying a chart to  Word or PowerPoint



Excel Introductory