Add a whole column of numbers. If you want to add all of the numbers in a whole column (or in a section of a column), type =SUM(cell:cell) (e.g., =SUM(A1:A12)) into the cell you want to use to display the result.
How to Use Excel Picture 16
Select a cell for an advanced formula. To use a more advanced formula, you'll use the Insert Function tool. Start by clicking the cell in which you want to display your formula.
How to Use Excel Picture 17
Click Formulas. It's a tab at the top of the Excel window.
How to Use Excel Picture 18
Click Insert Function. This option is in the far-left side of the Formulas toolbar. Doing so opens a window.
How to Use Excel Picture 19
Select a function. Click in the window the function you want to use, then click OK.
For example, to select the formula for finding the tangent of an angle, you would scroll down and click the TAN option.
How to Use Excel Picture 20
Fill out the function's form. When prompted, type in the number (or select a cell) for which you want to use the formula.
For example, if you select the TAN function, you'll type in the number for which you want to find the tangent.
Depending on your selected function, you may need to click through a couple of on-screen prompts.
How to Use Excel Picture 21
Press ↵ Enter. Doing so applies your function and displays it in your selected cell.
Part 4 of 5:
Creating Charts
How to Use Excel Picture 22
Set up the chart's data. If you're creating a line graph or a bar graph, for example, you'll want to use one column of cells for the horizontal axis and one column of cells for the vertical axis.
Typically speaking, the left column is used for the horizontal axis and the column immediately to the right of it represents the vertical axis.
How to Use Excel Picture 23
Select the data. Click and drag your mouse from the top-left cell of the data down to the bottom-right cell of the data.
How to Use Excel Picture 24
Click Insert. It's a tab at the top of the Excel window.
How to Use Excel Picture 25
Click Recommended Charts. You'll find this option in the "Charts" section of the Insert toolbar. A window with different chart templates will appear.
How to Use Excel Picture 26
Select a chart template. Click the chart template you want to use.
How to Use Excel Picture 27
Click OK. It's at the bottom of the window. Doing so creates your chart.
How to Use Excel Picture 28
Edit your chart's title. Double-click the title at the top of the chart, then delete and replace the chart's current title with your own title.
How to Use Excel Picture 29
Change your chart's axis titles. If you want to add axis titles to the chart, you can do so from the "Chart Elements" menu which is accessed by clicking the green + to the right of the selected chart.
Part 5 of 5:
Saving an Excel Project
How to Use Excel Picture 30
Click File. It's in the upper-left side of the Excel window (Windows) or the screen (Mac). A menu will appear.
How to Use Excel Picture 31
Click Save As. This is on the left side of the page if you're using Windows.
On a Mac, you'll click this in the File drop-down menu.
How to Use Excel Picture 32
Double-click This PC. It's in the middle of the page.
On Mac, click On my Mac instead.
How to Use Excel Picture 33
Enter a name for your project. Type whatever you want to name your spreadsheet into the "File name" (Windows) or "Name" (Mac) text box in the Save As window.
How to Use Excel Picture 34
Select a save folder. Click the folder in which you want to save your spreadsheet.
On a Mac, you may first need to click the "Where" drop-down box before you can select a file.
How to Use Excel Picture 35
Click Save. It's at the bottom of the window. Doing so saves your spreadsheet in the selected folder under the specified name.
How to Use Excel Picture 36
Save future edits with the "Save" keyboard shortcut. If you're editing the Excel document in the future, pressing Ctrl+S (Windows) or ⌘ Command+S (Mac) will save your changes to the document without bringing up the Save As window.