<< Back
IMA Excel: Data Analytics - Data Analytics Combo Package
Join renowned Excel expert Bill Jelen (Mr. Excel) as he walks you through leveraging the power of Excel to perform complex data analytics.
Note: This course is designed and instructed using features found in Excel 2013, Excel 2016, and Excel 365. Working in these platforms will be necessary to duplicate course contents.
Publisher
IMA
Description
Excel course on performing prescriptive analytics using predictive analytic Excel tools. Presented by renowned Excel expert, Bill Jelen (Mr. Excel), these courses cover:
- an introduction to value creation using descriptive, diagnostic, predictive, and prescriptive techniques,
- pivot tables
- graphing
- Excel artificial intelligence
- customer segmentation analysis methods
- what-if analyses
- multi-variable regression
- forecasting using exponential trend smoothing and model building to predict future sales.
- using moving averages for forecasting
- leveraging the power of the Excel solver tool
- developing Monte Carlo simulations using Excel
This self-study, video based course includes downloadable practice spreadsheets that enable users to replicate functionality and practice these valuable new Excel skills to perform their own prescriptive analytics.
Note: This course is designed and instructed using features found in Excel 2013, Excel 2016, and Excel 365. Working in these platforms will be necessary to duplicate course contents.
Courses in package:
| Title | Credit(s) | Field of Study | Expiration | |
|---|---|---|---|---|
| 1 | CPE:3.5 | Computer and Software Applications | ||
| 2 | CPE:3.0 | Computer and Software Applications |