Dear friends, this article of mine is a bit different from what you all have been reading earlier. My earlier articles revolved around various excel functions that were of use in our day-to-day operations, however today we discuss about some of our day-to-day requirements that are not met by standard excel functions and also there are many standard excel functions which consume a lot of time to perform. Powerutils is an add-in that can help us in both the above dilemmas. http://www.powerutilsnet.com/ is a website where you can download an add-in that contains the add-in.
Steps to download the add-in:
Before starting the download you have to ensure that the macro security is low. By default the security is high. To make it low go to Tools >> Security and select low.
Start your internet connection and visit website http://www.powerutilsnet.com/
On the home page of the website there is a download option (third button on the left side of your screen). Click the download button.
There is a link available to download powerutils 1.9, click the link and save the zip file on your hard disk.
After the zip file is saved open the same and double click the setup/exe file.
After performing all the above steps in sequence, your excel page would look as shown below:
Steps to download the add-in:
Before starting the download you have to ensure that the macro security is low. By default the security is high. To make it low go to Tools >> Security and select low.
Start your internet connection and visit website http://www.powerutilsnet.com/
On the home page of the website there is a download option (third button on the left side of your screen). Click the download button.
There is a link available to download powerutils 1.9, click the link and save the zip file on your hard disk.
After the zip file is saved open the same and double click the setup/exe file.
After performing all the above steps in sequence, your excel page would look as shown below:
You will see an additional option between Window and Help options as highlighted above.
Various options available in powerutils:
When you click the above tab i.e. powerutils you can see the following options:
Use of each option in powerutils add-in
Text
Change cases: Conversion of lower, upper or proper cases is easy in excel by use of function =upper(), or =lower() or =proper() as the case may be. However it is a time consuming process. In case of powerutils you just need to select the range of cells that you want to change and select the option.
Delete characters: Deletion of a particular number of starting or ending characters can be done in excel with the help of =left, = right or =mid. However use of these functions is also time consuming. Hence the delete options available in Powerutils >> text are very useful.
Split Name: In case we have a database where a particular column has full name of all the candidates it would be difficult for us to split the same in name and surname. We can use Powerutils >> Text >> Split names option to break the full name into surname, middle name and name.
We will continue with other options available in powerutils in next article.
Various options available in powerutils:
When you click the above tab i.e. powerutils you can see the following options:
Use of each option in powerutils add-in
Text
Change cases: Conversion of lower, upper or proper cases is easy in excel by use of function =upper(), or =lower() or =proper() as the case may be. However it is a time consuming process. In case of powerutils you just need to select the range of cells that you want to change and select the option.
Delete characters: Deletion of a particular number of starting or ending characters can be done in excel with the help of =left, = right or =mid. However use of these functions is also time consuming. Hence the delete options available in Powerutils >> text are very useful.
Split Name: In case we have a database where a particular column has full name of all the candidates it would be difficult for us to split the same in name and surname. We can use Powerutils >> Text >> Split names option to break the full name into surname, middle name and name.
We will continue with other options available in powerutils in next article.
No comments:
Post a Comment