Microsoft 365 Excel Level 2 (Intermediate) Virtual Workshop

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

During this one-day, virtual workshop, participants will learn to use various tools in order to organize, protect, display and enter data, use IF and IFS functions, create linking formulas, manage links, and manage and arrange multiple workbooks and worksheets within a workbook.  You will create and modify charts to present analyzed data effectively as well as customize charts to enhance their appearance.  You will learn how to create and apply styles to format worksheets consistently and quickly, use notes and annotate worksheets, work with text boxes and create sparklines to highlight and explain data.

Workshop Topics

Worksheet Organization

• Managing Range Names
• Creating and Using Workbook Templates
• Applying Worksheet Security
• Creating and Using Outlines
• Working with Data Validation

Advanced Formulas

• Using the IF Function
• Using the IFS Function
• Linking Formulas
• Modifying and Restoring Links

Using Multiple Workbooks and Worksheets

• Working with Multiple Workbooks
• Working with Multiple Worksheets

Working with Charts

• Creating Charts
• Changing Chart Data
• Modifying Chart Elements
• Creating Custom Charts

Applying Formatting

• Working with Styles
• Annotating Worksheets
• Using Sparklines

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.

When registered you will receive a calendar invitation with the Microsoft Teams link and workshop material.