Home · Course Details

This course introduces you to Excel spreadsheets and how they are used in business. You will learn to create, edit, format and print professional looking spreadsheets using simple formulas.

Not sure which level to attend? Click here to take our quick online quiz.

  • Duration: 1 day
  • Target Audience: This course will suit you if you are a beginner and are just getting started with Excel.
  • Prerequisites: Successful completion of MCI Solutions’ Computer Fundamentals course or equivalent knowledge and skills are required to participate in this course.
  • Versions: This course is suitable for users of Excel 2010, 2013, 2106

  • Start and explore Excel
  • Navigate around the workbook
  • Enter and edit data
  • Use simple formulas
  • Manipulate data
  • Format data
  • Preview and print data

Getting to know Excel

  • The Excel screen
  • Using short cut menus
  • Launching Dialog Boxes

Creating a new workbook

  • Typing text, numbers, dates and formulas
  • Making basic changes

Working with workbooks

  • Navigating using the keyboard
  • Using Go To

Editing in a workbook

  • Editing formulas
  • Clearing and deleting data in a cell
  • Using Undo and Redo

Selecting ranges

  • Selecting contiguous and noncontiguous ranges
  • Using special selection techniques
  • Selecting larger ranges

Copying data

  • Using Fill for quick copying
  • Copying from one range to another
  • Copying to another worksheet

Filling data

  • Filling a series
  • Filling using options
  • Creating a custom Fill list

Formulas and Functions

  • Creating formulas that add and subtract
  • Creating formulas that multiply and divide
  • Using the Sum Function to add
  • Finding an average
  • Finding a maximum and a minimum value
  • Common error messages

Font formatting

  • Changing fonts
  • Making text bold, italicised and underlined
  • Changing font colours
  • Using the Format Painter

Cell alignment

  • Aligning left, right and centre
  • Rotating, indenting, wrapping and merging text

Row and column formatting

  • Setting columns widths and row heights
  • Hiding rows and columns

Number formatting

  • Formatting as currency
  • Formatting percentages
  • Increasing and decreasing decimals

Printing

  • Previewing and printing a range
  • Printing an entire workbook

Applying borders

  • Applying a border to a range
  • Removing borders

Working with a worksheet

  • Worksheet zooming
  • Inserting, deleting, moving, copying and renaming a worksheets
  • Switching between worksheets

Worksheet techniques

  • Inserting, deleting, moving, copying and renaming a worksheet
  • Grouping worksheets
  • Freezing rows and columns

Page Setup

  • Page breaks
  • Settings rows as repeating print titles
  • Scaling to a percentage

Getting Help

  • Browsing for help

Name Date Time Location Cost
Excel Introduction 22 January 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 4 February 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 18 February 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 4 March 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 18 March 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 1 April 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 16 April 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 3 May 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 20 May 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 3 June 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 20 June 2019 09:00 am - 04:45 pm Sydney $462
Excel Introduction 17 January 2019 09:00 am - 04:45 pm Melbourne $462
Excel Introduction 4 February 2019 09:00 am - 04:45 pm Melbourne $462
Excel Introduction 5 March 2019 09:00 am - 04:45 pm Melbourne $462
Excel Introduction 1 April 2019 09:00 am - 04:45 pm Melbourne $462
Excel Introduction 7 May 2019 09:00 am - 04:45 pm Melbourne $462
Excel Introduction 3 June 2019 09:00 am - 04:45 pm Melbourne $462

Not quite the content you’re looking for?

Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.