You are viewing the article How to Use Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 9,336 times.
In this article, the wikiHow will show you how to set up and use Microsoft Excel on a Windows computer as well as a Mac.
Steps
Prepare
![Image titled Use Excel Step 1](https://www.wikihow.com/images_en/thumb/1/11/Use-Excel-Step-1-Version-2.jpg/v4-728px-Use-Excel-Step-1-Version-2.jpg)
![Image titled Use Excel Step 2](https://www.wikihow.com/images_en/thumb/4/45/Use-Excel-Step-2-Version-2.jpg/v4-728px-Use-Excel-Step-2-Version-2.jpg)
- Skip this step if you want to create and open a new Excel document.
![Image titled Use Excel Step 3](https://www.wikihow.com/images_en/thumb/b/ba/Use-Excel-Step-3-Version-2.jpg/v4-728px-Use-Excel-Step-3-Version-2.jpg)
![Image titled Use Excel Step 4](https://www.wikihow.com/images_en/thumb/b/b2/Use-Excel-Step-4-Version-2.jpg/v4-728px-Use-Excel-Step-4-Version-2.jpg)
- If you just want to open a blank Excel document, click the Blank option at the top left of the page and skip to the next step.
![Image titled Use Excel Step 5](https://www.wikihow.com/images_en/thumb/e/e0/Use-Excel-Step-5-Version-2.jpg/v4-728px-Use-Excel-Step-5-Version-2.jpg)
![Image titled Use Excel Step 6](https://www.wikihow.com/images_en/thumb/0/0c/Use-Excel-Step-6-Version-2.jpg/v4-728px-Use-Excel-Step-6-Version-2.jpg)
Insert information
![Image titled Use Excel Step 7](https://www.wikihow.com/images_en/thumb/d/d6/Use-Excel-Step-7-Version-2.jpg/v4-728px-Use-Excel-Step-7-Version-2.jpg)
- Home — Contains options related to text formatting, changing cell background color, and the like.
- Insert — Contains options for tables, charts, graphs, and equations.
- Page Layout — Contains options related to alignment, changing page orientation, and choosing a theme.
- Formulas — Includes a function menu and numerous formula options.
![Image titled Use Excel Step 8](https://www.wikihow.com/images_en/thumb/f/fb/Use-Excel-Step-8-Version-2.jpg/v4-728px-Use-Excel-Step-8-Version-2.jpg)
![Image titled Use Excel Step 9](https://www.wikihow.com/images_en/thumb/9/9b/Use-Excel-Step-9-Version-2.jpg/v4-728px-Use-Excel-Step-9-Version-2.jpg)
- For example, in the case of using a spending plan template, you can click on the first empty box to select that box.
![Image titled Use Excel Step 10](https://www.wikihow.com/images_en/thumb/c/cf/Use-Excel-Step-10-Version-2.jpg/v4-728px-Use-Excel-Step-10-Version-2.jpg)
![Image titled Use Excel Step 11](https://www.wikihow.com/images_en/thumb/4/49/Use-Excel-Step-11-Version-2.jpg/v4-728px-Use-Excel-Step-11-Version-2.jpg)
![Image titled Use Excel Step 12](https://www.wikihow.com/images_en/thumb/9/92/Use-Excel-Step-12-Version-2.jpg/v4-728px-Use-Excel-Step-12-Version-2.jpg)
![Image titled Use Excel Step 13](https://www.wikihow.com/images_en/thumb/7/70/Use-Excel-Step-13-Version-2.jpg/v4-728px-Use-Excel-Step-13-Version-2.jpg)
- You can also use conditional formatting to change the formatting of cells based on certain factors (for example, automatically turning red when a value in a cell is below a certain threshold).
Use the formula
![Image titled Use Excel Step 14](https://www.wikihow.com/images_en/thumb/0/07/Use-Excel-Step-14-Version-2.jpg/v4-728px-Use-Excel-Step-14-Version-2.jpg)
![Image titled Use Excel Step 15](https://www.wikihow.com/images_en/thumb/7/77/Use-Excel-Step-15-Version-2.jpg/v4-728px-Use-Excel-Step-15-Version-2.jpg)
- Add — Type =SUM(cells+cells) (for example,
=SUM(A3+B3)
) to add two cells together, or type =SUM(cells, cells, cells) (for example,=SUM(A2,B2,C2)
) to add a range of cells together. - Subtract — Type =SUM(cell-cell) (for example,
=SUM(A3-B3)
) to subtract the value of one cell from the value of the other cell. - Divide — Type =SUM(cells/cells) (for example,
=SUM(A6/C5)
) to divide the value of one cell by the value of another cell. - Multiply — Type =SUM(cell*cell) (for example,
=SUM(A2*A7)
) to multiply two cell values together.
![Image titled Use Excel Step 16](https://www.wikihow.com/images_en/thumb/2/2a/Use-Excel-Step-16-Version-2.jpg/v4-728px-Use-Excel-Step-16-Version-2.jpg)
=SUM(A1:A12)
) in the cell you want to display. display results. ![Image titled Use Excel Step 17](https://www.wikihow.com/images_en/thumb/f/f5/Use-Excel-Step-17-Version-2.jpg/v4-728px-Use-Excel-Step-17-Version-2.jpg)
![Image titled Use Excel Step 18](https://www.wikihow.com/images_en/thumb/f/f8/Use-Excel-Step-18-Version-2.jpg/v4-728px-Use-Excel-Step-18-Version-2.jpg)
![Image titled Use Excel Step 19](https://www.wikihow.com/images_en/thumb/4/4b/Use-Excel-Step-19-Version-2.jpg/v4-728px-Use-Excel-Step-19-Version-2.jpg)
![Image titled Use Excel Step 20](https://www.wikihow.com/images_en/thumb/9/9e/Use-Excel-Step-20-Version-2.jpg/v4-728px-Use-Excel-Step-20-Version-2.jpg)
- For example, to choose a formula for finding the tangent of an angle, you can scroll down and tap the TAN option.
![Image titled Use Excel Step 21](https://www.wikihow.com/images_en/thumb/2/23/Use-Excel-Step-21-Version-2.jpg/v4-728px-Use-Excel-Step-21-Version-2.jpg)
- For example, when choosing the TAN function, you will have to enter the magnitude of the angle for which you want to find the tangent.
- Depending on the function selected, you may have to click according to some on-screen instructions.
![Image titled Use Excel Step 22](https://www.wikihow.com/images_en/thumb/1/1d/Use-Excel-Step-22-Version-2.jpg/v4-728px-Use-Excel-Step-22-Version-2.jpg)
Create a chart
![Image titled Use Excel Step 23](https://www.wikihow.com/images_en/thumb/e/e3/Use-Excel-Step-23.jpg/v4-728px-Use-Excel-Step-23.jpg)
- Usually the left column is used for the horizontal axis and its right column is used for the vertical axis.
![Image titled Use Excel Step 24](https://www.wikihow.com/images_en/thumb/b/bd/Use-Excel-Step-24.jpg/v4-728px-Use-Excel-Step-24.jpg)
![Image titled Use Excel Step 25](https://www.wikihow.com/images_en/thumb/4/4a/Use-Excel-Step-25.jpg/v4-728px-Use-Excel-Step-25.jpg)
![Image titled Use Excel Step 26](https://www.wikihow.com/images_en/thumb/a/ae/Use-Excel-Step-26.jpg/v4-728px-Use-Excel-Step-26.jpg)
![Image titled Use Excel Step 27](https://www.wikihow.com/images_en/thumb/f/fc/Use-Excel-Step-27.jpg/v4-728px-Use-Excel-Step-27.jpg)
![Image titled Use Excel Step 28](https://www.wikihow.com/images_en/thumb/9/96/Use-Excel-Step-28.jpg/v4-728px-Use-Excel-Step-28.jpg)
![Image titled Use Excel Step 29](https://www.wikihow.com/images_en/thumb/7/7e/Use-Excel-Step-29.jpg/v4-728px-Use-Excel-Step-29.jpg)
![Image titled Use Excel Step 30](https://www.wikihow.com/images_en/thumb/1/1d/Use-Excel-Step-30.jpg/v4-728px-Use-Excel-Step-30.jpg)
Save Excel project
![Image titled Use Excel Step 31](https://www.wikihow.com/images_en/thumb/8/84/Use-Excel-Step-31.jpg/v4-728px-Use-Excel-Step-31.jpg)
![Image titled Use Excel Step 32](https://www.wikihow.com/images_en/thumb/8/84/Use-Excel-Step-32.jpg/v4-728px-Use-Excel-Step-32.jpg)
- On a Mac, this option in the File drop-down menu.
![Image titled Use Excel Step 33](https://www.wikihow.com/images_en/thumb/9/90/Use-Excel-Step-33.jpg/v4-728px-Use-Excel-Step-33.jpg)
- With a Mac it would be On my Mac (On my Mac).
![Image titled Use Excel Step 34](https://www.wikihow.com/images_en/thumb/a/a8/Use-Excel-Step-34.jpg/v4-728px-Use-Excel-Step-34.jpg)
![Image titled Use Excel Step 35](https://www.wikihow.com/images_en/thumb/a/a2/Use-Excel-Step-35.jpg/v4-728px-Use-Excel-Step-35.jpg)
- On a Mac, you’ll probably have to click the “Where” drop-down box first before you can select the file.
![Image titled Use Excel Step 36](https://www.wikihow.com/images_en/thumb/2/2b/Use-Excel-Step-36.jpg/v4-728px-Use-Excel-Step-36.jpg)
![Image titled Use Excel Step 37](https://www.wikihow.com/images_en/thumb/b/b1/Use-Excel-Step-37.jpg/v4-728px-Use-Excel-Step-37.jpg)
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 9,336 times.
In this article, the wikiHow will show you how to set up and use Microsoft Excel on a Windows computer as well as a Mac.
Thank you for reading this post How to Use Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: