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
- Skip this step if you want to create and open a new Excel document.
- 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.
Insert information
- 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.
- For example, in the case of using a spending plan template, you can click on the first empty box to select that box.
- 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
- 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.
=SUM(A1:A12)
) in the cell you want to display. display results. - For example, to choose a formula for finding the tangent of an angle, you can scroll down and tap the TAN option.
- 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.
Create a chart
- Usually the left column is used for the horizontal axis and its right column is used for the vertical axis.
Save Excel project
- On a Mac, this option in the File drop-down menu.
- With a Mac it would be On my Mac (On my Mac).
- On a Mac, you’ll probably have to click the “Where” drop-down box first before you can select the file.
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: