This course will illustrate data analytics with Excel using fundamental statistical concepts (i.e., descriptive statistics, statistical inference, and regression analysis). In so doing, it offers students a jumping-off point into the world of visualizations and data-driven decision-making from a one-stop-shop software solution. Participants will become adept at tools such as Pivot Tables, the Data Analysis Toolpak, the VLOOKUP, and other formulas which are relevant and applicable to today's vast enterprises and business endeavors.
Number of Units: 2.0 graduate level extension credits in semester hours
Who Should Attend: This course provides continuing education for working professionals who have completed at a minimum a bachelor's degree or are currently enrolled in a degree program, including financial/data and/or business analysts, accountants, client relationship managers, and account managers from a wide variety of industries. Anyone interested in data analytics is also welcome.
Course Materials:
Required Applications:
Technical Requirements
Prerequisites:
This is the first of four courses in the Data Analytics and Visualization Certificate. Courses must be taken in order.
A Bachelor's degree or currently in a bachelor's program, with a basic mathematics background preferred, with at least one course, preferably, in basic statistics taken at the college level.
Once you have enrolled in your course, log in to your account to access the course Welcome Letter, which includes directions on how to access the New Student Orientation and your online course.
Participants in our Essentials of Analytics in Excel course can expect the following outcomes:
Professional development courses offered by the University of San Diego’s Division of Professional & Continuing Education are taught by faculty that possess a depth and breadth of academic and real-world professional experience.
The Professional and Continuing Education program nurtures key partnerships on the local, national, and international level. The goal is to better serve working professionals who seek to enhance or build their careers and help achieve their highest value and potential. Contact us today to learn more.
High-quality, career-building courses to choose from
In-depth, innovative, and relevant topics
Career advancing certificates
Courses offer a convenient, yet rigorous style of learning that allows you to structure your education to suit your schedule while keeping you on pace toward achieving your educational goals.
Our online self-paced courses are designed to provide flexibility and autonomy for learners. Unlike traditional classroom methods, which require attendance at scheduled times, self-paced courses allow you to progress through the material at your own speed within a six-month period from the time of enrollment. Your instructor will provide feedback via written responses on your assignments and exams. Grades are based on completed projects, assignments and exams.
Key differences from traditional classroom methods:
Structure of Online Self-Paced Courses:
The content is divided into learning modules, each covering one or more topics. Within each module, you can expect the following components:
Typically, there is a final project, paper, or exam due in the last module that synthesizes all the topics covered throughout the course. The design of the learning modules follows a consistent rhythm to help you manage your time effectively. Grades will be available within two weeks of final submission. Complimentary transcripts for EDU and CV courses will be automatically mailed out following grades being posted and approved. Please allow 3-4 weeks from when final grades are posted to receive a transcript.