Excel Workshops
The Office of Information Technology provides training for many aspects of using Excel. Full descriptions of the workshops can be found below. Visit IT Workshops overview to browse and register for upcoming scheduled workshops.
On this page:
Excel and Spreadsheet Basics
Length: 1-2 hours
Description: This workshop is intended for people who are new to spreadsheets like Excel and Google Sheets and people who want to brush up on the basics of spreadsheets. It’s an introduction to spreadsheets.
Excel is Microsoft’s spreadsheet application and is a great tool for working with data, keeping lists and organizing items. In this free workshop we’ll open Excel, create a spreadsheet and go over the basics of Excel and also create, share, and edit a Google Sheet.
Cells, Rows, Columns
File options, Quick Access Toolbar, Office Ribbon
Zoom, Page layout, Preview page, Printing
Columns & Rows: Insert, resize, delete, freeze
Worksheets: Insert, Move, Rename, Color, Hide, Delete
Google Sheets: Create, Share, use
Excel: Introduction
Workshop offered: Every other term or on demand
Length: 2 hours
Description: Excel is a great tool for tracking projects, organizing data, and turning raw data into usable information. This free workshop will get beginners up to speed and also give Excel users some new tips and features.
This workshop is appropriate for people new to Excel and people who haven’t had time to really explore what Excel can do for them. An Excel workbook will be shared with attendees and used to practice the basic features of Excel.
Excel: Intermediate I and II
Workshop: Every other term or on demand.
Length: 2 hours each
Description: This workshop is intended for people who know the basics of Excel.
In this free workshop an Excel workbook will be shared with participants and we’ll use this go over some exercises in Excel.
Check in and open shared workbook
Exercises
Time for questions
Excel Charts and Pivot Tables
Workshop: Every other term or on demand
Length: 1.5 hours
Description: This free workshop covers Microsoft Excel charts and the powerful Excel Pivot Table feature, which is used to organize, summarize, analyze lists of data. A general knowledge and experience of the basics of Excel is required.
During the last half hour, there will be time for questions and to go over your own workbooks, so bring your questions.