MS Excel (2016, 2019, 365) – Level 2 – 1 Day Online Workshop (PV250)
Effective Techniques to Manage Information 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.
Microsoft Excel (2016, 2019, 365) 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 professional 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
Use more advanced formulas and understand absolute referencing
Apply advanced formatting
Work with data to sort, analyze, filter and sub-total
Create charts
Protect worksheets
Workshop Topics
Manipulating Data
Creating names
Using names in formulas
Advanced Excel Formatting
Advanced worksheet formatting
Conditional formatting
Querying Data
Table structure and data validation
Understanding data through sorting and filtering
Sub-totals
Linking Data
Organizing data across multiple worksheets
Creating summary views
Creating Visuals
Creating charts
Working with chart types
Creating, using and saving charting templates
Sparklines and Slicers
Protection and Sharing
Protection of workbooks and worksheets
Sharing of workbooks with individuals and groups
More Advanced Functions
Logical, statistical, date and time and percentages
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 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
Online Dates
October 19, 2023 9:00 am - 4:00 pm - EDT
December 12, 2023 9:00 am - 4:00 pm - EST
February 22, 2024 9:00 am - 4:00 pm - EST
March 26, 2024 9:00 am - 4:00 pm - EDT
Location
Course dates listed above will be held live online via Zoom.
Participants agree: This course is suitable for online delivery.
“There were many valuable tips shared in this workshop that will improve your efficiency using Excel and the presentation of data as well. Excellent workshop – even online!” – Past participant
Overall Satisfaction Level
Workshop Fee:
Only $475 plus applicable taxes
What’s Included?
Participant manual and other course materials
Personalized certificate of completion suitable for framing