Leveraging Excel for Decision Making and Data Analysis
1 hour 30 minutes
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.
• 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.