Microsoft Excel Course Titles

Excel Introduction

Duration: 1 day | Book this course
Cost: $375.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 email This email address is being protected from spambots. You need JavaScript enabled to view it. .

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 workbook.
  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 Compatibility 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
  • 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