Western Mass Chapter #19 APICS presents a Professional Development Meeting Seminar:

February 15, 2012

"The Power of Pivot Tables"

by Jodi Welch, CPIM

With new systems, applications and programs entering the market year, companies are capturing more raw data than ever before.

More often than not, this data will be used in multiple reports that each gives you only one or two points of interest. They are not very dynamic. Effect analysts know a better way. They know how to create reporting that will drive conversations and support decisions. They create multi dimensional reporting. Reporting that can "slice and dice" the data on the fly, during the meeting. The type of reporting that can dive 5 and 6 levels deep into the details to support root cause analysis. They create reports with Pivot Tables.

This session is a "hands on" and inter-active. Each participant will learn:

  • The importance of strong foundation data
  • How to create their own pivot tables
  • How to modify and format the pivot tables
  • How to use the tables in effective reporting
Participants will leave the session with a flash drive that contains:
  • Instruction manual from session
  • Sample pivots tables
  • Quick Tips on pivots tables
Your Instructor
Jodi Welch is a Financial Analyst at Yankee Candle with expertise in Inventory Management. She brings over 20 years of supply chain experience in data mining and report writing. She is known for her strong analysis which drives conversations, supports actions and helps direct company business decisions. This is the long-awaited follow-up to her highly regarded presentation in the fall of 2010 and we are sorry it took so long to schedule it.

Session Requirements:
Each participant must bring a laptop and have Microsoft Excel loaded on it. Please make sure your battery is "FULLY CHARGED."

RESERVATIONS
Call Jack Perazella (413) 527-2842, or email at japer@juno.com. Registration will be limited to the first 20 (first come-first pay) to respond, with payment to be received by Friday, 2/10/12, to ensure your place in the class.

Payments should be sent to (also check payable to:

WMass Chapter #19 APICS
PO Box 2571
Springfield MA 01101-2571

AGENDA
Lunch: 12:15 PM (sandwiches, salad, soft drinks, cookies)
Seminar: 1:15-3:15 p.m.

PRICE
Vouchers may be applied, 1 per registrant.
Members: $99.00
Non-Members: $99.00

DIRECTIONS to Yankee Pedlar at intersection of routes 5 and 202 in Holyoke:

From I-91 North: I-91 to Exit #16 for Rte 202. At end of ramp, bear right and proceed about ½ mile down to Rte 5. Yankee Pedlar is to the left just across the intersection.

From I-91 South: Exit #16 for Rte 202. At end of ramp bear left and proceed as above.

From Mass Pike: Exit 4 for I-91. Take I-91 North to Exit 16 and proceed as above.