Introduction to Data Modeling using Excel

Jacobs Mgt Center.

Choose from two sessions in this self-paced, 10-week online program
January 6 - March 15, 2020
June 1 - August 9, 2020
Cost: $1,250

Most self-proclaimed Excel users actually use less than 10% of a spreadsheet’s analytical capability. Spreadsheets are tremendously powerful tools.  With them, you can manipulate complex data to supply the information you need to make critical business decisions. This course will enhance your Excel skills by teaching you to use spreadsheets as a tool to model data and support your decision-making.

You'll learn:

  • Formulas and Functions (sum, average, count...)
  • Logical and Reference Functions (if, lookups, index and match...)
  • Text Functions for data cleaning (trim, left, right, find...)
  • Conditional Formatting
  • Basic Data Modeling (Pivot Tables, What If Analysis...)

Introduction to Data Modeling using Excel is a certificate program and non-credit-bearing.  There are no degree requirements for the program.

Program Structure

You can complete this program at your own pace, anywhere and anytime, as long as you have a computer with access to the internet and a web browser.  You are not required to download software onto your computer. On the program start date, you'll receive access and must complete the program within 10 weeks. 

The program consists of five modules that you must complete in sequence.  Each module contains:

  • Instructor-led videos and resources
  • A practice assignment to reinforce the lesson
  • A module quiz to ensure you understand the subject matter

You'll need to complete the module quiz with a score of 75% to unlock the next module.  The quizzes are meant to ensure you understand the content and can be retaken as many times as needed to achieve a passing score.

Upon completion, your certificate will be mailed via United States Postal Service for participants in the continental U.S.  All others will be sent via United Parcel Service.

About the Instructor

Dianna Cichocki.

Dianna Cichocki

Clinical Assistant Professor
Management Science and Systems Department

Education

MS, Oswego State University
BA, St. John Fisher College

Dianna Cichocki teaches "Statistical Decisions in Management" and "Statistical Foundations in Analytics." She has given several presentations at both the state and national levels about incorporating technology into statistics, educational practices and assurance of learning. Cichocki has been honored with academic excellence awards for her instruction.

Professional Affiliations

    American Mathematics Association of Two-Year Colleges (AMATYC)
    New York State Association of Two-Year Colleges (NYSMATYC)

Awards and Recognition

    National Institute for Staff and Organizational Development (2010)
    Outstanding Classroom or Alternative Instruction (2010)

Payment Options

Payment must be received by program start date to be granted access.

Payment can be made as follows:

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

Refund Policy

Program registrations are fully refundable until the day prior to the start of the program.