A seven-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. It will also show you how to present data in a visually-compelling way by creating a dynamic dashboard.
The program is best suited for professionals who are familiar with the basics of Excel. After a short review of Excel’s elemental functions, the program will cover:
- Common financial functions
- Using Excel's Solver tool to find optimal solutions to a variety of decision problems
- Data analysis with Excel's Data Analysis ToolPak, including descriptive statistics, ANOVA, F-Test, t-Test, exponential smoothing, and correlation
- Binary classification and how to calculate the Receiver Operating Characteristic (ROC) curve for measuring a model's performance; how to calculate and apply the entropy metric, which measures accountability in data-analytic work
- Linear regression: standard normal probability distribution; calculating probabilities from Z-scores; Central Limit Theorem; modeling error; information gain; describing histograms and probability distributions functions; linear regression with more than one input variable
- Data visualization principles and how to create a dynamic dashboard
Program content includes lectures, demos and hands-on exercises. Students are required bring a laptop with Microsoft Excel (version 2016 or 2019) to each class. Students can obtain a copy of the software via Microsoft’s Office 365 Education.
For a complete program description, download the program's brochure.
Dates & Location
Winter Quarter 2020:
Application Deadline:Dec. 18, 2019
Tuition Deadline:Jan. 2, 2020
Classes Begin:Jan. 13, 2020
Classes End:Mar. 2, 2020
On-campus section: Classes meet on Monday evenings (5:45pm-9pm), except for MLK Jr. Holiday on Jan. 20th (university closed). Classes held at DePaul's Loop Campus at 243 S. Wabash Avenue, Chicago.
Online section: Students may elect to register in an online section of this program. For more information about the online section, click
Winter Quarter 2020
Regular DePaul University students are charged the above rates based on their degree program. The tuition fee for this program is not included in the university's tuition package for full-time undergraduate students.
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 Jan. 27, 2020 (convenience fees will not be refunded).
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 information to be announced
Fees are payable by check made out to DePaul University, or by credit card. Students who elect to pay tuition using a credit or debit card will be assessed a non-redundable 2.75% convenience fee.
Applicants who are eligible for a tuition reimbursement program offered by their employer and are interested in deferring their tuition payment using the university's Employer Tuition Deferral Plan must return the Employer Tuition Deferral Plan application to the Institute for Professional Development Office. Submitting this application to any other DePaul office may delay the student's registration process. Information about this plan, along with an application form, is found
Applicants who wish to use the university's Single Term Payment Plan or a third-party billing arrangement should contact the Institute for Professional Development office at (312) 362-6282 for details.
Applicants should have basic Excel skills. In addition, students are required to bring a laptop with Microsoft Excel (version 2016 or 2019) to each class. Students can obtain a copy of the software via Microsoft's Office 365 Education.
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 reading, homework assignments, and projects. 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 to apply via fax, mail, or in person, print out and complete the
Application Form. Upon admission, the Institute office will contact the prospective student with registration information and instructions.
Registration is restricted to admitted students. IPD staff will register students upon receipt of payment and registration form. Regular DePaul students cannot register themselves via the university's registration system.