Format: On-demand
This course will be an overview of:
- Learn to create Excel’s data analysis capabilities to describe and draw insights from data.
Becker’s Microsoft® Excel Series features Wayne Winston, Microsoft® Press author for more than a decade with 40 teaching awards for his instruction. Wayne is sought out by many of the Big 4 and larger corporations to bring their personnel to a level playing field with Microsoft® Excel, necessary today for success in the accounting profession.
Wayne’s success as a Microsoft® Excel instructor is closely tied to his teaching style that has students watch and then do realistic, engaging problems in the software. Students learn through using Microsoft® Excel to cement their understanding before progressing to the next building block.
Learning Objectives
After completing this course, the learner should be able to:
- Learn to graphically summarize data with Histograms and Box Plots.
- Learn descriptive statistics used to summarize data on central location, spread and skewness.
- Understand how to spot outliers.
- Learn to use PERCENTILE.EXC, PERCENTRANK.EXC, RANK, LARGE and SMALL functions.
- Learn how to take a random sample from a data set.
- Understand random variables. Learn how to compute mean, variance and standard deviation.
- Learn how to compute probabilities and percentiles for the normal random variable.
- Understand how to use Z-scores to measure how atypical a data point is.
- Learn how correlation summarizes linear association between two variables.
- Learn how to use simple linear regression to estimate the relationship between two variables.