Skip to Content

Microsoft® Excel: Data Analytics Advanced charts and control

Format:

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.

Available Formats