The School of Business is offering in person Excel workshops with Professor Pat Singkamanand of the Finance Department.
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.
Both Sessions are identical:
- BASIC SKILLS: Wednesday, March 2, 1:00-3:30pm
-
- Sign up here.
- INTERMEDIATE SKILLS: Wednesday, March 9, 1:00-3:30pm
- BASIC SKILLS: Wednesday, March 23, 1:00-3:30pm
- INTERMEDIATE SKILLS: Wednesday, March 30, 1:00-3:30pm
- Please sign up only when you are 100% certain to attend the workshop.
- Attendance is IN PERSON and will be monitored.
- Limited to 30 seats per workshop.
- Prior to the Excel workshop, you will receive an email that includes the zoom access information, the workshop material access and the syllabus.