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...
Enroll Now - Select a section to enroll in
Section Title
Excel Data Analysis
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Section Title
Excel Data Analysis
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Section Title
Excel Data Analysis
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Jun 28, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 26, 2024
Transfer Request Deadline
Jun 26, 2024
Section Title
Excel Data Analysis
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Jun 28, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 26, 2024
Transfer Request Deadline
Jun 26, 2024
Required fields are indicated by .