Nationally Recoginised Training
Business Training Courses

Microsoft Excel Introduction

This course is designed to provide candidates with introductory Microsoft Excel skills and knowledge, such as creating basic worksheets, utilising basic features, designing formulas and formatting data.

MCO can offer this program onsite at your workplace as well as offering public scheduled courses at our premises, Unit 4/193 South Pine Road, Brendale, Queensland, 4500.

Note that our public scheduled computer courses generally run for a day, from 9.00 am to 4.00pm. However, depending on requirements, we can run customised courses to suit employer needs (course cost, overview and duration to be quoted separately).

Overview
  • Introduction to spreadsheets
  • Screen layout
  • Menus and toolbars
  • Navigating a spreadsheet
  • Selecting cells and ranges
  • Help screens

Basic Formulas

  • Basic calculations
  • Autofilling formulas
  • Introduction to functions
  • Sum and average

More Formulas and Functions

  • MAX and MIN functions
  • Date functions
  • Autofilling functions
  • Multiple worksheets

Editing Data

  • Copying cells and ranges
  • Moving cells and ranges
  • Copying formulas
 Basic Worksheets
  • Entering data
  • Inserting rows and columns
  • The autofill feature
  • Opening, closing, saving
  • Deleting data
  • Printing and previewing

Charting

  • Charting overview
  • The chart wizard
  • Formatting charts
  • Updating chart data

Formatting Cells

  • Changing fonts
  • Formatting cell data
  • Best fit feature
  • Borders and shading
  • Alignments
  • Advanced formatting

Printing

  • Troubleshoot printing
  • Freeze panes/splitting
  • Repeat rows and columns



Click here for MCO's schedule of public course costs.

Click here for MCO's schedule of upcoming public course dates.