Introduction to Data Modeling using Excel

This course will provide you with expanded knowledge of the capabilities and power of Excel to enhance day-to-day productivity and decision-making. Take your Excel skill to the next level.

If you're already familiar with Excel and wish to learn the most sought after spreadsheet skills, this program is for you. You'll learn tips, tricks and shortcuts, and tap into the power of Excel to enhance day-to-day productivity and decision-making.

• 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)

• Critical thinking/problem-solving
• Digital technology

Categories above are based on the National Association of Colleges and Employers (NACE) key competencies.

• This course is recorded in Excel 2016. It is strongly recommended that participants use Excel 2016 for this course, as screens may vary slightly from version to version.
• This course is for PC users (Windows operating system). Mac users can participate, but screens may vary from what is seen in the course. It is recommended that Mac users run Windows virtually to ensure consistency.
• The program is delivered entirely online. To run the program, you are not required to download any additional software, beyond what is noted above.

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. 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 practice assignment and module quiz with a score of 80% each to unlock the next module. The assignment and 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.

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" in the School of Management's undergraduate program, "Statistical Foundations in Analytics" in the Professional MBA program, and "Data Modeling" in the Executive MBA program. In addition to teaching, she has led workshops and presentations at the local, state and national levels on incorporating technology into statistics and best practices in data visualization.

Teaching

MGQ301 – Statistical Decisions in Management
MGQ606 – Statistical Foundations in Analytics
MGQ633 – Modeling Managerial Processes (Data Modeling)

Professional Affiliations

Decision Science Institute (DSI)
American Society for Quality (ASQ)

Awards and Recognition

Outstanding Faculty Member Award (2019)
Faculty Award for Alumni Engagement (2018)
Milton Plesur Excellence in Teaching Award (2018)
Undergraduate Mentor of the Year (2017)
Higher Education Award, NYSUT (2012)
National Institute for Staff and Organizational Development (2010)
Outstanding Classroom or Alternative Instruction (2010)

Selected Publications

Amo, L.C. & Cichocki, D.M. (2019). Disgruntled yet deft with IT: Employees who pose information security risk. Paper accepted at ACM SIGMIS annual meeting, June 20-22, 2019 in Nashville, Tennessee.

Amo, L.C., Giddens, L., & Cichocki, D.M. (2019). The role of employee gender in managerial perceptions of employee IS risk. Paper to be submitted to IFIP IS Working Group 8.11/11.13 annual meeting, October 4-5, 2019 in Bossier City, Louisiana.

Payment must be received by the program start date to be granted access and can be made by credit card at the time of registration or by ACH transfer.

A 75% discount is available to a limited number of Executive MBA alumni through the Alumni Advantage program. Availability is on a first-come, first-served basis. Contact the Office of Professional and Executive Development at mgt-ced@buffalo.edu.

Discounted seats are available to employees of the University at Buffalo on a space-available basis. Contact the Office of Professional and Executive Development at mgt-ced@buffalo.edu.

Program registrations are fully refundable until the day before the program starts.