Post this credential on your LinkedIn profile, resume, or CV, and don’t forget to celebrate your achievement by sharing it across your social networks or mentioning it during your performance review

Mastering Data Analysis in Excel

IT & Software

Self-paced course

Certification program

Data Analysis

Data Science

Coursera

From Nov 3, 2023

English

Advanced

Microsoft Applications

About This Specialization

Introduction to Mastering Data Analysis in Excel

Specialization Overview

Course Overview

1 week: About This Course

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 Practice

Excel Essentials

2 week: Excel Essentials for Beginners

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

Binary Classification (practice)

Binary Classification (graded)

3 week: Binary Classification

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

Using the Information Gain Calculator Spreadsheet (practice)

Information Measures (graded)

4 week: Information Measures

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

The Gaussian (practice)

Regression Models and PIG (practice)

Parametric Models for Regression (graded)

5 week: Linear Regression

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

6 week: Additional Skills for Model Building

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

7 week: Final Course Project

Mastering Data Analysis in Excel

Reviews (0)

Help other learners make their choice

Provided by

Coursera

Authored by

Duke University

Mastering Data Analysis in Excel