Past Event! Note: this event has already taken place.
Microsoft Excel 2016 Virtual Workshop – Level 3 (Advanced)
June 1, 2022 at 8:30 AM to 12:00 PM
| Location: | Virtual Workshop via Zoom |
| Cost: | Free |
| 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 half day 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 and followed by All Workshops. More information will be sent to you via email closer to the session date.