Loading...

Course Description

Learn How to Analyze Data and Real Case Problems Using the Powerful Tool of Excel

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.

Benefits of our Excel Analytics Course

There are many benefits of taking our Excel analytics course, but most participants highlight the following: 

  1. Save time and increase productivity

  2. Learn to organize data easily

  3. Handle small and big data better

  4. Sharpen your ability to identify trends

  5. Potential to improve salary

  6. Expand job prospects

  7. Sharpen your overall skillset

Learner Outcomes

Participants in our Essentials of Analytics in Excel course can expect the following outcomes: 

  • Navigate Excel's functions and formulas most often used in data/business analytics
  • Create tables and charts on the fly/ad hoc
  • Formulate and test hypotheses about a population mean and/or a population proportion
  • Identify linear relationships in data and produce regression models

Course Details

Number of Units: 2.0 graduate level extension credit(s) 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:

  1. Microsoft Excel (for analysis)

Technical Requirements

Job Market and Career Outlook

Proficiency in Excel, especially in the world of data science and data analytics, is a highly sought after skill that is often required for advancement in the field. A joint study by Capital One and Burning Glass Technologies stated that advanced digital skills — like Excel analytics — are required for 82% of middle-skill positions, and those with advanced knowledge, on average, work in higher-paying jobs. This same study found that Excel analytics proficiency increases the likelihood of promotions by 12% on average.

Employers are seeking out professionals with a strong Excel analytics skill set for a wide range of jobs. Here are some of the higher paying and growing fields that value an Excel background.

  1. Accounting

  2. Financial Analysis

  3. Project Management

  4. Business Analysis

  5. Data Journalism

  6. Market Analysis

FAQs

Q: Do courses need to be taken in sequence?

A: Yes, and this is the first course in the certificate sequence. However, you do not have to pursue the certificate and can take individual courses.

Q: How long are courses?

A: Courses take 7 weeks to complete.

Q: Are there textbooks required?

A: There is a required text and an optional text. The required textbook, Essentials of Modern Business Statistics with Microsoft Excel, 8th edition by David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Camm and James Cochran, is available at Amazon.com or your local bookstore. The optional, but recommended reading is Excel Statistics: A Quick Guide, 3rd edition by Neil Salkind, also available at Amazon.com or your local bookstore.

Q: Can I take more than one course at a time?

A: No, classes must be taken one at a time, in sequence.

Accreditation 

USD is accredited by the Western Associate of Schools and Colleges (WASC).

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.

Applies Towards the Following Certificate(s), Professional Programs and Series

Loading...
Enroll Now - Select a section to enroll in
Type
Online Fixed-Date
Dates
Jan 11, 2022 to Feb 28, 2022
Course Format
Course Fee(s)
BUS PD - $1375 credit $1,375.00
Section Fees
DAV Certificate Fee $45.00 Mandatory
Potential Discount(s)
Available for Extension Credit
2.0 units
Instructor(s)
Section Notes

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 Online Orientation and your online course.

Required fields are indicated by .