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.
Winter Quarter 2022:
Application Deadline:Dec. 8, 2021
Tuition Deadline:Dec. 15, 2021
Classes Begin:Jan. 4, 2022
Classes End:Feb. 8, 2022
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.
Winter Quarter 2022
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.
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:
Institute for Professional Development
243 S. Wabash Avenue
Chicago, IL 60604
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.
Title: Microsoft Excel 2019 Data Analysis and Business Modeling (6th edition)
Author: Wayne Winston
Publisher: Microsoft Press 2019
List Price: $49.99
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.
Applicants should have basic Excel skills.
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.
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 firstname.lastname@example.org. 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.