Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

Knowing how to calculate percentages in Excel can be useful for many reasons and can save you valuable time and energy in your business calculations. In this article, we will look at some ways of ...

Excel is a spreadsheet program that allows users to enter data into cells, perform calculations, and format the data visually, and is popular amongst both business owners and casual users. One of the ...

How to Find the Slope of a Line on an Excel Graph. ... The formula bar now looks similar to the following:=SLOPE(A2:A5,B2:B5)Note that the number of y and x values highlighted must be equal.

You must start with the "=" so that Excel knows you are entering a formula. It is important to know what type of data you are working with in order to select the correct forumla.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool. ... then the formula in cell D2 would be C2-B2 or C2-B2+1.

Be creative with the scatter chart. With the chart created, Excel defaults to the Design tab on the ribbon. Here, you have a choice of 11 visual styles via the Quick Layout option.