The virtual course "Master data analysis in Excel - Virtual Course - Coursera", is a course with different contents and that offers video classes of Approx. 21 hours to complete. Explore its essential features, and click the orange button to get detailed information on the Coursera e-Learning platform
Important: The focus of this course is on mathematics, specifically data analysis concepts and methods, not on Excel itself.
We use Excel to do our calculations, and all mathematical formulas are given as Excel spreadsheets, but we do not attempt to cover Excel macros, Visual Basic, Pivot Tables, or other intermediate to advanced Excel functionality.
This course will prepare you to design and implement realistic predictive models based on data.
In the Capstone Project (Module 6), you will assume the role of a business data analyst for a bank and develop two different predictive models to determine which credit card applicants should be accepted and which should be rejected.
Your first model will focus on minimizing the risk of default and the second on maximizing the bank's profits.
The two models should practically and practically demonstrate to you the idea that your choice of business metric drives your choice of an optimal model.
The second big idea that this course seeks to demonstrate is that the results of your data analysis cannot and should not aim to eliminate all uncertainty.
Your role as a data analyst is to reduce uncertainty for decision makers into a financially valuable increment, while quantifying how much uncertainty remains.
You will learn how to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, information entropy, and confidence intervals for linear regression.
All the data you need is provided within the course, all tasks are designed to be done in MS Excel, and you will learn enough Excel to complete all tasks.
The course will give you enough practice with Excel to master the most commonly used business functions and you will be ready to learn any other Excel functionality you may need in the future (Module 1).
The course does not cover Visual Basic or PivotTables and you will not need them to complete the assignments.
All of the advanced concepts are shown in individual Excel spreadsheet templates that you can use to answer relevant questions.
You will leave with a substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (Module 2), information theory and entropy measures (Module 3), and linear regression (Modules 4 and 5), all without using software tools more complex than Excel.
and you'll be ready to learn any other Excel functionality you may need in the future (Module 1).
The course does not cover Visual Basic or PivotTables and you will not need them to complete the assignments.
All of the advanced concepts are shown in individual Excel spreadsheet templates that you can use to answer relevant questions.
You will leave with a substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (Module 2), information theory and entropy measures (Module 3), and linear regression (Modules 4 and 5), all without using software tools more complex than Excel.
and you'll be ready to learn any other Excel functionality you may need in the future (Module 1).
The course does not cover Visual Basic or PivotTables and you will not need them to complete the assignments.
All of the advanced concepts are shown in individual Excel spreadsheet templates that you can use to answer relevant questions.
You will leave with a substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (Module 2), information theory and entropy measures (Module 3), and linear regression (Modules 4 and 5), all without using software tools more complex than Excel.
All of the advanced concepts are shown in individual Excel spreadsheet templates that you can use to answer relevant questions.
You will leave with a substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (Module 2), information theory and entropy measures (Module 3), and linear regression (Modules 4 and 5), all without using software tools more complex than Excel.
All of the advanced concepts are shown in individual Excel spreadsheet templates that you can use to answer relevant questions.
You will leave with a substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (Module 2), information theory and entropy measures (Module 3), and linear regression (Modules 4 and 5), all without using software tools more complex than Excel.
Prepare yourself from home with the most prestigious universities in the world.
The quality of Coursera's courses is supported by its instructors, who are often deans and have doctorates.
More than 85% of Coursera students report career benefits, such as promotions or salary increases.
Millions of students around the world are meeting their personal and professional goals with Coursera.
Coursera offers courses from over 200 leading universities and companies to deliver online learning around the world. With a Coursera Plus subscription, you get unlimited access to over 90% of all courses, and the most popular professional certificates and specializations on Coursera.
Data science, business and personal development. You can enroll in multiple courses at once, earn unlimited certificates, and learn in-demand job skills to start, grow, and even change careers.
DISCOVER HOW TO GET THE MOST, AND SAVE OVER USD $500 WITH AN ANNUAL SUBSCRIPTION TO COURSERA PLUS*
*You save up to USD$500 in 12 months, when you go from paying USD$59 for a monthly subscription, to an annual subscription with the promotion. The normal annual subscription is USD $399. With the promotion you will only pay USD $299. Find out everything by clicking the yellow button.
Duke University
Hello how can I help you? Are you interested in a course? About what subject?
Add a review