Data Analytics with Excel

stats 

Data Analytics with Excel Certificate Program

Apply Now   Get More Information

About

A six-week certificate program covering advanced Microsoft Excel for statistical modeling and data analytics

While Microsoft Excel is arguably the most popular spreadsheet software in the world, many users are not familiar with its advanced functionality for analyzing and reporting data. In our data-centric world, professionals who have the skills to use advanced analytics to help solve business problems and inform decision-making will position themselves ahead of others. The Data Analytics with Excel Program will teach you to prepare data for analysis, work with Microsoft Excel’s advanced formulas, and use various data analysis techniques. It will cover mathematical and statistical concepts in a straightforward and practical manner. The program is best suited for professionals who are familiar with the basics of Excel.

Program content includes lectures, demos, and hands-on exercises. Students are required to bring a laptop with current versions of Microsoft Excel (version 2016 or 2019) to every class. Students can obtain a copy of the software via Microsoft’s Office 365 Education.

Students in this program will be able to:

  • Develop and formulate Excel worksheets by properly incorporating financial functions and macros
  • Answer certain optimization problems using the Solver tool in Excel
  • Apply the foundations of data analysis such as regression and variance analysis, then interpret and analyze the results

For a complete program description, download the program's brochure.

The term "Microsoft Excel" is a registered trademark. The Data Analytics with Excel Program at DePaul University is an independent program of study and is not affiliated with nor has it been authorized, sponsored, or otherwise approved by external entities.

Dates

Winter Quarter 2022:

  • Application Deadline:Dec. 8, 2021
  • Tuition Deadline:Dec. 15, 2021
  • Classes Begin:Jan. 4, 2022
  • Classes End:Feb. 8, 2022

Meeting Pattern

On-Campus Section

Days & Times: Tuesdays, 5:45pm-9:00pm at DePaul's Loop Campus in downtown Chicago.

What if I cannot make it to every class meeting?
Attending every class is highly recommended, but is not required. Classes will be recorded, so any student who is not able to attend will be able to watch the recording of the class. Students are still expected to keep pace with the weekly topics and assignments.

Online: Async Section

This section is paired to the section that meets on campus. It is for individuals who are not expected to attend campus classes. It has no required meeting days.

Students will have access to the recordings of the paired on-campus section. They are expected to follow the same weekly agenda of topics and assignments as the class that meets on campus, but can view the course material at a time of their own choosing.

Fees

Winter Quarter 2022

Tuition

  • $1,450.00

Full payment of tuition must be received before the start of the program. Students who elect to pay tuition using a credit or debit card will be assessed a non-redundable 2.75% convenience fee.

Refund/Cancellation Policy: DePaul reserves the right to cancel any program before that program’s first scheduled meeting, in which case tuition fees (but not convenience fees) will be refunded. The university's refund policy allows a return of 100% of tuition if the student drops the Data Analytics with Excel Program by January 10, 2022 (convenience fees will not be refunded).

Please note tuition fees incurred for this program are not eligible for participation in DePaul's Employer Tuition Deferment Plan or the Single Term Payment Plan.

Notice for Current DePaul Students

  • Undergraduates: Please be aware that the tuition fee for this program is not included in the university’s full-time term package pricing.

Application Fee

  • $40.00non-refundable

Each program requires a $40.00 (non-refundable) application fee that can be paid online (via credit card) during the online application process. If you need to pay this fee by check or money order, please make the check or money order payable to DePaul University and send it to:

DePaul University
Institute for Professional Development
243 S. Wabash Avenue
Room 301
Chicago, IL 60604

Textbooks

Textbooks are a separate purchase to be made by students.

Reading materials for certificate programs consist of textbooks and supplementary handouts. Textbook readings are considered preparatory in nature and are typically assigned prior to lectures; supplementary handouts are frequently distributed in class to provide additional information.

Optional Textbook
Title: Microsoft Excel 2019 Data Analysis and Business Modeling (6th edition)
Author: Wayne Winston
Publisher: Microsoft Press 2019
ISBN#: 978-1-5093-0588-9
List Price: $49.99

Scholarships

The Institute for Professional Development is pleased to announce a new need-based financial award, the Chou Family IPD Scholarship, to provide funding for students interested in our certificate programs in Winter Quarter 2022. Applications will be accepted through Dec. 3, 2021 for this scholarship.  

Admissions

Admission Requirements

Applicants should have basic Excel skills.

Course Credit

The Data Analytics with Excel Program is catalogued as a non-credit course of DePaul University. A certificate of completion from DePaul University is awarded to those who successfully complete the program's requirements. Program requirements include in-class lab work as well as homework assignments. No midterm or final exams are conducted.

  • Course #: IPD 239

The Data Analytics with Excel Program is a graded course. A final grade letter as well as DePaul transcript (upon request) will be available upon program conclusion.

Application & Registration Procedure

All interested parties should apply for admission using the Institute for Professional Development's online application; or, download and complete the Application Form (PDF) and email to ipd@cdm.depaul.edu. Upon admission, the Institute office will contact the prospective student with registration information and instructions.

You do not have to be an existing DePaul student to take this certificate program. Registration is restricted to individuals who apply for admission to the program and receive an acceptance letter. IPD staff will register applicants upon receipt of payment and registration form.

Regular DePaul students cannot register themselves via the university's registration system. If interested in enrollment, regular DePaul students should begin by submitting an application for admission. Students must meet the program's admission criteria.


programmers orking together

Learn about the new, need-based financial award, the Chou Family IPD Scholarship.

Scholarships

What Our Students Say About IPD Programs

"Professor was great. He's very knowledgeable & it is good to know that he's also working in the field. Professor deserves more than 10s."

"The class was very well organized for online students. The instructor was very helpful via email. The topics were well presented."

"Program was great overall. I have taken multiple IPD courses at DePaul and have been happy with all."