Excel Hacks, Tricks and Shortcuts That Must be Known by Analysts

There may be times when you feel that MS Excel is just too good to be true, as all you need to do is enter a simple formula and anything under the sun can be that one can do manually, can be taken care of automatically. With Ms Excel tasks like merging together two sheets of similar data, combining information in several cells etc. can be taken care of in excel with just a click.

If you still have to manually update your data then there must be a formula that can do so for you. So, here are a few clever Excel tricks and formulas that can help save you countless hours of copying and pasting information on countless cells.

As a premiere advanced excel training institute in Kolkata we believe in efficient work more than tedious work, so here are a few tricks every Excel user must know:

Tip 1:

Add more than one row or column in excel:

Sometimes a data analyst may need to add more than one row or column into their excel spreadsheet, even in the count of hundreds may be required to be done. If one tries to do so manually, then it would take a lot of time, so here is a shortcut.

To add multiple rows and columns you need to follow the below mentioned steps:

Simply highlight the equal number of rows or columns you need to add. Then right-click and click on insert from the list of options.

Tip 2:

Use filters to select specific datasets with convenient filters:

When data scientists work with large datasets they are not always able to look at the whole spreadsheet or each and every row and column at the same time. Sometimes one might need to look at the data that only fits a certain criteria. This can be done easily in excel with filters.

You can use the filter option by following these steps:

To add a filter click on the data tab and click on Filter and choose the column/row you want to work on, then click on the tiny arrow beside the column header. Then from the list of options one will be able to choose whether they want their data to be arranged in ascending or descending order. One can also choose to see specific rows and columns as per your needs.

Tip 3:

Removing duplicates from your spreadsheets:

Often a common problem faced by data analysts is the presence of duplicate content in large data sets. But in such difficult situations removing duplicate content can be arduous. So, this nifty trick to delete duplicate content can come in handy. Here is how you can do that:

Highlight the column or row you want to work on, and then go to the ‘data' tab. There select "remove duplicates", you will find this option under tools. Then a pop-up box will appear to confirm which data you want to remove. Select the same and click on remove duplicates, and that is it, you are good to go.

We hope this article was helpful for you, to keep handy excel tools handy we suggest you bookmark this article for fast referencing.