Introduction to Monte Carlo simulation in Excel
Monte Carlo simulations model the probability of different outcomes. You can identify the impact of risk and uncertainty in forecasting models.
FORECAST and FORECAST.LINEAR functions - Microsoft Support
This article describes the formula syntax and usage of the FORECAST.LINEAR and FORECAST functions in Microsoft Excel. Note: In Excel 2016, the FORECAST function was replaced with FORECAST.LINEAR as part of the new Forecasting functions.
TREND function - Microsoft Support
The TREND function returns values along a linear trend. It fits a straight line (using the method of least squares) to the array's known_y's and known_x's. TREND returns the y-values along that line for the array of new_x's that you specify.
Change the format of data labels in a chart - Microsoft Support
You can format the labels to show specific labels elements like, the percentages, series name, or category name. Windows macOS. There are a lot of formatting options for data labels. You can use leader lines to connect the labels, change the shape of the label, and resize a data label.
Create a chart with recommended charts - Microsoft Support
Excel will add some sample data to your worksheet, analyze it, then add recommended charts to the pane. Follow the steps in the Get Started section to insert any of the recommended Pivot Charts or charts.
Create a memory-efficient Data Model using Excel and the …
Data models in Excel use the in-memory analytics engine to store data in memory. The engine implements powerful compression techniques to reduce storage requirements, shrinking a result set until it is a fraction of its original size.
Calculate the average of a group of numbers - Microsoft Support
Find the average of a group of numbers by clicking the AutoSum button to use the Average function, or use the Average and the AverageIF functions in formula to find the average of a group of numbers.
Tutorial: Import Data into Excel, and Create a Data Model
In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. The tutorials in this series are the following: Import Data …
Calculate the difference between two dates - Microsoft Support
Calculate the difference between two dates. Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
PERCENTILE.EXC function - Microsoft Support
The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. The array or range of data that defines relative standing. If k is nonnumeric, PERCENTILE.EXC returns the #VALUE! error value.
PERCENTILE function - Microsoft Support
Syntax. PERCENTILE (array,k) The PERCENTILE function syntax has the following arguments: array Required. The array or range of data that defines relative standing. k Required. The percentile value in the range 0..1, inclusive. Remarks. If k is non-numeric, PERCENTILE returns the #VALUE! error value.