Past Event! Note: this event has already taken place.

Microsoft Excel Workshop Level 3 (Advanced) Virtual Workshop

June 13, 2023 at 9:00 AM to 4:00 PM

Location:Virtual Workshop via Zoom
Audience:Staff and Faculty

Please note this Excel Workshop is suitable for PC (Windows) users.  It does not include an Excel for Mac component.

During this virtual workshop, participants will learn to use various tools in order to easily view data records using data forms, create functions, sort and filter in data tables using the Excel table feature, use functions to lookup data in tables, sort data alphabetically and numerically, as well as through custom lists and filter data using AutoFilter and the Advanced filter feature.

Course Topics

1. Working with Data
• Excel Tables
• Using Data Forms
• Using Lookup Tables

2. Sorting Lists
• Perform single and multi-level sorts
• Change sort options
• Chronological sorting
• Create a custom sort/ Autofill custom lists

3. Filtering Lists
• Using AutoFilter
• Using Advanced Filter
• Copying Filtered Data

Registration is available through Carleton Central. Under the Employee Services tab, click on Learning and Professional Development, then select Workshop Registration followed by All Workshops.

More information will be sent to you via email closer to the session date including the Zoom link.