The x-factor in the Forecast function is any data that effects sales. This number represents, for example, the number of sales people, the Consumer Price Index, prime interest rates or mortgage rates.

In the example, Excel calculates the sum of $40 in cell D1 and $63 in cell D2 to get a total produce sales amount of $103. Advertisement Article continues below this ad ...

Excel Tutorial 1 - The formatting rules dialog box . This shows the default rules are green for the top third of values, red for the bottom third and yellow for the middle third.

A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...