Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses london - Table

excel training courses london - Table

ResolvedVersion Standard

Tue 15 May 2007, 14:11 Delegate Danny said...

Danny has attended:
Excel Intermediate course

Table

How to import a table on a webpage into Excel?

Tue 15 May 2007, 15:20 Trainer Amanda said...

RE: Table

Hi Danny

Thanks for your question.

You can do this by going to Data - Import External Data - New web query.

A little browser window pops up - enter in the web page address and press Enter.

Each table will come up with an arrow in a yellow box next to it - click on the box next to the table to be imported.

Click Import at the bottom of the little browser window.

The data may take a few seconds to come through.

Amanda.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

excel training courses london - Table

Table

RE: Table

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel