Past Event! Note: this event has already taken place.
Microsoft Excel 2016 Virtual Workshop – Level 2 (Intermediate)
May 19, 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 organize, protect and display data in workbooks, use IF functions, create linking formulas, manage links, combine data from multiple sources by copying and pasting links, manage and arrange multiple workbooks and worksheets within a workbook and consolidate data from multiple sources using functions.
Course Topics
1. Worksheet Organization
• Managing Range Names
• Creating and Using Workbook Templates
• Applying Worksheet Security
• Creating and Using Outlines
2. Advanced Formulas
• Using the IF Function
• Linking Formulas
• Modifying and Restoring Links
3. Using Multiple Workbooks and Worksheets
• Working with Multiple Workbooks
• Working with Multiple Worksheets
• Consolidating 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.