Intermediate Word 2010/2013

Duration 1 Day
Unit Standard ID 116937
Level 1

Course Objective

The Objective of this course is to navigate the Excel program to enable the user to create professional spread sheets with calculations and enhanced formatting and Page formatting to adequately print professional spreadsheets.


Users must have a good understanding of Windows and are able to use the mouse and the keyboard with ease.

Topics covered

  • Identify Elements of the Excel Interface. Including the Ribbon, Quick Access Toolbar and Formula Bar
  • Entering numbers, text and dates
  • Basic formulas using the following Operators:
    • Plus, Minus, Multiply and Divide
  • Basic Functions
    • Sum Function
    • Min Function
    • Max Function
    • Average Function
    • Count Function
  • Copy and Paste Cells
  • Using the AutoSum and Auto-fill features
  • Inserting and Deleting Cells, Rows and Columns
  • Formatting Text, Numbers and Dates
  • Creating, Saving, Opening and Closing of Workbooks
  • Working with Worksheets
  •  Freezing Panes
  • Page formatting
    • Page Breaks, Changing Margins and the Orientation of a Page
  • Add a Header and a Footer
  • Preview and Print a Worksheet