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

Microsoft 365 Excel Level 2 (Intermediate) Virtual Workshop

November 21, 2023 at 9:00 AM to 4:00 PM

Location:Virtual Workshop
Audience:Staff and Faculty
Key Contact:Cheryl Beaupre

Microsoft is ending support for Office 2016 and 2019 on Oct. 10/23. The current version of Microsoft Office has been renamed Microsoft 365 to reflect its growing collection of productivity apps. In order to remain on a supported version Carleton has made Microsoft 365 available to the Carleton community early, ahead of a formal rollout in early October.  We encourage you to upgrade to Microsoft 365 by visiting the Microsoft 365 onboarding page and following the instructions.

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.