Loading...

Course Description

Learn to use the included Excel Data Analysis ToolPak to make informed data-driven decisions. Understand how to do correlation, moving average, histogram, and exponential smoothing. Learn how to do regression, sampling, and rank/percentile in Excel. Create new visualizations including a tree map, box and whisker plot, waterfall, radar, and sunburst. Work with Power Query to gather your data and bring it into Excel for further analysis.

By the end of this course, you will be able to: 

  • Generate a list of descriptive statistics  

  • Create and chart a moving average  

  • Build a historgram, both with and without Pareto analysis  

  • Use a random number generator to produce arrays  

  • Explore data correlation  

  • Find predictive analysis using exponential smoothing  

  • Produce both random and periodic data samples  

  • Find the rank and percentile of a numeric array  

  • Visualize data using some advanced charts, including Waterfall, Sunburst, Treemap, Box and Whisker, and Radar

Prerequisites

Advanced Applications of Excel or equivalent experience.

Applies Towards the Following Certificates

Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .