When working with data in Excel, you will sometimes want to use formulas and functions to perform calculations on your data. Formulas are mathematical equations you can manually enter into cells to perform calcuations on your data. Functions are pre-written equations that Excel provides to help you perform simple and complex calculations more quickly.
Each formula needs to begin with the equal sign. The equal sign ( = ) instructs Excel that the information included after the equal sign should be calculated. You can enter the equal sign in the selected cell, or in the formula bar.
After you enter the equal sign, you will enter the arguments for the calculation. This can be done in a few different ways: Using static variables, using cell references, or using Excel functions.
Static Variable Formulas
Cell Reference Formulas
Formula Using Excel Functions
Once, you enter the formula arguements, click the enter key, and the result of the calculation will appear in the cell where you wrote the formula. That is it. Now you have a completed Excel formula. In the next section, we will look at how to apply a custom chart template to a new set of data.
Use your mouse to select the data you would like to include in your chart.
Once the chart data is selected, click in the Insert tab to display insert Chart options on the ribbon.
In the Chart section of the Insert tab, move you mouse to the bottom right corner, then click the See All Charts button.
In the Insert Chart window, click on the All Charts tab.
In the Chart section of the Insert tab, move you mouse to the bottom right corner, then click the See All Charts button.
Pick the template you want to use from the templates screen and click OK.
Excel will then apply the template formatting to the new chart.
Topic #2
How to Use AutoFill in Excel
Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Excel Chart tutorials, or consider taking an Excel class with one of our professional trainers.