Microsoft Excel Essentials

Excel_logo

Course Overview

The Excel Essentials course is aimed at those who want to be able to create and edit basic spreadsheets containing simple calculations and links, and produce formatted and printable reports.

Upcoming Course Dates

14

8.30am to 3.30pm
Gladstone $352 (inc. lunch) Book Online Now >>

25

9.00am to 4.00pm
Brisbane $352 (inc. lunch) Book Online Now >>

1

8.30am to 3.30pm
Gladstone $352 (inc. lunch) Book Online Now >>

29

9.00am to 4.00pm
Cairns $352 (inc. lunch) Book Online Now >>

Course Content

Create an Excel workbook

  • Create a workbook from the Start Menu
  • Create a workbook from the Start Screen
  • Create a new workbook from Excel
  • Save an Excel Workbook

  • Save a new, previously unsaved workbook
  • Save (update) previously saved workbook
  • Save a workbook as a PDF document
  • Create a copy of your workbook
  • Pin a workbook to recent file list
  • Close & Open Existing Workbooks

  • Close a workbook
  • Close multiple workbooks
  • Open an existing workbook from Excel
  • Open a workbook from File Explorer
  • Open a recent workbook
  • Change Worksheet Views

  • Use the Zoom Slider
  • Freeze panes
  • Normal View
  • Page Layout View
  • Page Break Preview
  • Customise Quick Access Toolbar

  • Move the Quick Access Toolbar
  • Add common buttons to QAT
  • Add other buttons to QAT
  • Enter Data into a Workbook

  • Enter data vertically
  • Enter data horizontally
  • Move data to another cell
  • Insert a comment in a cell
  • Use Copy and Fill handle

  • Fill a custom list
  • Fill a series of word/number combinations
  • Fill a series of numbers or dates
  • Copy Data to another Location

  • Copy data to adjacent cells
  • View the Clipboard
  • Select data to copy
  • Select data to paste
  • Edit Data

  • Edit data in cell whilst typing
  • Edit data in the formula bar
  • Clear contents of a cell
  • Use spell check
  • Insert & Delete Rows & Columns

  • Insert a row / column
  • Insert multiple columns / rows
  • Delete row / column
  • Delete multiple rows / columns
  • Hide & Unhide Rows & Columns

  • Hide a row / column
  • Hide multiple rows / columns
  • Unhide row / column
  • Unhide multiple rows / columns

Use Find and Replace

  • Find data on current worksheet
  • Find data in current workbook
  • Replace data in workbook
  • Use Formulas

  • Adding numbers
  • Subtracting numbers
  • Dividing numbers
  • Multiplying numbers
  • Insert, Name & Delete Worksheets

  • Insert a new worksheet
  • Rename a worksheet
  • Delete a blank worksheet
  • Delete a non-blank worksheet
  • Move and Copy Worksheets

  • Reorder worksheets
  • Copy a worksheet
  • Copy worksheet to another workbook
  • Use Functions

  • Use SUM function
  • Use AVERAGE function
  • Use MIN function
  • Use MAX function
  • Use TODAY function
  • Link Data

  • Link to a cell within the same worksheet
  • Link to a cell on different worksheet
  • Link to multiple cells
  • Apply Font Formatting

  • Font and Size
  • Bold, Italic and Underline
  • Cell Borders
  • Font and Cell Colours
  • Use the format painter
  • Apply Quick Number Formatting

  • General
  • Number
  • Currency / Accounting
  • Short / Long date
  • Percentage
  • Text
  • Column Widths & Row Heights

  • Manually increase column width
  • Manually increase row height
  • AutoFit column(s)
  • Set multiple columns to same width
  • Align Data in a Cell

  • Basic cell alignment
  • Centre align text across multiple cells
  • Text orientation (angle)
  • Printing Worksheets

  • Set page orientation
  • Set paper size
  • Set scaling
  • Change margins
  • Repeat row / column header(s)
  • Print gridlines

Printable course information

Pre-requisites

  • Basic computer experience, including keyboard and mouse skills
  • Familiarity with Microsoft Windows

If you are not familiar with using a computer or Microsoft Windows, the course Introduction to computers, will give you the skills to take this Excel course.