Excel

Hello Adewonuola

Thank you for your question.

I believe you may have posted the same question twice - just in case you haven't received the reply to your original post, please follow the link below:
https://www.stl-training.co.uk/post-21031-excel.html #21031

Kind regards
Amanda

Dear Ade

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


To import data from the website you follow these steps:

1. Click on a blank sheet and click where you would like to start the data to be imported.

2. Choose Data > Get external data > New Web Query....

3. Type the web address on eth address bar on the dialog box

4. Browse through the section that you wish to import. Note that the data is all arranged in tables and you should be able to see the arrow with yellow box around it.

5. Click the yellow box with arrow so that it turns in to a green tick.

6. When you finish press Import button on the bottom right hand corner of the window.

A message will ask you to import the web information on the same sheet or a new sheet.

Choose the relevant choice and you should be able to see the web information on your spreadsheet.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT