The College of New Jersey Logo

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

Virtual Excel Workshops

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

Sign up for an October session.

Contact

School of Business

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

609.771.3064
business@tcnj.edu