How to Be an Excel Expert?by Talent Magnifier Job Oriented Practical Training Institute
Do you know there are lots of things that you can make better through your excel by knowing a little more about it? For instance, you can make better charts, use bookmarks and make your work easier by knowing more functions that excel is providing these days. Get all details about excel here.
We all think that we know Microsoft excel well. This is because we are able to execute the very basics of our works like adding the numbers in one column etc.
In this write–up for MS Excel Training Course, we will give you a brief about some of the additional functions of the MS Excel which will definitely make you stand out from your peers.
1) Paste Special
So, have you been writing names in each row and columns for making entries? Is not it time-consuming? You must be thinking that even if you copy-paste the entries you have to change its fonts anyway. Well, here is a time-saving trick for you. Paste-special options allow you to paste the entries in the format and font that you want to. This means you do not have to struggle to make changes in the format every time you paste an entry from the data. This really saves a lot of time.
This is not the end; you can do more to it. If you have a data which is not in the correct layout and you have to put it in a row/column format, you can do it within a blink of an eye. Select and copy the column which you need to paste as a row.
After this, make a selection of the first cell of the row which you want to copy the data in. Select the paste special option under paste option. Finally, an option box will open up. Select the ‘transpose’ option and you will be done. If you still confused, then you can join excel coaching classes in Delhi. Talent magnifier will be right choice for you as they provide same course at affordable fees.
2) Maxifs and Minifs
You must be familiar with one of the most used options in excel that is Max and Min to get the maximum and minimum values. But you must have encountered situations where you have to apply conditions for getting the maximum or minimum value.
Now you can apply the condition and get the result. You can apply one or more conditions to the adjacent ranges that contain the values. For example, if you want to find the maximum and minimum range of selected items stored in your shop, you can do it by using Maxifs and Minifs.
3) Removing the Duplicates
This is one of the essential work that is done using the excel feature. In this advanced excel training course, we will tell you about it. Removing duplicates is really easy. The best thing is you do not have to do it manually and kill time. Highlight your column or row in which you want to delete the duplicates. Select the ‘remove duplicates’ option in the data tab.
A popup window will immediately open where you have to select ‘Remove Duplicates’. Automatically., duplicate entries will be deleted in your selected row/column. Entire rows and columns can be also deleted using this option.
For example, if you have more than one row/column with the same content and you want to see it only once, just select the whole data set and follow the method described above.
Register for Advanced Excel Training Course in Delhi from Talent Magnifier and avail advanced certification. The institute is not only providing excel course, but also they provide HR, Tally ERP 9, and SEO training.
Created on Jun 13th 2018 04:58. Viewed 300 times.