Beyond the activity and the size of the budget we all have had to use Excel or other spreadsheet software and, whether it was to analyze data, it was to schedule activities or keep a list of essential contacts email, we all came across some complicated and complex actions.
It’s time to learn some basic but essential tricks to use Excel by doing advanced excel training courses in Delhi, so here’s a good guide on how to use Excel: a real manual containing some tricks to simplify the main features you might need to maximize productivity.
Ready to find out how best to use this essential software? Let’s start now!
# 1 – Add multiple rows or columns in Excel
When handling a lot of data, you may need to add multiple rows and columns in a spreadsheet. 90% of people would calmly (and be patient) add them one at a time. But if the rows or columns to be added were tens or worse, hundreds? Doing it one by one would be suicide! Fortunately, there is always a more natural way.
# 2 – Use the filters in Excel
The filters represent a tool that allows the user to find within a table more or less abundant in data, the information he needs merely and immediately.
If, for example, you have a document full of companies and addresses, but you only need the names of a particular province, the filters help you to identify what you need on the fly.
How to add a filter in Excel:
- Enter your worksheet;
- Select the area to which you want to apply the filter;
- Click on the toolbar at the top (in some versions it may be under the heading “data”);
- Choose sort and filter (in some versions the two functions are separate);
- In the drop-down menu choose filter (the automatic one usually adapts to the vast majority of cases).
After these simple steps, next to each column title will appear an arrow pointing downwards that leads to a drop-down menu from which you can drive the filter.
# 3 – Remove duplicate fields in Excel
With the help of excel training course in Delhi, you cannot miss the description of the handy feature to remove duplicates, which allows you to check and delete data duplications in a spreadsheet.
To proceed in this sense after entering your worksheet, you must:
- Select the area of data on which you want to check for duplicates;
- Select the data tab in the toolbar and choose advanced filter where you will find the portion of cells selected for the control;
- Check the unique record copy entry to hide duplicate values allowing you to view a copy of the information including unique values;
- Indicate the area of the worksheet where you want to copy the filtered data;
- Save the new list of values using a different name from the previous one to completely delete the duplicate values.
# 4 – Transpose data from rows to columns or vice versa, in a snap
Select the data to be rearranged (including if necessary also the row or column labels) and copy them (the keyboard shortcut is the famous Ctrl + C);
With the right mouse button, then click on the first cell in which the data will be pasted and choose the Transpose function (usually placed in the “Paste Special”), and you’re done!
# 5 – Conditional formatting in Excel
The conditional formatting function allows you to quickly highlight the most important data available within a spreadsheet according to specific rules. When the default rules are not sufficient to meet the individual needs of users, you can add a formula to a conditional formatting rule that simplifies the execution of operations.