Excel Level 2

Reset

Live online events

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

  • 19
    Dec
    1 day, Tue 8:30 AM CST - Tue 4:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 19
    Dec
    1 day, Tue 8:30 AM CST - Tue 4:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 09
    Jan
    1 day, Tue 8:30 AM CST - Tue 4:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 09
    Jan
    1 day, Tue 8:30 AM CST - Tue 4:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 18
    Jan
    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)
    Register
  • 18
    Jan
    1 day, Thu 8:30 AM CST - Thu 4:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 08
    Feb
    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)
    Register
  • 08
    Feb
    1 day, Thu 8:30 AM CST - Thu 4:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 16
    Feb
    1 day, Fri 8:30 AM CST - Fri 4:30 PM CST
    Online
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
  • 16
    Feb
    1 day, Fri 8:30 AM CST - Fri 4:30 PM CST
    In Person
    • Group Rates Apply (6 or more) $283.79 excl. GST + PST (SK)
    • $295.00 excl. GST + PST (SK)
    Register
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.

Similar courses

Powered by Arlo training & Event Software