Mastering Data Analysis in Excel
Understand concepts and methods of data analysis to design and then implement predictive models that are realistic with this Mastering Data Analysis.
Online
3 Weeks
4,115 INR Get updates on Eligibility, Admission, Placements Fees Structure
Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Course Overview
Mastering Data Analysis in Excel certification is an online course that is offered with a collaborative effort of Duke University, and Coursera. The main focus of this Excel to MySQL: Analytic Techniques for Business Specialization, 6 weeks course is only data analysis and not Excel. Excel along with mathematical calculations are performed but other intermediaries or advanced concepts like a pivot table in Excel are not covered.
Mastering Data Analysis in Excel training will help the candidates design and put predictive models to use. Later on, with this course, a participant will be assuming a business data analyst’s role in a bank. This will teach them to reduce default risks, and then maximize the profits of a bank in various ways. The curriculum is a mix of practical, and also theoretical ways that will help develop ideas related to their choice of business. Any data that the candidates are provided for their assignments will be completed only using MS Excel so that they get to practice, and become familiar, and fluent with business functions in Excel.
The Highlights
- 3 weeks programme
- 100% online course
- 21 hours of classes
- Beginner level course
- Self-learning course
- 9 subtitles available
- Certificate by Coursera
Programme Offerings
- Online Course
- Shareable Certificate
- Flexible Deadlines
- Graded Assignments
- English Course
- 9 Subtitles Available
- Lectures
- videos
- Readings
- Practice Exercises
- Discussion Forums.
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | Coursera |
The Mastering Data Analysis in Excel certification fee is Rs. 4,085 that includes certificates, and unlimited access to the particular specialization. After enrollment, during the first week, everything is accessible for free. The fee then starts to get charged on a subscription basis which is monthly.
Mastering Data Analysis in Excel Fee Structure
Course name | Fee in INR |
| Audit mode | Free |
Mastering Data Analysis in Excel (1 month) | Rs. 4,115 |
| Mastering Data Analysis in Excel (3 months) | Rs. 8,230 |
| Mastering Data Analysis in Excel (6 months) | Rs. 12,345 |
Eligibility Criteria
Educational Qualification
Languages like Spanish, English, German, Vietnamese, Russian, Italian, Portuguese (European), and Arabic, French, if known by the candidates may be helpful.
Certification Qualifying Details
Finishing 5 weeks of learning, and the final 6th-week quiz and the peer assessment will ensure the Mastering Data Analysis in Excel certification by Coursera to its successful applicants.
What you will learn
Mastering Data Analysis in Excel certification syllabus encompasses the following:
- Mastering the knowledge related to data analysis concepts using Microsoft Excel features.
- Data analysis results must not be considered by all decision-makers for eliminating uncertainty.
- Candidates can learn to calculate, and then apply real-world examples for important uncertainty measures that can be used in businesses.
Who it is for
The course is very much suitable for anyone who requires a better understanding related to how the best marketplace decisions are made using data management process in Excel,
Admission Details
The Mastering Data Analysis in Excel admission process is as follows:
Step 1: Visit the official website: https://www.coursera.org/learn/analytics-excel
Step 2: The button ‘Join For Free’, which is situated on the home page right corner must be clicked by the participants.
Step 3: During the 3rd step, a necessary thing to be done by the participants is making Coursera accounts.
Step 4: Fourthly, candidates will have to start with fee payment, and opt for financial aid.
Step 5: Admission is given as the above four steps are done.
Application Details
Applying to the Mastering Data Analysis in Excel online course requires just a few minutes time provided the candidates have proper internet connectivity. Candidates are asked to use their personal or professional email addresses for signing up with Coursera.
The Syllabus
Videos
- About This Specialization
- Introduction to Mastering Data Analysis in Excel
Readings
- Specialization Overview
- Course Overview
Videos
- 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
Reading
Tips for Success
Assignments
- Excel Essentials Practice
- Excel Essentials
Videos
- 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
Readings
- Tips for Success
Assignments
- Binary Classification (practice)
- Binary Classification (graded)
Vidoes
- 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
Reading
Tips for Success
Assignments
- Using the Information Gain Calculator Spreadsheet (practice)
- Information Measures (graded)
Videos
- 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
Readings
- Tips for Success
Practice Exercises
- The Gaussian (practice)
- Regression Models and PIG (practice)
- Parametric Models for Regression (graded)
Assignments
- Parametric Models for Regression (graded)
- The Gaussian (practice)
- Regression Models and PIG (practice)
Videos
- 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
Reading
AUC Calculator Explanation and Spreadsheet
Assignment
Probability, AUC, and Excel Linest Function
Videos
- Final Project Information: Part 1
- Final Project Information: Part 2
Readings
- Final Project Information
- Summary of Learning Points for Final Project: Quiz 1
- Summary of Learning Points for Final Project: Quiz 2
Assignments
- 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
Peer Review
- Part 5: Modeling Credit Card Default Risk and Customer Profitability
Evaluation process
During the final week, a student has to attend 10-12 hours of peers assessment, and a final quiz for earning the completion certificate.
Instructors
Articles
Student Community: Where Questions Find Answers