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

  1. How to Use Excel Picture 1How to Use Excel Picture 1
    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.
  2. How to Use Excel Picture 2How to Use Excel Picture 2
    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.
  3. How to Use Excel Picture 3How to Use Excel Picture 3
    Open Excel. Click or double-click the Excel app icon, which resembles a white "X" on a dark-green background.
  4. How to Use Excel Picture 4How to Use Excel Picture 4
    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.
  5. How to Use Excel Picture 5How to Use Excel Picture 5
    Click Create. It's to the right of the template's name.
  6. How to Use Excel Picture 6How to Use Excel Picture 6
    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

  1. How to Use Excel Picture 7How to Use Excel Picture 7
    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.
  2. How to Use Excel Picture 8How to Use Excel Picture 8
    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.
  3. How to Use Excel Picture 9How to Use Excel Picture 9
    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.
  4. How to Use Excel Picture 10How to Use Excel Picture 10
    Enter text. Type in whatever you want to add to the cell.
  5. How to Use Excel Picture 11How to Use Excel Picture 11
    Press Enter. Doing so adds it to the cell and moves your selection to the next available cell.
  6. How to Use Excel Picture 12How to Use Excel Picture 12
    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.
  7. How to Use Excel Picture 13How to Use Excel Picture 13
    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

  1. How to Use Excel Picture 14How to Use Excel Picture 14
    Select a cell for your formula. Click the cell in which you want to create a formula.
  2. How to Use Excel Picture 15How to Use Excel Picture 15
    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.
  3. Image titled Use Excel Step 16
    {"smallUrl":"https://www.wikihow.com/images/thumb/2/2a/Use-Excel-Step-16-Version-2.jpg/v4-460px-Use-Excel-Step-16-Version-2.jpg","bigUrl":"https://www.wikihow.com/images/thumb/2/2a/Use-Excel-Step-16-Version-2.jpg/v4-760px-Use-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":261,"bigWidth":760,"bigHeight":431.15384615384613,"licensing":"

    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.
  4. How to Use Excel Picture 16How 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.
  5. How to Use Excel Picture 17How to Use Excel Picture 17
    Click Formulas. It's a tab at the top of the Excel window.
  6. How to Use Excel Picture 18How 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.
  7. How to Use Excel Picture 19How to Use Excel Picture 19
    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.
  8. How to Use Excel Picture 20How 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.
    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.
  9. How to Use Excel Picture 21How 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

  1. How to Use Excel Picture 22How 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.
    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.
  2. How to Use Excel Picture 23How 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.
  3. How to Use Excel Picture 24How to Use Excel Picture 24
    Click Insert. It's a tab at the top of the Excel window.
  4. How to Use Excel Picture 25How 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.
  5. How to Use Excel Picture 26How to Use Excel Picture 26
    Select a chart template. Click the chart template you want to use.
  6. How to Use Excel Picture 27How to Use Excel Picture 27
    Click OK. It's at the bottom of the window. Doing so creates your chart.
  7. How to Use Excel Picture 28How 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.
  8. How to Use Excel Picture 29How 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

  1. How to Use Excel Picture 30How 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.
  2. How to Use Excel Picture 31How to Use Excel Picture 31
    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.
  3. How to Use Excel Picture 32How to Use Excel Picture 32
    Double-click This PC. It's in the middle of the page.
    1. On Mac, click On my Mac instead.
  4. How to Use Excel Picture 33How 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.
  5. How to Use Excel Picture 34How to Use Excel Picture 34
    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.
  6. How to Use Excel Picture 35How 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.
  7. How to Use Excel Picture 36How 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.
4.5 ★ | 2 Vote