A six-week 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.
Autumn Quarter 2021:
This session is now closed. Dates for the next available session to be announced.
Autumn Quarter 2021
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 September 13, 2021 (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 Autumn Quarter 2021. Applications will be accepted through August 13, 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.