Excel is a program that appeared on the market 37 years ago and since then it is widely used in companies, so much so This is a skill that is highly valued by recruiters.

However, it is not only useful to have some basic knowledge to work with this tool, but also Also, personal spreadsheet reports can be created and reviewed from any device, This will be much more practical than continuing to write down weekly and monthly expenses in a notebook.

Here are some tricks to use in Excel to make it easier to use:

How to select all cells in a sheet

An activity that is always very necessary when working with documents in Excel is to select all the cells that have been created in the same table, and this sometimes becomes tedious, especially when enough information has already been recorded. It will be enough to press the key combination CTRL+E And if it’s Mac Cmd + A. With this command you can change the format elements in less time.

How to remove empty cells

1. Select all the blank cells you want to delete.

2. Press F5 and when the “Go” option opens, select “Special”.

3. Then click on “Empty Cells” and then type the key combination CTRL + minus (-).

4. Finally select the option that says “Delete Rows”

5. How to find duplicate values ​​in a list

6. Select the data you want to verify.

7. On the Home tab, select the Styles group, and then click Conditional Formatting.

8. Then click on the “Cell Highlighting Rules” button and finally select the option that says “Duplicate Values”

How to edit a cell without using the mouse

Usually, people who work with Excel formulas learn to perform their tasks quickly and without using the mouse, for example, if you want to edit a cell without double-clicking the mouse. Just press the F2 key.

How to apply currency formatting automatically

Select the data to convert and press the key combination at the same time CTR + SHIFT + 4In this way numerical values ​​can be converted into monetary format easily and without complications.

How to import data from the web

1. Copy the link to the web page that contains the information you want to insert into the spreadsheet.

2. Now go to the “Data” tab, select “Get data”, then select “From other sources”.

3. Then you need to click on “From the web” and paste the link you copied earlier.

4. As a final step, you should select the table in which you want to insert the imported information.

How to convert values ​​to percentages

Doing so without going through the toolbar options is as easy as selecting the numbers you want to convert to percentages and pressing the buttons at the same time. CTRL+SHIFT+5.

How to use the auto filter button

To filter data in a simple way, you need to find in any cell and press the key combination CTRL + SHIFT + LThen it remains only to click on the arrow that appears in the header of the list to start filtering the data by different aspects.

Continue reading: