MS Excel (2016, 2019, 365) – Level 3 – 1 Day Online Workshop (PV251)
Advanced Techniques to Help You Manage Your Data with Excel (2016, 2019, 365)
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, 2019 or 365 installed on your computer in order to attend the online session. Please note that the 2010 and 2013 versions are also acceptable.
Excel (2016, 2019, 365) is a popular tool for creating spreadsheets, analyzing data, and charting information. This advanced level, one-day course is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn advanced analysis tools like the Scenario Manager, Goal Seek, Data Tables, and advanced functions. Basic macros will also be covered in this course.
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:
Use more advanced functions: VLOOKUP, IF, database functions to summarize data
Understand concepts of What-If-Analysis: Goal Seek, Data tables, Scenarios
Summarize data by using subtotals
Create and use Pivot Tables and Pivot Charts
Create a basic Dashboard
Record basic macros
Workshop Topics
More Advanced Functions
Using lookup tables
Using functions to summarize data
Logical functions
Projecting Figures
Goal seek
Data tables
What-If Analysis
Scenario concepts
Creating scenarios
Managing scenarios
PivotTables
Data list and Excel table concepts
PivotTable concepts
Creating PivotTables
Modifying PivotTable layouts
Working with PivotTables
Options
Pivot charts
Slicers
Basic Dashboard
Macros
Create simple macros
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.
Sorry, to proceed with online registration you must select your location first. If you are unsure you may still register by phone or email.
Online event registration and ticketing powered by Event Espresso
Who Should Attend This Course?
Experienced Excel users who need to manage large amounts of data using Pivot Tables to summarize and analyze the data. Users will learn more advanced functions and Excel What-If tools to make business decisions.
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
Online Dates
March 29, 2023 9:00 am - 4:00 pm - EDT
July 18, 2023 9:00 am - 4:00 pm - EDT
October 24, 2023 9:00 am - 4:00 pm - EDT
December 13, 2023 9:00 am - 4:00 pm - EST
Location
Course dates listed above will be held live online via Zoom.
