Need up to 30 seconds to load.
all right today I'd like to show you a
neat trick in Excel which allows me to
link information from a website into an
Excel spreadsheet and you might think
wow why would I ever want to do that but
there's actually a lot of situations
where you could use this quite
effectively so I'm gonna even an example
of currency rates so in Excel if you
have a blank or a Booker this would work
within anywhere but you just click on
the cell you'd like to start placing the
data that helps in this process and then
you're gonna go to the data tab along
the ribbon yours will most likely be
expanded and you'll have a button that
says from web in my case because my
screens a bit smaller here I was gonna
have to choose get external data and
then choose from web you're looking for
this from web about the button when I do
that it launches a window called new web
query and I would recommend making this
window a little bit bigger I'm just
probably gonna pop up quite small on
your screen and then you can go to an
address directly if you know it so right
now I'm on Google this is my home page
but I'm just gonna do a Google search
here so it's like you're using a browser
in Excel so I'm going to search for
currency rate table and it pops up all
my Google information which is very
useful he's gonna use this first one X
dash rates com
it skirts the currency exchange table so
I'm gonna click that link and again it
goes there I'll change my table that I
want here I'm going to change it to
Canadian dollar
I want the rates table section and
here's what you need to take a look at
when you load up a website there are
these little yellow arrows okay and this
indicates the table you want to bring in
a lot of websites can get broken down by
these tables as you can see here if I
move my mouse over a particular table it
highlights the area that is going to
import so in this case I'd like to take
this table the top 10 currencies top 10
for the Canadian dollar here so I'm
going to put a little check mark in and
you do that by moving your mouse over
the yellow arrow you click Add
check mark we're ready to go you can
import more than one of these but I'm
just gonna start with just this one so
I'm gonna click the import button it
will ask where do I want to put it it'll
default to whatever cell you've selected
so that's gonna be just fine with me
when I hit okay contacts the website
gets the information and then pulls it
into Excel and of course we might be
thinking to ourselves well you know
that's great and everything but I could
have copied and pasted it why didn't I
just do that well the big difference is
that this data is now connected to that
website so if I start using these
numbers and formulas to do calculations
in my spreadsheet and then tomorrow I
want to get up to date figures on what
the Canadian dollar is doing youth
versus the US dollar the Euro or the
British Pound or any of these things
all I would have to do is refresh the
data and you can do that on the data tab
there's a refresh button you can say
refresh which will refresh the active
connection that you clicked into or you
can do refresh all you see down here it
actually runs the query again goes to
the website gets up-to-date information
and puts it in my spreadsheet so this is
live data that I'm now connected to the
web through Excel that I can use in my
formulas and my spreadsheets so it's
unbelievably powerful tool that we have
in Excel give it a shot it's pretty easy
to use and again if you want it to
update you just gotta click that refresh
button it's going to go contact the
website and get the new information and
away you go
