Data Modeling

Let the University at Buffalo School of Management help your organization learn the power of spreadsheet modeling with Microsoft Excel. 

You can use mathematical formulas and calculations to help predict what is likely to happen based on past data recorded.

Call us at 716-645-3200 to set up a training session at your facility, or avoid office distractions by conducting training here at UB. We can also be reached via email at mgt-ced@buffalo.edu.

Course Objectives

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.

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 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. 

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

Topics

  • 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