Mastering Data Analysis in Excel Coursera

Overview

This Mastering Data Analysis in Excel course offered by Coursera in partnership with Duke University focuses on essential data analysis using Excel. 

In a hands-on project, you'll act as a business data analyst, building models to assess credit card applications, minimize default risk and maximize bank profits. 

You'll master key uncertainty measures like classification error rates, entropy of information, and confidence intervals for linear regression. 

Assignments use data provided within the course and basic Excel functions, ensuring fluency for future business applications. No prior knowledge of advanced Excel features (Visual Basic, Pivot Tables) is required. 

The Excel and data analysis skills you will learn will enable you to apply business data analysis methods based on binary classification, information theory and entropy measures, and linear regression, and prepare you for roles such as a business data analyst.

What you'll learn

• Design and implement realistic predictive models to reduce uncertainty for informed business decisions.
• Apply business data analysis methods based on binary classification, information theory and entropy measures, and linear regression.
• Calculate and apply to real-world examples important uncertainty measures used in business.