$250

Multiple Dates

Winter 2019-20 - Excel Level 3 (Pivot Tables)

Event Information

Share this event

Date and Time

Location

Location

ilinniapaa Skills Development Centre

775 Fred Coman Street

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 the advanced functions such as pivot tables in Excel?

Join us for our Microsoft Office Excel Level 3 Advanced training course.

In this 1-day course, you will learn the following techniques:

Protecting your data

  • Working with passwords

  • Protecting cells, sheets and workbooks

  • Protecting shared files

Customize Excel Options

  • Options to control how you work with Excel

  • Setting File Properties

Custom Views

  • Creating Custom Views

Automating work with macros

  • Creating a macro

  • Editing a macro

Creating shortcut buttons to run macros

  • Consolidating workbook Data

  • Link Cells in Different Workbooks

  • Merge Workbooks

Introduction to Pivot Tables

  • Creating recommended Pivot Tables

  • Using Slicers for visual filtering

  • Presenting Data with Pivot Charts


Prerequisite: You must have a solid working Intermediate knowledge of Excel for this advanced course.

Typically, the class runs 9 a.m. to 4 p.m. 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 Street

Iqaluit, NU X0A 0H0

Canada

View Map

Refund Policy

No Refunds

Save This Event

Event Saved