Leveraging Excel for Decision Making and Data Analysis

$199.00

SKU: 406877

Description

Learn how to utilize Excel for data analysis including forecasting, regression functions, and more.
Microsoft Excel is a great tool for creating spreadsheets. The key is how to interpret those numbers in that spreadsheet, and data analysis is a hidden gem in this program. This topic will provide information about data analysis, such as forecasting, rank and percentile, and regression functions. You will also learn about decision trees and how they can help move ideas and changes along. Another data analytic tool that is used across many corporations is Monte Carlo. This information will show what it is and how it is used.

Date: 2020-07-24 Start Time: 1:00 PM ET End Time: 2:30 PM ET

Learning Objectives

* You will be able to define decision trees.

* You will be able to describe data analysis.

* You will be able to explain the Monte Carlo Simulation.

* You will be able to review examples of data analysis tool use.

Data Analysis
• What Is It?
• Why Do We Want to Know About It?
• A Look at Data Analysis Tool Pack
• Examples of Data Analysis Tool Use
• Forecasting
• Histogram
• Rank and Percentile
• Regression

Decision Trees
• What Is It?
• How Do We Do It?
• Examples of Decision Trees

Monte Carlo Simulation
• What Is a Random Number?
• Why Use Random Generation?
• Why Monte Carlo?
• Examples of How Monte Carlo Is Used

AIPB ,ASAP PACE ,CPE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Jill A. Trehearne-FatDAWGS.com