Excel Level 1

Live online events

This course is intended for new Microsoft Office Excel users.

  • 07
    Mar
    1 day, Thu 8:30 AM CST - Thu 4:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 07
    Mar
    1 day, Thu 8:30 AM CST - Thu 4:30 PM CST
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register6 places remaining
  • 18
    Mar
    1 day, Mon 9:30 AM CST - Mon 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 18
    Mar
    1 day, Mon 9:30 AM CST - Mon 5:30 PM CST
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 09
    Apr
    1 day, Tue 9:30 AM CST - Tue 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 09
    Apr
    1 day, Tue 9:30 AM CST - Tue 5:30 PM CST
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
None of these dates work for you? Suggest another date & time

Description

COURSE OBJECTIVES

Upon completion of the course, participants will be able to accomplish the following:

  • Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for
    creating and using Excel worksheets

  • Organize columns and rows to accommodate information and edit the contents of cells to organize the
    information in your worksheet

  • Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute
    cell reference, create formulas by typing functions or build more complex formulas using the Insert Function
    dialog box

  • Format worksheets and use view features to more effectively review large worksheets

  • Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks

COURSE CONTENT

GETTING STARTED WITH EXCEL

Understanding Spreadsheet Concepts; Getting Started; Creating & Saving Workbooks; Opening & Closing Workbooks

MODIFYING WORKSHEETS

Working with Columns and Rows; Working with Cell Contents

USING FORMULAS AND FUNCTIONS

Creating & Using Formulas; Creating and Using Functions; Using Absolute Cell References; Inserting Functions

FORMATTING AND VIEWING WORKSHEETS

Formatting Worksheets; Viewing Worksheets

PRINTING WORKBOOKS

Using Workbook Views; Changing the Page Setup; Previewing & Printing Workbooks

Prerequisites

Windows 7, 8 or 10