Microsoft Excel is used to create and format spreadsheets, and analyze and share information.

This hands-on seminar will expand on the topics covered in the Introductory session.

Program Focus:

• Named Ranges and Tables
• Advanced formula construction (IF Function, VLOOKUP, XLOOKUP, XMATCH)
• Pivot Table Report (create and manipulate Pivot Tables)
• Protection and Display options (using comments, hiding rows or columns, protecting worksheets and workbooks)

This workshop is for employees who have completed the Introduction to Excel session and/or are using Excel regularly in their work environment.

Fee Policy: This program is being offered on a cost-recovery basis due to the necessity to engage professional technology Instructors. There is a $100 fee per participant for this program. You will be prompted to enter your department's 26 digit code when registering. The full registration fee will be charged for sessions that are not attended or cancellations received with less than five business days notice prior to the session when we are not able to fill your spot.

Microsoft Excel 365 Workshops

• Register for Microsoft Excel 365 – Introduction [1]
• Register for Microsoft Excel 365 – Intermediate [2]
• Register for Microsoft Excel 365 - Advanced [3]

Instructor

John Rutledge, Resolutions Computer Consulting

Event Registration

Register through Qualtrics! [4] Registration closes 2 working days prior to the session.

Contact

Phone: 56800
Email: landd@uoguelph.ca [5]