$250

Multiple Dates

Winter 2019-20 - Excel Level 2

Event Information

Share this event

Date and Time

Location

Location

ilinniapaa Skills Development Centre

775 Fred Coman

Iqaluit, NU X0A 0H0

Canada

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

Do you want to improve your understanding and use of Excel for work, school or home use?

Join us for our Microsoft Office Excel Level 2 Intermediate course.

In this 6-hour full day course you will learn the following technical skills:

Creating and Using Tables

  • Create a Table From a list

  • Format the Table

  • Adding Formulas to a table

Using Formulas and Functions

  • Mathematical Operators

  • AutoSum and other auto functions

  • Relative and Absolute References

  • Inserting Functions with the Wizard

  • Understanding formula errors


Managing Formulas in your workbook

  • Creating and using named ranges

  • Auditing Formulas

  • Trace and Remove Trace Arrows

  • The Watch Window


Organizing your information

  • Sorting your data

  • Custom sorting

  • Filtering your data

  • Customizing filters


Charting your data

  • Creating Sparklines

  • Creating Pie, Bar and Line Charts

  • Formatting Charts

  • Creating Trendlines

Typically, the class runs 9-4 with short breaks and a one-hour lunch

Total instruction time: 6 hours

Instructor: Heide Norton-Rennie

Location: ilinniapaa Skills Development Centre, 775 Fred Coman Street, Iqaluit, NU

A certificate will be provided upon successful completion of the course. The certificate is accredited for 6 hours by the Indigenous Certification Board of Canada (ICBOC) and ilinniapaa Skills Development Centre.

For more information contact us at learn@ilinniapaa.ca or call (867) 979-4344.

Share with friends

Location

ilinniapaa Skills Development Centre

775 Fred Coman

Iqaluit, NU X0A 0H0

Canada

View Map

Refund Policy

No Refunds

Save This Event

Event Saved