Essentials of Analytics in Excel

Course Available
2 Units
Online Fixed-Date

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.

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

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.

Course Options

Course Date Units Price
DAV-X800 – 006 10 Jan 202327 Feb 2023 2 $1375

Essentials of Analytics in Excel

10 Jan 202327 Feb 2023
2
$1375
Online Fixed-Date
Online
Isabella Oakes

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.

What You Will Learn

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

Instructors

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.

Why USD?

PCE nurtures key partnerships on the local, national and international level to better serve working professionals who seek to enhance or build their careers, as well as with their employers to help achieve their highest value and potential. Contact us today to learn more.

Informative Stats and Facts

600+

Number of high-quality, career-building courses to choose from

50+

Number of in-depth, innovative, and relevant topics

25+

Career advancing certificates

Learning Method Information

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.

Online Fixed-Date

Online Fixed-Date: Online fixed-date courses offer a convenient, yet rigorous style of learning that enables you to collaborate with your instructor and other students in a shared, online learning environment. These courses have fixed start and finish dates, but as an online student you will have 24/7 online access to your classroom assignments, syllabus and course resources. Our online fixed-date courses allow you to work on your assignments anytime, although you are required to complete the assignments by specific dates.

How is the learning structured? In an online fixed-date course, you and your classmates will proceed through the curriculum together, collaborating in a shared learning experience. Each online fixed-date course is asynchronous, meaning that you can work on your assignments anytime, although required to complete the assignments by specific dates. The course is designed with seven learning modules where all of the content is grouped into weekly assignments. Each module covers one or more topics. Within each of the learning modules, you can expect the following components:

  • Module introduction that outlines what you can expect to learn in the module.
  • Required readings (textbook, articles, journals, etc.) and presentations (audio and/or video).
  • Assignments with due dates (which may include: written assignments, journal entries, research, blogs, etc.) based on the readings and presentations.
  • Discussion forum where you answer prompts from the instructor and interact with your classmates.
  • Module conclusion to review the topics and what you should have learned.
  • Typically, there is a final project, paper, or exam due in the last module that culminates all of the topics covered in each of the learning modules. You’ll find that the design of the learning modules has a rhythm to help you manage your time in the course.