MS Excel 2016 – Level 1 – 1 Day Online Workshop (PV249)

Effective Techniques to Manage Information

To register please scroll down to the Register Online section and begin by selecting your organization’s billing province (for taxation calculation).

You will need to have the software MS Excel 2016 installed on your computer in order to attend the online session. Please note that the 2010 and 2013 versions are also acceptable.

Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool.

In this one-day workshop, you will learn the basics of creating, modifying, formatting and printing worksheets. You will learn to use basic formulas and functions and manage large workbooks to analyze and understand data.

This is a one-day virtual live workshop.

Space is still available for all course dates listed, unless otherwise noted.

Learning Outcomes

By the end of this virtual workshop, you will be able to:

  • Work with Excel to enter and manage data
  • Set up tables, sort data and work with row and column totals
  • Calculate using Excel formulas
  • Modify, format and print worksheets

Print Friendly

Workshop Topics

Creating a Basic Worksheet

  • Navigate and select in Excel

Microsoft Office Backstage View

  • Enter data and save a workbook
  • Customize the toolbar

Performing Calculations

  • Create basic formulas
  • Calculate with functions
  • Copy formulas and functions

Modifying a Worksheet

  • Manipulate data
  • Insert and delete cells, columns, rows
  • Search for data

Formatting a Worksheet

  • Modifying a worksheet’s appearance: fonts, borders, colours
  • Column width and row height
  • Apply number formats
  • Cell styles

Printing Workbook Contents

  • Print workbook contents
  • Setting print options and page breaks

Managing Large Workbooks

  • Format worksheet tabs
  • Manage worksheets

Register Online

To begin please select your organization's billing address province from the drop down list. (Note: If you are not with an organization, or you are registering personally, please select your own mailing address province.) If you are from out of Canada, please select ‘Out of Canada’ in the drop down.

Once you register the first attendee, you’ll have the ability to add additional attendees or purchase other workshops.

Details Price Qty
Online Workshop - February 23, 2021 [TXON]show details +$480.25 (CAD)*  
Online Workshop - February 23, 2021 [TXQC]show details +$488.62 (CAD)  
Online Workshop - February 23, 2021 [TX5%]show details +$446.25 (CAD)  
Online Workshop - February 23, 2021 [TX15%]show details +$488.75 (CAD)  
Online Workshop - February 23, 2021 [TX-NoTax]show details +$425.00 (CAD)  

* price includes taxes

Online event registration and ticketing powered by Event Espresso

Who Should Attend This Course?

Anyone who has an interest in learning the productivity software MS Excel for analyzing and making sense of large amounts of data.

Does This Course Address Your Competency Development Needs?

This training workshop addresses:

• Achievement / Results Orientation
• Computer and Digital Technology
• Document Use
• Planning / Organizing
• Working with Data and Numbers