The College of New Jersey

Apply     Visit     Give     |     Alumni     Parents     Offices     TCNJ Today     

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.

Top
Fall 2020 Dean's Office OperationsRead More
+