The School of Business is offering a Virtual Excel Workshop Session with Professor Pat Singkamanand of the Finance Department. The workshop dates and times are noted below.
What does a workshop cover?
The workshop will be based on projects and financial reporting schedule developments, with major focus on Pivot Tables & VLOOKUP.
- Excel Pivot Table: a step-by-step tutorial & examples.
- How to create a Pivot Table to analyze workshop data.
- How to create Table Array and use VLOOKUP to look up & analyze worksheet data.
- Index Match, Conditional Formatting, Text-to-Columns, Concatenate, and If Statement.
Important Information:
- Please sign up only when you are 100% certain to attend the workshop.
- There is a 60 student cap for each session.
- Prior to the Excel workshop, you will receive an email that includes the zoom access information, the workshop material access and the syllabus.
Excel Basic Skills
Wednesday, September 30
- Session 1, 10:00am-12:00pm
- Session 2, 1:00pm-3:00pm
Sign up for a September session.
Excel Intermediate Skills
Wednesday, October 7
- Session 1, 10:00am-12:00pm
- Session 2, 1:00pm-3:00pm