ONLINE LEARNING

MS Excel 2016 – Level 2 – 1 Day Online Workshop (PV250)

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).

Limited space may still be available for the October 28 session. Please call Leila at 613-234-2020 ext. 18 or email register@pmctraining.com to check availability and to register.

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.

During this intermediate program you will learn and practice higher level Excel functionality to further make sense of spreadsheets and larger data sets. By using hands-on practical techniques you will be able to analyze complex data sets, organize and visualize data in simple meaningful terms, faster data list management and querying and working with corporate and personal templates.

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:

  • Build on basic skills to manipulate data ranges, in worksheets and formulas
  • Create, manage and work with templates to reduce repetitive work
  • Apply advanced formatting techniques to workbooks an worksheets
  • Work with data to sort, analyze, query and link data
  • Design effective visuals for immediate effect
  • Protect and share your workbook with others


Print Friendly

Workshop Topics

Manipulating Data

  • Naming ranges
  • Using ranges in formulas

Working with Excel templates

  • Creating templates
  • Saving, using and changing templates

Advanced Excel Formatting

  • Advanced worksheet formatting
  • Formatting workbooks

Sorting and Querying Data

  • Understanding data through sorting
  • Understanding data using query

Linking Data

  • Organizing data across multiple worksheets
  • Creating summary views
  • Sparklines
  • Slicers

Creating Visuals

  • Creating charts
  • Working with chart types
  • Creating, using and saving charting templates

Collaborate on Workbooks in New Ways

  • Co-authoring workbooks
  • Improved Excel services
  • Accessibility checker

Protection and Sharing

  • Protection of workbooks and worksheets
  • Sharing of workbooks with individuals and groups

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 - December 8, 2020 [TXON]show details +$480.25 (CAD)*  
Online Workshop - December 8, 2020 [TXQC]show details +$488.62 (CAD)  
Online Workshop - December 8, 2020 [TX5%]show details +$446.25 (CAD)  
Online Workshop - December 8, 2020 [TX15%]show details +$488.75 (CAD)  
Online Workshop - December 8, 2020 [TX-NoTax]show details +$425.00 (CAD)  

* price includes taxes



Online event registration and ticketing powered by Event Espresso

Who Should Attend This Course?

Experienced MS Excel users who are frustrated by working with simple spreadsheets and charts and want to increase both their comfort and productivity with this versatile and powerful spreadsheet tool.

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