Microsoft Excel Course Titles

Excel Introduction

Duration: 1 day | Book this course
Cost: $325.00 + GST

Course Description

This one-day introductory class covers all the basics of Microsoft Excel. Participants will learn how to enter and edit information in a worksheet; manage and navigate worksheets and workbooks; perform basic calculations and manipulate worksheet data; format the worksheet contents; and prepare, set up, and print information.

Prerequisites

Prerequisites
Familiarity with the Windows operating system is essential. If you are unsure, please complete a Training Needs Assessment form by clicking here or phone our Bookings Administrator on (07) 857.0776.

Who Should Take This Course
New users of Microsoft Excel.

Course Objectives

Course Objectives

Upon completing this course, you will have learned how to:

  1. Create, save and close a workbooks.
  2. Enter and edit text and numbers in a worksheet.
  3. Navigate worksheets and workbooks.
  4. Perform basic calculations on data.
  5. Manipulate rows and columns
  6. Format the contents of a worksheet.
  7. Prepare, set up, and print information.

Course Outline

Course Outline

Worksheets and Workbooks

  • The Excel screen (The File menu, the Ribbon, Quick Access Toolbar, Zoom, Views)
  • Creating, Saving, and Closing Workbooks
  • Understanding different file types including Compatability mode
  • Understanding the difference between a workbook and a worksheet

Using Excel

  • Selection Techniques
  • Entering information (Text, Numbers, Formulas and Dates)
  • Editing information in cells
  • Undoing and redoing an action

Manipulating rows and columns

  • Inserting and deleting rows and columns
  • Resizing rows and columns (including best-fit option)
  • Freezing row and column headers

Copying, Moving and Deleting Information

  • Copying and moving cell content (cut, copy, paste)
  • Deleting cell content

Worksheets

  • Inserting a new worksheet
  • Renaming and deleting a worksheet
  • Copying or moving worksheets between workbooks

Using Excel Functions to perform basic calculations

  • Understanding the difference between a Formula and a Function
  • AUTOSUM function
  • AVERAGE function
  • MAX function
  • MIN function
  • COUNT function

Writing Formulas

  • Introduction to Formulas
  • Easy ways to create formulas
  • Copying formulas using AutoFill
  • Formula error messages
  • Relative, Absolute, and Mixed cell referencing

Formatting

  • Font formatting
  • Alignment formatting
  • Format Painter
  • Number formatting

Checking spelling in a Worksheet

Printing

  • Comparing workbooks side by side
  • Print Preview
  • Setting the Page Options and Margins
  • Adding Headers and Footers
  • Inserting and Removing a Page Break
  • Printing a Worksheet