An 11-week program covering advanced Microsoft Excel® and Tableau® for statistical modeling, data analytics, and VBA programming
Note: As of spring quarter, IPD 239 Data Analytics with Excel Program is replaced with IPD 243 Data Analytics with Excel and Tableau Program.
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. DePaul’s Data Analytics with Excel and Tableau Program will teach you to prepare data for analysis, use various data analysis techniques, and present data in a visually-compelling way using two of the most popular tools for business intelligence and data analytics. The first part of the program will cover an introduction to regression, analysis of variance, and probability theory using tools available in Excel as well as coverage of VBA programming and how it can help with data analytics. The second part of the program will cover working with data and understanding visualizations in Tableau as well as some advanced analytics and integration with other tools. Mathematical and statistical concepts will be covered in a straightforward and practical manner. The program is designed for information technology and business professionals who have basic skills in Excel. No prior Tableau or programming experience is needed.
Program content includes lectures, demos and hands-on exercises. Students are required bring a laptop with current versions of Microsoft Excel and Tableau to every class. Students will be instructed to download a copy of the software for educational use, but they must have full administrator rights to their laptop in order to install software.
Students in this program will be able to:
- Learn the fundamentals and proceed to advanced topics in VBA (Visual Basic for Applications)
- Learn the foundations of data analysis like regression analysis and analysis of variance using Excel
- Comprehend the foundations of probability theory
- Learn the essentials of Tableau concepts
- Explore how to work with data in Tableau
- Learn core visualizations in Tableau and how to use Tableau for presentations
- Gain competency in some advanced analytics using Tableau
For a complete program description, download the program's brochure.
Dates & Location
Summer Quarter 2020:
The summer session is now closed.
Autumn Quarter 2020:
Application Deadline:Late Aug. 2020
Tuition Deadline:Late Aug. 2020
Classes Begin:Week of Sept. 7th (Date TBA)
Classes End:Week of Nov. 23rd (Date TBA)
On-campus section: Classes usually meet one evening per week (5:45pm-9pm; weeknight to be announced) 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
Autumn Quarter 2020
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 and Tableau Program within the first two weeks of the start of the program (convenience fees will not be refunded).
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: Mastering Tableau 2019.1: An expert guide to implementing advanced business intelligence and analytics with Tableau 2019.1 (2nd edition)
Author: Marleen Meier and David Baldwin
Publisher: Packt Publishing
List Price: $44.99
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. No prior experience with Tableau or programming is expected. Basic experience with a personal computer running Windows is assumed.
The Data Analytics with Excel and Tableau 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 and Tableau 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.
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.