Excel Basics: How to Use Excel
A free Office suite fully compatible with Microsoft Office
If you aspire for a new job, you may find it useful to go using Excel and all the essential tools that make up the software. You must research the subject and find effective methods to help you complete the process. Next, you will learn how to using Excel from scratch, both at the level of formulas and to create graphs.
With these basic concepts, you can using Excel 2019 and learn more about the tools that make it up daily. Excel is one of the office's most widely used calculation software, so you must learn to use it one way or another. If you take Excel perfectly, you will have the possibility of aspiring to better jobs where this type of knowledge is essential.
How to using Excel?
For you to go using excel Mac, you will have to take your first steps in the software in the following way:
You must proceed to install Excel on your computer, either using Microsoft Office or WPS Office, which allows you to have it free of charge.
After installing the program, you will only have to start a new blank sheet by clicking on the Excel shortcut. On the other hand, you can open an existing document to modify it.Within the main panel of Excel, you will show endless templates where calendars, simple sheets, sales reports, equipment lists, etc., appear. Their design and style will distinguish these templates, the number of cells, and special characters.
Finally, after you select the template, you will only have to start writing the desired data.
How to use the tabs that makeup Excel?
So you can cover all the spaces on how to using Excel Online, you could inform yourself about the tabs that make up the program. You will only have to:
Open Excel again and go to the options bar located at the top where the tabs will appear:File, ArchiveStartInsertPage designFormsDataCheckViewDeveloper.
If you want to include data in the Excel file, you must start from cell A1 and include them in the same column or nearby rows. To select a cell, you only have to click on the box and indicate the data. Then you will have to click on the enter key and save changes to the file.
If you want to edit the text, you can click on the previously created cell, go to the home tab and look for the numerical format, conditional format, or percentage option.
How to use formulas in Excel?
You can also using Excel 2016 with formulas. You have to follow these steps:
With the Excel document open, you will have to select a cell where you want to apply the formula.
Know basic Excel formulas, such as the SUM function that adds or subtracts the selected cells. This function is also used to divide or multiply the cells. The basic concept of SUM is =SUM(cell+cell).
Also, you can go to the formulas tab and select insert formula to see the available functions. These formulas have acronyms such as TAN, TDIST, or TBILLEQ that you should research for their usefulness. After selecting the formula, you will only have to click on accept.
How to create charts in Excel?
In the process of using Excel, you can dare to become familiar with the graphics, this option is essential to carry out office work, and you will only have to:
Open the Excel document where the dataset you want to place on the chart appears, as shown in the example.
After selecting the data, you only have to click on the Insert tab and select recommended graphics.
In the drop-down menu of the insert box, several options will appear where you can select several options without problems.
After selecting the desired graph, you only have to click on accept and adapt it to the Excel document. You can edit the chart title by going to one end and clicking the + symbol.
To using Excel, you do not need to have prior knowledge of the software but rather comply with the previously described rules. You have to take all the time you want to apply each of the methods explained and thus have a good result. If the content on how to using Excel has been useful to you, do not forget to follow the guides offered by web providers closely.
On the other hand, you should do your best to download WPS Office, knowing that the software is the right one for using Excel. You will not have to invest a single penny in the program, but you can download it free.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)