Curriculum

4 Topics
About This Specialization
Introduction to Mastering Data Analysis in Excel
Specialization Overview
Course Overview

11 Topics
Introduction to Using Excel in this Course
Basic Excel Vocabulary; Intro to Charting
Arithmetic in Excel
Functions on Individual Cells
Functions on a Set of Numbers
Functions on Ordered Pairs of Data
Sorting Data in Excel
Introduction to the Solver Plug-in
Tips for Success
Excel Essentials
Excel Essentials Practice

9 Topics
Introduction to Binary Classification
Bombers and Seagulls: Confusion Matrix
Costs Determine Optimal Threshold
Calculating Positive and Negative Predictive Values
How to Calculate the Area Under the ROC Curve
Binary Classification with More than One Input Variable
Tips for Success
Binary Classification (graded)
Binary Classification (practice)

10 Topics
Quantifying the Informational Edge
Probability and Entropy
Entropy of a Guessing Game
Dependence and Mutual Information
The Monty Hall Problem
Learning from One Coin Toss Part 1
Learning From One Coin Toss Part 2
Tips for Success
Information Measures (graded)
Using the Information Gain Calculator Spreadsheet (practice)

15 Topics
Introducing the Gaussian
Introduction to Standardization
Standard Normal Probability Distribution in Excel
Calculating Probabilities from Z-scores
Central Limit Theorem
Algebra with Gaussians
Markowitz Portfolio Optimization
Standardizing x and y Coordinates for Linear Regression
Standardization Simplifies Linear Regression
Modeling Error in Linear Regression
Information Gain from Linear Regression
Tips for Success
Parametric Models for Regression (graded)
The Gaussian (practice)
Regression Models and PIG (practice)

6 Topics
Describing Histograms and Probability Distributions Functions
Some Important and Frequently Encountered PDFs
Linear Regression with More than One Input Variable
Understanding Why Over-fitting Happens
AUC Calculator Explanation and Spreadsheet
Probability AUC and Excel Linest Function

10 Topics
Final Project Information: Part 1
Final Project Information: Part 2
Final Project Information
Summary of Learning Points for Final Project: Quiz 1
Summary of Learning Points for Final Project: Quiz 2
Part 1: Building your Own Binary Classification Model
Part 2: Should the Bank Buy Third-Party Credit Information?
Part 3: Comparing the Information Gain of Alternative Data and Models
Part 4: Modeling Profitability Instead of Default
Part 5: Modeling Credit Card Default Risk and Customer Profitability

  Write a Review

Mastering Data Analysis in Excel

Go to Free Course