Microsoft Excel logo

Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who need to know how to use formulas and functions in Microsoft Excel. Upon completion of the course, participants will be able to edit, group and delete worksheets, use simple formulas and functions and create basic charts.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

  • Use edit shortcuts to assist with inserting rows and columns
  • Use AutoFill to create lists such as days of week, months, fortnightly pay periods, roster groups
  • Work with formulas and functions to perform more accurate calculations within cells to produce totals, subtotals or averages
  • Build formulas between worksheets to allow easier data management such as inclusion of summary pages
  • Add formatting to cells, rows and columns such as currency, percentage, date, time
  • Print whole worksheets or selected data and solve printing problems
  • Create and modify a chart by using various charting techniques

Formulas

  • What is a Formula
  • BODMAS Theory
  • Creating a Formula
  • AutoSum Function
  • Copying Formulas
  • Absolute Formulas

Editing Worksheets

  • Naming a Worksheet
  • Copying a Worksheet
  • Grouping Worksheets
  • Inserting and Deleting Worksheets
  • Freezing Rows or Columns

Creating Functions

  • What is a Function
  • Using Paste Function
  • Other Types of Functions

Using Charts

  • Chart Components
  • Chart Types
  • Creating a Chart
  • Formatting a Chart

Linking Between Worksheets

  • Advantages of Linking
  • Creating a Link