Excel Level 2

Live online events

This course is intended for participants who are familiar with Microsoft Office Excel.

  • 12
    Mar
    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)
    Register4 places remaining
  • 12
    Mar
    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)
    Register3 places remaining
  • 22
    Mar
    1 day, Fri 9:30 AM CST - Fri 5:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 22
    Mar
    1 day, Fri 9:30 AM CST - Fri 5:30 PM CST
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
  • 16
    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)
  • 16
    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:

  • Organize, protect, and display data using various tools.

  •  Use the IF function, create linking formulas, and manage links.

  • Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and
    consolidate data from multiple sources.

  • Create and modify charts to present data effectively; customize charts to enhance their appearance.

  • Create and apply styles to format worksheets consistently and quickly; use comments, text boxes and
    sparklines to highlight and explain data.

COURSE CONTENT

WORKSHEET ORGANIZATION

Range Names; Workbook Templates; Worksheet Security; Outlining

ADVANCED FORMULAS

Using the IF Function; Linking Formulas; Modifying & Restoring Links

USING MULTIPLE WORKBOOKS AND WORKSHEETS

Working with Multiple Workbooks; Working with Multiple Worksheets; Consolidating Data

WORKING WITH CHARTS

Creating Charts; Changing Chart Data; Modifying Chart Elements; Creating Custom Charts

APPLYING FORMATTING

Working with Styles; Annotating Worksheets; Using Sparklines

Prerequisites

Microsoft Office Excel Level 1 or equivalent knowledge.