Mastering Data Analysis in Excel

Description

In business, data and algorithms create economic value when they reduce uncertainty about financially important outcomes. This course teaches the concepts and mathematical methods behind the most powerful and universal metrics used by Data Scientists to evaluate the uncertainty-reduction – or information gain – predictive models provide. We focus on the two most common types of predictive model – binary classification and linear regression – and you will learn metrics to quantify for yourself the exact reduction in uncertainty each can offer. These metrics are applicable to any form of model that uses new information to improve predictions cast in the form of a known probability distribution – the standard way of representing forecasts in data science. In addition, you will learn proper methodology to avoid common data-analytic pitfalls when forecasting – such as being “fooled by randomness” and over-fitting “noise” as if it were “signal.” Uniquely among data-analytics offerings, this course empowers you to understand and apply quite advanced information theory methods – Bayesian Logical Data Analysis – in business practice, without needing any calculus or matrix algebra, or any knowledge of Matlab or R or software programming. You will be able to answer all homework and quiz questions either by using basic algebra, or with the special custom Microsoft Excel Templates provided. Nor is any prior experience with Excel required; we will cover in detail at the beginning everything you need to know about using Excel to succeed in the course itself. If you already know Excel, you can skip that part. Be aware that this is not a broad general Excel skills course; it focuses on use of Excel to calculate information-related metrics, and to solve real business problems, such as developing your own predictive analytics model for which credit card applicants a bank should accept and which reject as too risky. Real problems are complicated! Personally I think learning to solve real problems is also a great way to learn Excel. We use specific tools in the Excel toolbox to build something useful, and you can always go back and learn more tools in the toolbox – more Excel functions – if and when you ever need them. This course requires some mathematical background: you should already know how to solve for an unknown using algebra; and have a basic familiarity with sigma (summation) notation; the concept of logarithms and working with bases other than base 10 (including base 2, and the natural logarithm and base “e”); and probability theory concepts such as calculating conditional, product, and joint probabilities. These concepts are assumed in the course rather than taught. All the “new” math taught in the course is summarized in a downloadable PDF document – “Mathematical Supplement” – please refer to it to decide if the difficulty level of this course seems right for you.



More Ways to Learn Microsoft Excel

Excel 2016 Bible

7th - College | Book, ebook/Kindle

The complete guide to Excel 2016, from Mr. Spreadsheet himself. Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel...

$30

Excel 2016 Essential Training

7th - College | Online class

Start mastering Excel, the world’s most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple...

$25 monthly

Excel Tutorials

College | Online resource

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to...

Free

The 5-Day Excel Challenge

7th - College | Online class

Take this fun and fast 5-day Excel challenge to test and build your Excel skills. The challenges are based on the questions that Excel expert Dennis Taylor encounters most often, and they grow...

$25 monthly

Analyzing and Visualizing Data with Excel

7th - College | Online class

Microsoft Excel is one of the most widely used solutions for analyzing and visualizing data. Beginning with Excel 2010, new tools were introduced to enable the analysis of more data, resulting in...

Free
Offers paid add-ons

Improve Your Microsoft Excel Skills

College | Online class

Improve Your Microsoft Excel Skills Increase the number skills you have and improve your spreadsheet expertise by expanding your use of the versatile features in Microsoft Excel. Learn how to work...

$20 monthly
Offers paid add-ons

PRDV004: Spreadsheets

College | Online class

This course will provide you with a comprehensive introduction to spreadsheets. The course is designed for first-time users with very little or no exposure to the subject. For this course, you will...

Free

Excel 2016 Tutorial

6th - College | Online resource, Online video/YouTube

Microsoft Excel 2016 is the spreadsheet application in the MS Office 2016 suite. Get help organizing and calculating data in this Excel 2016 tutorial. Excel 2016 Basics 1 Getting Started with Excel...

Free

MrExcel.com

High School - College | Online resource

A resource collection and online community dedicated to Excel since 1998, the MrExcel.com community answers 30,000 Excel-related questions per year on their message boards, and offers seminars and...

Free

Excel for Finance

College | Online class

THROUGH THIS ONLINE COURSE, YOU’LL… Benefit from expert advice, in simple language, from an accomplished financial analyst Discover which Excel functions financial experts use daily (and which ones...

$50

See all resources for Microsoft Excel