Data Copy from Web Page

Are you sick of copying the same data again and again from web page and hate it like anything? 

Do you copy your equity share report from web page in every 1 hour and still don’t get all figures in one go?

Following information might help you… ...

Let’s see how we can make it simple -
-Open internet explorer and surf your equity page
-Copy the web address and open excel sheet
-Go to Data tab and Click on From Web button
-Paste the copied address in the Address Comb box and Click on Go
-Wait till the time box shows you the web Page inside the Web query box
-Then click on Import Button and your half work is done

Now you don’t need to visit the web page every time, you can open the same excel file and get your data readily available in excel.

Please Note :

While opening the excel file, Microsoft Excel will throw a Security Warning saying that data connection have been disabled, you need to click on Options and then Enable this content every time.
Now you can refresh your data in Data Tab.

 

Sort from Left to Right

This Week’s Special!

Sorting data from Left to Right is very easy

1) Select your Data

2) Go to Data TAB and click on Sort button

3) Then click on the Options...

4) click on "Sort left to right" Option

5) Then again it will go back to the Sort window where you need to select Row 1 for Field Sort

You are Done !!!

Please write for any specific information, I'd love to share if i could.

You can also write me on excelchamps@gmail.com

LEN Function - Microsoft Excel 2007

Do you want to know how this function works?

Let's have your 5 min on this....

TRANSPOSE Function - Microsoft Excel 2007

TRANSPOSE Function -

One more amazing function in Microsoft Excel 2007

To enjoy this kind of posts please follow this blog.

Remove Dupliate - Microsoft Excel 2007

It's Long time I haven't written any blog !

To start with let's talk about Microsoft Excel 2007 which has amazing features in it.

One of the wonderful features is “Remove Duplicate”

REMOVE DUPLICATE in Microsoft 2007

The best part of this feature is that you don’t have to sort the data before you go to remove the duplicate records.

Just follow some simple steps & your work is done !

Select the data & go to the "DATA" TAB

After click, Dialog Box (Remove Duplicate) will appear

Click on OK, Duplicate records will be removed

Amazing feature don't you think so !!!