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

Microsoft 365 Excel Level 1 (Beginner) Virtual Workshop

October 18, 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, you will gain an understanding of spreadsheet concepts, including the difference between various Excel versions, use quick navigation and selection techniques in workbooks and learn how to create, save, open and close Excel workbooks.  You will learn how to organize columns and rows of data, edit cell contents, perform basic calculations, work with relative and absolute cell references in calculations, insert worksheet formulas, using the Insert Function dialog box to insert functions.  You will become proficient in formatting worksheets, using view features to review large worksheets. You will also learn how to use Excel views to change worksheet layouts and setup files for printing and preview workbooks.

Workshop Topics

Getting Started with Microsoft Excel
• Understanding Spreadsheet Concepts
• Getting Started
• Creating and Saving Workbooks
• Opening and Closing Workbooks

Modifying Worksheets
• Working with Columns and Rows
• Working with Cell Contents

Using Formulas and Functions
• Creating and Using Formulas
• Creating and Using Functions
• Using Absolute Cell References
• Inserting Functions

Formatting and Viewing Worksheets
• Formatting Worksheets
• Viewing Worksheets

Printing Workbooks
• Using Workbook Views
• Changing the Page Setup
• Previewing and Printing Workbooks

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.