fbpx

Microsoft Excel Introduction

Course Description

Microsoft Excel Introduction is part of a 3-level study program. This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.

Learning Outcomes

At the completion of Microsoft Excel Introduction you should be able to:

Prerequisites

Microsoft Excel Introduction assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.

Course Duration

The Microsoft Excel Introduction course is run over one-day but can be customised to suit your needs.

Course Overview

  • The Excel Workbook Screen
  • Using the Ribbon
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Using the Quick Access Toolbar
  • Typing Text, Numbers and Dates
  • Using Easy Formulas
  • Saving a New Workbook
  • Check Spelling
  • Opening an existing workbook
  • Navigating a workbook
  • Navigating using the keyboard
  • Using Go To
  • Recent Files and Folders
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo and Redo
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Using Fill for Quick Copying
  • Copying from One Cell to Another
  • Copying from One Cell to a Range
  • Copying from One Range to Another
  • Filling a Series
  • Filling a Growth Series
  • Extracting with Flash Fill
  • Creating Basic Arithmetic Formulas
  • Using the SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating an Average
  • Finding a Maximum & Minimum Value
  • Creating More Complex Formulas
  • What if Formulas
  • Relative Formulas
  • Problems with Relative Formulas
  • Creating Absolute References
  • Changing Fonts and Font Size
  • Use Formatting Techniques
  • Customise Colours
  • Use Format Painter
  • Apply General Formatting
  • Format Money & Percentages
  • Format Dates
  • Increasing and Decreasing Decimals
  • Perform Alphabetical & Numeral Sort
  • Sorting on More Than One Column
  • Apply and Use a Filter
  • Clear a Filter
  • Multiple Value Filters
  • Creating Custom Filters
  • Use Print Preview
  • Printing a Range or Entire Workbook
  • Print Options
  • Creating a New Chart from Scratch
  • Working with an Embedded Chart
  • Customise Chart Options

Course Includes

Skills Analysis

Certificate

We come to you

Hands-on training

Email Support

Real-world examples

Course Pricing

Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.

Number of participants Investment (per day)
1-on-1 Training $500.00
2-3 participants $650.00
4-6 participants $800.00
7-8 participants $950.00
9-10 participants $1,200.00

Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.

View other course outlines

Microsoft Excel Courses

Excel Intermediate

- 1 day course duration

Microsoft Excel Courses

Excel Advanced

- 1 day course duration

Call Now Button