Tel: +1 (604) 900-1980

Microsoft (MS) Excel Intermediate

Terms & Conditions Apply
CACA$19*
hero box

CREDENTIAL

Course Certificate

hero box

Delivery

eLearning (Self-paced)

hero box

DURATION

Approx. 8-9 hours

hero box

CLASS SIZE

Private Link

hero box

PREREQUISITES

  • English CLB 7
  • See details below

Course Description

This course provides intermediate-level training in Microsoft Excel, focusing on advanced data management and visualization techniques. Participants will learn how to work with data tables, create and customize charts, and manage multiple worksheets and workbooks effectively. The course also covers essential skills for printing worksheets and securing sensitive data. By the end of the program, participants will be adept at organizing, analyzing, and protecting data, as well as presenting information clearly through charts and printed documents.

Course Outline

Working with Data Tables 

Learn how to create and manage data tables in Excel to organize and analyze information efficiently. This section covers sorting, filtering, and using table features to streamline data management and reporting. 

Displaying Data in Charts

Discover how to create and customize charts to visually represent your data. This section provides techniques for selecting the right chart types and formatting options to make data trends and insights easily understandable. 

Printing a Worksheet

Master the skills needed to print Excel worksheets with precision. This section covers setting print areas, adjusting page layouts, and ensuring that your printed documents look professional and accurate.

Managing Worksheets and Workbooks

Master the skills needed to effectively manage both worksheets and workbooks in Excel. This section covers techniques for organizing multiple worksheets within a workbook, including renaming, rearranging, and linking sheets. Additionally, learn how to handle multiple workbooks simultaneously, including opening, closing, and switching between them, as well as consolidating data across different files for enhanced organization and navigation.

Securing Worksheets and Workbooks

Gain knowledge on how to secure your Excel worksheets and workbooks to protect sensitive information. This section includes methods for setting passwords, restricting access, and applying security features to ensure data integrity.

Requirements

  • Recommended English CLB 7
  • Have access to a device that meets the system requirements to use Northwest Skills Institute online courses

Reviews & Summary

*Price quoted are in Canadian funds, per person, per registration, and does not include any applicable taxes. Subject to change without prior notice.

Preparing you for success

The Northwest Skills Institute is an industry focused training organization.

Our programs are geared specifically for industry, making students more qualified and READY FOR WORK.

Runner to target

It's time to upskill your employees and solve your workforce problems.

Contact our program coordinator
          

Trusted by companies looking to develop highly skilled workers

Manufacturing BC
Discover Tours
Print Forward
Mission Community
Arcteryx
BC Food & Beverage
BSIA
Go Industrial
Great Little Box Company
BC Apparel & Gear
Mustang Survival
Red Wood Rubber

Northwest Skills Institute
Proud Member of

NW Skills acknowledges and respects the traditional territories of the First Nations, Métis, and Inuit peoples upon which we and our partners carry out our work across Canada. We thank the hereditary First Peoples who continue to live on and care for these lands.