Reaching Others University at Buffalo - The State University of New York
Skip to Content

Data Modeling

Spring 2016 dates coming soon.

Microsoft Excel is a tremendously powerful tool that allows you to manipulate complex data to provide information and make decisions. This hands-on course enhances your Excel skills.

Course Objectives

With a little knowledge and a willingness to practice and make mistakes, you'll be amazed at how quickly your effectiveness in using spreadsheets will improve.

Who Should Attend

  • Systems Analysts
  • Business Analysts
  • IT Project Managers
  • Associate Project Managers
  • Project Managers
  • Project Coordinators
  • Project Analysts
  • Project Leaders
  • Senior Project Managers
  • Team Leaders
  • Product Managers
  • Program Managers


  • Auditing
  • Toolbars
  • Go To Special feature
  • Charts
  • Basic customization (lists, defaults, windows)
  • Data analysis
  • Pivot tables
  • Statistical analysis toolpack
  • Formatting
  • Beginning to advanced formulas
  • Beginning, intermediate and advanced functions (arrays, information and text)
  • Nesting
  • Idiot proofing
  • Validation
  • What if analysis
  • Data tables
  • Scenarios
  • Goal seek and solver

About the Instructor

Frank Krzystofiak is associate dean of executive education and associate professor of organization and human resources in the School of Management.

Frank earned his PhD, MAIR and BSBA at the University of Minnesota. His teaching and research interests are in human resource management, with specialties in staffing, selection, employment discrimination and affirmative action planning. Frank was honored with the SUNY Chancellor's Award for Excellence in Teaching and an Outstanding Professor Award from the Graduate Management Association. He has consulted widely on human resources problems, particularly with respect to human resources information systems.


The program costs $995 and includes all materials used.

To pay by credit card, call 716-645-3200. Visa, MasterCard, American Express and Discover are accepted.

Make checks payable to UB Foundation Activities Inc. and mail to:

Center for Executive Development
108 Jacobs Management Center
Buffalo, NY 14260

I would like to register for this progam