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

Data Modeling

Class dates to be determined

Take a deep dive into Microsoft Excel and learn how this tremendously powerful tool can help you manipulate complex data to provide information and make decisions. This hands-on course enhances your Excel skills.

All managerial activities revolve around decision-making.  One of the hallmarks of successful management in a complex and rapidly changing environment is the ability of people to recognize decision situations, understand their essential features, and obtain insight that makes clear what the appropriate actions are. 

Fundamental to decision making is a model that represents the situations.  The spreadsheet-modeling environment is a most widely accepted modeling tool for managerial decision making.  This training studies two fundamental issues of decision making, namely, the modeling of the situations or problems and the solution of those problems.  The purpose of this training is to provide the participants with a working knowledge of a method to address decision situations in a rational, well-organized manner.  

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.

Payment Options

The program costs $995 and includes all materials used.

Payment can be made as follows:

Credit card (Visa, MasterCard, American Express or Discover)
Check made payable to UB Foundation Activities Inc. and mailed to:
Center for Executive Development
108 Jacobs Management Center
Buffalo, NY 14260

I would like to register for this progam