Doing Data Analytics In Excel (Hands-on module) 1 CPE

Excel is a versatile tool that can be used for a lot of advanced data analysis projects; if you know how to use the various supplemental add-ons and features. This in-depth course walks participants through the critical elements of performing advanced analysis in Excel. The focus is on allowing participants to follow along and actually perform the analysis as the instructor is doing it.

By the end of the course, participants will be equipped to perform complex analysis on a variety of types of data and draw inferences based on the data to make business decisions effectively.

***Please download and open all supporting materials before starting the course videos.***

Prerequisites

Viewers should be familiar with basic financial and accounting concepts. In addition, viewers should be familiar with Big Data and Business Intelligence, or review my existing courses on the topic. Familiarity with and access to Excel will be helpful.

Learning Objective

• Explore how to gather and clean a compiled dataset from disparate sources
• Explore how to identify and flag outliers in data
• Explore how to compute correlations between variables
• Discover how to turn non-numerical qualitative data into numerical data that can be effectively analyzed with statistics
• Discover how to perform basic regressions in Excel for use in finding hidden relationships between business decisions
• Discover how to run t-tests and other statistics to make informed business decisions based on data

Last updated/reviewed: July 19, 2025