9 Excel Formulas Everyone Should Know, According to Harvard University – Teach Me About Science

Are you learning how to use Excel or do you feel like you don’t know enough? Today we leave you with the formulas that everyone should know according to experts.

Excel is > according to the portal Microsoft.

We realize that this tool has become almost a must-have when looking for a job, so it is important to add it to our list of goals or to brush up on the knowledge we already have.

Now, today we are going to introduce you to the Excel formulas that everyone should know. They were released by experts from Harvard Business Review, and although they are not up-to-date information, the reality is that they are still just as useful or even more so.

Excel Formulas You Shouldn’t Miss, According to Experts

Some time ago, Harvard University compiled the 100 most useful final Excel tips, and this was done with the help of Excel experts, so it is a comprehensive quality. However, these 100 tips have been narrowed down to a list of the easiest functions to learn, and these experts state that knowing these functions It can make a huge difference in productivity..

Special paste

To avoid copying an entire formula or something we don’t need, we can resort to Paste Special. For this you will only have to copy what you want, then press Ctrl + Alt + V, and you will no longer have to use the menu release.

Add multiple rows

If what you are looking for is to add multiple rows at the same time, this will be the best option for you, just click Ctrl + Shift + ‘+’.

Want to add quickly?

This function will allow you to add a whole row or column without any problem or pause, just type Alt + = and that’s it.

Did it not go as you expected?

To undo or redo some information you don’t need, type Ctrl+Z or ctrl+Y.

Browse or scroll through data

The above is to be able to know the data in a simple way, and the quick navigation function can be found by typing Ctrl + Shift + Arrows and that’s it, it will be all you have to do.

Create absolute references

With this function, you can also apply an action you have already performed to another action. That is, if you just applied a border to one cell, use F4 to apply it to the other cells.mentioned on the Harvard portal.

Have you duplicated something and don’t know how to delete it?

It happens on more than one occasion, and we know that deleting something can cause the entire document to move, but to delete a duplicate more securely, just type Alt + H + L and that’s it.

Freezing the panels

¿Have you ever scrolled down a large table of data and forgotten which columns were in which?You can safely identify it once it is frozen, all you have to do is type Alt + W + F.

Fast filling

This feature is for > This option is a great feature when you have large lists. To do this, you will just need to enable “File Options” then “Advanced Options”, and to fill in the blanks, just press “Enter”.