How to Use Excel

This wikiHow teaches you how to set up and use Microsoft Excel on your Windows or Mac computer. Install Microsoft Office if you don't have it. Microsoft Excel isn't available as a standalone program, but it is included in a Microsoft...

Part 1 of 5:

Preparing to Use Excel

Picture 1 of How to Use Excel

Install Microsoft Office if you don't have it. Microsoft Excel isn't available as a standalone program, but it is included in a Microsoft Office package or subscription.
Picture 2 of How to Use Excel
Open an existing Excel document. If you want to open an existing Excel document at any time, simply double-click the document in question. This will bring up the document in an Excel window.
1. Skip this step if you want to open a new document in Excel.
Picture 3 of How to Use Excel

Open Excel. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
Picture 4 of How to Use Excel
Select a template if necessary. If you want to use an Excel template (e.g., a budget planner template), scroll down until you find the template you want to use and then click it once to open its window.
1. If you just want to open a new blank Excel document, click the Blank option in the upper-left side of the page and then skip the next step.
Picture 5 of How to Use Excel

Click Create. It's to the right of the template's name.
Picture 6 of How to Use Excel

Wait for the Excel workbook to open. This will take a few seconds. Once you see the Excel template or blank page, you can proceed with entering your sheet's data.

Part 2 of 5:

Entering Data

Picture 7 of How to Use Excel
Familiarize yourself with the Excel ribbon tabs. In the green "ribbon" at the top of the Excel window, you'll see a series of tabs. Each of these tabs can be used to access different Excel tools; the main ones you'll need to know include the following:
1. Home — Contains options for formatting text, changing cell background color, and so on.
2. Insert — Contains options for tables, charts, graphs, and equations.
3. Page Layout — Contains options for page margins, orientation, and themes.
4. Formulas — Contains various formula options as well as a function menu.
Picture 8 of How to Use Excel

Consider using the top row of cells for headers. When adding data to a blank spreadsheet, you can use the top cell in each column (e.g., A1, B1, C1, etc.) as your column heading. This is helpful when creating graphs or tables which require labels.
Picture 9 of How to Use Excel
Select a cell. Click the cell into which you want to enter data.
1. For example, if you're using a budget-planning template, you might click the first empty cell to select it.
Picture 10 of How to Use Excel

Enter text. Type in whatever you want to add to the cell.
Picture 11 of How to Use Excel

Press ↵ Enter. Doing so adds it to the cell and moves your selection to the next available cell.
Picture 12 of How to Use Excel

Edit your data. To go back and edit data later, click the cell you want to edit, then change whatever you need to change in the text box above the top row of cells.
Picture 13 of How to Use Excel
Format text if necessary. If you want to change the way a cell's text is formatted (e.g., if you want to change it from money formatting to date formatting), click the Home tab, click the drop-down box at the top of the "Number" section, and click the type of formatting you want to use.
1. You can also use conditional formatting to cause your cells to change based on factors in the spreadsheet (e.g., if a cell's value is below a certain number, the cell might turn red).

Part 3 of 5:

Using Formulas

Picture 14 of How to Use Excel

Select a cell for your formula. Click the cell in which you want to create a formula.
Picture 15 of How to Use Excel
Perform basic operations. You can add, subtract, divide, and multiply cell values with the following formulas:
1. Add — Type =SUM(cell+cell) (e.g., =SUM(A3+B3)) to add two cells' values together, or type {{kbd|=SUM(cell,cell,cell) (e.g., =SUM(A2,B2,C2)) to add a series of cell values together.
2. Subtract — Type =SUM(cell-cell) (e.g., =SUM(A3-B3)) to subtract one cell value from another cell's value.
3. Divide — Type =SUM(cell/cell) (e.g., =SUM(A6/C5)) to divide one cell's value by another cell's value.
4. Multiply — Type =SUM(cell*cell) (e.g., =SUM(A2*A7)) to multiply two cell values together.
License: Fair Use (screenshot)
n

"}

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.
Picture 16 of How to Use Excel

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.
Picture 17 of How to Use Excel

Click Formulas. It's a tab at the top of the Excel window.
Picture 18 of How to Use Excel

Click Insert Function. This option is in the far-left side of the Formulas toolbar. Doing so opens a window.
Picture 19 of How to Use Excel
Select a function. Click in the window the function you want to use, then click OK.
1. For example, to select the formula for finding the tangent of an angle, you would scroll down and click the TAN option.
Picture 20 of How to Use Excel
Fill out the function's form. When prompted, type in the number (or select a cell) for which you want to use the formula.
1. For example, if you select the TAN function, you'll type in the number for which you want to find the tangent.
2. Depending on your selected function, you may need to click through a couple of on-screen prompts.
Picture 21 of How to Use Excel

Press ↵ Enter. Doing so applies your function and displays it in your selected cell.

Part 4 of 5:

Creating Charts

Picture 22 of How to Use Excel
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.
1. Typically speaking, the left column is used for the horizontal axis and the column immediately to the right of it represents the vertical axis.
Picture 23 of How to Use Excel

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.
Picture 24 of How to Use Excel

Click Insert. It's a tab at the top of the Excel window.
Picture 25 of How to Use Excel

Click Recommended Charts. You'll find this option in the "Charts" section of the Insert toolbar. A window with different chart templates will appear.
Picture 26 of How to Use Excel

Select a chart template. Click the chart template you want to use.
Picture 27 of How to Use Excel

Click OK. It's at the bottom of the window. Doing so creates your chart.
Picture 28 of How to Use Excel

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.
Picture 29 of How to Use Excel

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

Picture 30 of How to Use Excel

Click File. It's in the upper-left side of the Excel window (Windows) or the screen (Mac). A menu will appear.
Picture 31 of How to Use Excel
Click Save As. This is on the left side of the page if you're using Windows.
1. On a Mac, you'll click this in the File drop-down menu.
Picture 32 of How to Use Excel
Double-click This PC. It's in the middle of the page.
1. On Mac, click On my Mac instead.
Picture 33 of How to Use Excel

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.
Picture 34 of How to Use Excel
Select a save folder. Click the folder in which you want to save your spreadsheet.
1. On a Mac, you may first need to click the "Where" drop-down box before you can select a file.
Picture 35 of How to Use Excel

Click Save. It's at the bottom of the window. Doing so saves your spreadsheet in the selected folder under the specified name.
Picture 36 of How to Use Excel

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.

Update 05 March 2020

How to Use Excel

Preparing to Use Excel

Entering Data

Using Formulas

Creating Charts

Saving an Excel Project

You should read it

Maybe you are interested

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile