mr. su casa y ez excel powerpivot for
the data analyst for linking excel data
the powerpivot well hey welcome back to
the mr. excel NetCast I'm bill jelen
we're working through the examples for
powerpivot for the excel data analyst
we're taking a look here in chapter 4
about how to take linked tables and add
those two powerpivot now tables tables
are new and Excel 2007 it's very
possible that many people using Excel
have never really use tables before a
table is good anytime you have headings
across the top and then rows of data
which you think about is probably ninety
percent of your your spreadsheets but we
need to do something special here we
need to declare this as a table now
there's a couple different ways to do it
I do it using ctrl T for table you can
also come here to the Home tab and say
format as table choose a table format
click ok and you get a table now notice
here on the table tools design tab gives
us the real imaginative name of table 1
you can use table 1 but let's change
that table name before we link will just
call it store info store info so this
map store number to store name and
region and and other things like that
okay so now we have an official table
the benefits of an official table
well we get the filter dropdowns we
could have added that we get the nice
formatting where we can show banded rows
are banded columns
that's nice the real benefit though is
when we create charts or pivot tables
from this data and paste dude at the
bottom of the chart or pivot table will
automatically expand
now that we have power pivot the other
great advantages we don't have to copy
and paste this data powerpivot we can
simply create a linked table create a
link table so
they're the demo worksheet is what we
imported in the first video now this
store info sheet is this linked table
alright so we didn't actually copy and
paste later on if we decide that we need
to change something here we want to move
this from the Atlanta region to the
Arizona region we would have to do is
update all in that data will get updated
in PowerPivot so linked tables great way
if you just have a simple little excel
data set great way to get that data in
the powerpivot in this case good for a
tiny little lookup table here that will
use later when we're creating our pivot
tables want to talk about it next time
for another NetCast from mr excel