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.
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.
- 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