Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

How to Graph a Function in Excel. A mathematical function is a formula that takes an input, x, applies a set of calculations to it, and produces an output called y. By calculating a function at a ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Data selected in an Excel table, and the 2D clustered chart selected in the Insert tab on the ribbon. An Excel chart containing trend data as column, rather than a line.

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. Press "Enter." Excel displays the slope of the line in the ...

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 ...

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

How to use the FIND() function. Excel’s FIND() function parses a substring by finding the position of a specific character or string. ... In C2, enter the function =FIND(“-“,A2) ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.