Save for later

Learning Excel

Master Excel for Data Science,

Microsoft Excel is an important tool for data analysis. It helps companies accurately assess situations and make better business decisions. This course helps you unlock the power of your organization's data using the data analysis and visualization tools built into Excel. Author Curt Frye starts with the foundational concepts, including basic calculations such as mean, median, and standard deviation, and provides an introduction to the central limit theorem. He then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. Finally, he reviews the process of calculating Bayesian probabilities in Excel. Each chapter includes practical examples that show how to apply the techniques to real-world business problems.

Contents:

  • Introduction
  • 1. Foundational Concepts of Data Analysis
  • 2. Visualize Data
  • 3. Test a Hypothesis
  • 4. Utilize Data Distributions
  • 5. Measure Covariance and Correlation
  • 6. Perform Bayesian Analysis
  • Conclusion

Get Details and Enroll Now

OpenCourser is an affiliate partner of LinkedIn Learning and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating Not enough ratings
Length 2h 9m
Starts On Demand (Start anytime)
Cost $29/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Curt Frye
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Data Science IT & Networking Business
Tags Data Analysis IT Business Intelligence Microsoft Excel

Get a Reminder

Send to:

Similar Courses

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Institutional Research Specialist in Data Analysis $42k

Professional-Data Analysis - SQL $63k

Business and Data Analysis $67k

Data Management and Analysis Fellowship - CDC $68k

Data Analyst, Marketing & Analysis $68k

Senior Data Analyst, Marketing & Analysis $77k

Data Scientist (Social Network Analysis) $84k

Analyst, R&D IT and Data Analysis Lead $88k

Data Management and Analysis Tech. $94k

Senior Data Analysis - ITSM Analyst $101k

Senior Data Analysis Engineer u2013 Engineering Data Analysis $149k

Data Architect - Financial Planning and Analysis $156k

Write a review

Your opinion matters. Tell us what you think.

Rating Not enough ratings
Length 2h 9m
Starts On Demand (Start anytime)
Cost $29/month (Access to entire library- free trial available)
From LinkedIn Learning
Instructor Curt Frye
Download Videos Only via the LinkedIn Learning mobile app
Language English
Subjects Data Science IT & Networking Business
Tags Data Analysis IT Business Intelligence Microsoft Excel

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now