Create a forecast in Excel for Windows - Microsoft Support
When you create a forecast, Excel creates a new worksheet that contains both a table of the historical and predicted values and a chart that expresses this data. A forecast can help you …
Add or subtract dates - Microsoft Support
Add or subtract days, months, or years from a date by using a formula or date functions in Excel.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF …
IRR function - Microsoft Support
Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash …
Use sparklines to show data trends - Microsoft Support
Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its …
DATEDIF function - Microsoft Support
This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). Here's how it does this: First the DATE function creates the date, …
Change the date system, format, or two-digit year interpretation
If you enter a date with a two-digit year in a text formatted cell or as a text argument in a function, such as =YEAR("1/1/31"), Excel interprets the year as follows: 00 through 29 is interpreted as …
NPV function - Microsoft Support
Description. Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Syntax. NPV …
EDATE function - Microsoft Support
Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates …
WORKDAY function - Microsoft Support
Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Use WORKDAY to exclude weekends or holidays when you …
Add a data series to your chart - Microsoft Support
Add a data series to a chart in Excel. Show a new data series in your chart (graph) by including the series and its name in the chart source data.