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 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 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.
Summer Quarter 2021:
A second session of this program, with mid-July start date, is now open.
Application Deadline:June 25, 2021
Tuition Deadline:July 2, 2021
Classes Begin:July 13, 2021
Classes End:Aug. 17, 2021
Online: Sync Section
Days & Times:
Tuesdays, 5:45pm-9:00pm (Central Time)
These classes take place at a specific time on a specific day, with the instructor and all the students meeting online using a synchronous meeting tool like Zoom. Classes will be recorded, so any student who is not able to join at the specified time will be able to watch the recording of the class. Before selecting this option, please carefully consider your ability to actively participate in video and audio with a reliable internet connection.
What if I cannot make it to every online synchronous class meeting?
Joining the class meetings in real time is highly recommended, but is not required. You can still take this class by viewing the class recordings and keeping pace with the weekly topics and assignments.
Online: Async (Sync-Option) Section
These classes do not meet at a specific time on specific days. This class is paired with a class that takes place at a specific time on a specific day via Zoom (or similar tool). Students in this class may connect with the live classroom and instructor, if and when they are available, but they are not required to do so.
Students will have access to the recordings of the paired synchronous online classroom. They are expected to follow the same weekly agenda of topics and assignments as the class that meets synchronously, but can view the course material at a time of their own choosing.
Summer 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 July 19, 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.
Textbook to be announced
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 Summer Quarter 2021. Applications will be accepted through May 27, 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.