The College of New Jersey Logo

Apply     Visit     Give     |     Alumni     Parents     Offices     TCNJ Today     Three Bar Menu

Excel Workshops

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:

Session A
  • BASIC SKILLS: Wednesday, March 2, 1:00-3:30pm
  • INTERMEDIATE SKILLS: Wednesday, March 9, 1:00-3:30pm
Session B
  • BASIC SKILLS: Wednesday, March 23, 1:00-3:30pm
  • INTERMEDIATE SKILLS: Wednesday, March 30, 1:00-3:30pm
Important Info:
  • 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.


School of Business

Business Building, Room 114
The College of New Jersey
P.O. Box 7718
2000 Pennington Rd.
Ewing, NJ 08628