Learn the basic concepts of data analysis and descriptive statistics. Learn how to manipulate, analyze and visualize data in Excel and Google Sheets. Learn about business metrics across a wide range of business areas (marketing, sales, growth and finance). Finally, learn about forecasting sales and financial metrics.
Overview
Syllabus
- Descriptive Statistics - Part I
- In this lesson, you will learn about data types, measures of center, and the basics of statistical notation.
- Descriptive Statistics - Part II
- In this lesson, you will learn about measures of spread, shape, and outliers as associated with quantitative data. You will also get a first look at inferential statistics.
- Spreadsheets 1: Getting Started
- In this lesson, you will learn about the basic functionality for spreadsheet software, use cell referencing and menu shortcuts.
- Spreadsheets 2: Manipulate Data
- In this lesson, you will learn basic spreadsheet function: sort and filter data, use text and math functions, split columns and remove duplicates.
- Spreadsheets 3: Analyze Data
- In this lesson, you will learn how to summarize data with aggregation and conditional functions. You will learn how to use pivot tables and lookup functions.
- Spreadsheets 4: Visualize Data
- In this lesson you will build data visualizations for quantitative and categorical data; create pie, bar, line, scatter, histogram, and boxplot charts, and build professional presentations.
- Business Metrics
- This lesson will cover how to calculate business metrics used by business analysts across a range of business functions. You will also learn how to calculate and interpret key performance metrics.
- Excel Modeling
- This lesson will cover the fundamentals of sales and financial forecasting models. You will learn how to create forecast models using advanced lookup and data validation tools in Excel and Sheets.
- Project: Analyze NYSE Data
- In this project, you will use a data set containing financial performance data from companies listed in NYSE S&P to create an income statement and forecast financial metrics.
Taught by
Dana Sheahan - color, Josh Bernhard_color and Ruchi Bhanot_color
