How to Insert Microsoft Excel Data and Charts into Microsoft Word and PowerPoint

so let's say you just finished  an excel worksheet for your boss   it has tables in it graphs and now they are asking  for you to produce a report in microsoft word and   a presentation inside microsoft powerpoint i  want to show you different ways that you can   copy and paste that information from microsoft  excel over to word in powerpoint very quickly

hi my name is jamie and thanks for joining me here  at teachers tech today if you want to follow along   with this spreadsheet here that i'm going to be  using for the demo here today i'll put a link to   that down below in the description so then as  i go and show you things you can kind of copy   right along okay so i have these two different  documents open up here one on the right here is   microsoft excel and on the left i have microsoft  word so i have this table inside microsoft word   you can see this document over here has the graph  and everything in here but i'm going to take this   table and i want to put it inside microsoft word  so i'm just going to go ahead and select what i   want to copy and at this point i could go ctrl c  or i could do my copy now if we just go over to   microsoft word and use our control v or right  click and paste you can see it gets put right   into it very easy the one thing to know if i go  and click in any of these if i make a change here   if i change this to 70 notice nothing changes so  there's no formulas in here just kind of copied   how it looked and put it into here so i'm just  going to go ahead and delete i'm just going to   go undo a couple steps now i just want to show you  some different options that you can paste this in   and you can kind of find what would be the best  for you so if i go back up to paste and looking   at the different options the default paste was  this one i that i just showed you i can go across   this is just the unformatted version of the same  thing there's no formulas in this is when we   start to link or link our data between our excel  spreadsheet and microsoft word so what i mean is   you can see one is formatted one's not so  if i just go to this one the unformatted   these are links so this microsoft word table  in here is linked to this one so if i go ahead   and change this number in here and if you watch  on the other side so if i change this to 70   hit return this changes over here so these two  documents are linked this is nice so if you are   creating this report and you put the table in  and realize that you need to make some changes   to your spreadsheet you can just change it into  one place and it will update everywhere so they're   linked the problem with this though is are that  you would have to remember you need to send the   spreadsheet with if you're sending it to someone  else because they're linked the two documents   are linked in it so if you go ahead and delete  the excel spreadsheet you're this isn't going   to work or if the person does someone else is  viewing it without that spreadsheet it's not   going to work because they are linked now i want  to show you a different way that you can do this   uh where you don't have to worry about it  being uh linked on it that'll come together   so i'm just going to go ahead and just undo  what i just did here and get rid of those   if i go back to i'm going to copy this one more  time over here so i'm just doing ctrl c if i go   back to here and paste now i do want to show you  this option right here you can paste as an image   if you didn't want anything to be changed you can  see now if i paste it as an image this is just an   image i can't click in here and do anything uh  i could crop it and everything but it just kind   of put this in as a picture in here it's actually  when you're coming from here if you look at this   option you can copy it as a picture and paste it  over from excel so just a couple of different ways   you can do this but what i really want to show you  if we go back to our paste option so what i what i   want you to look at is paste special so if i go to  paste special there's paste and paste link now the   paste link is very similar to what i showed you  before uh with the needing the link between so you   need both documents but if i go paste and choose  this object one the worksheet object and hit okay   now what's going to happen is if i go ahead  and open this notice this is called document to   word i haven't saved it as anything if i go ahead  and double click in this it opens up this so this   is kind of connected to that microsoft  word document where you won't need the original   the original excel file so now if i'm making  changes in here and i'm just going to change this   to 100 and click out you can see the changes are  made but this is opening up an excel work excel   inside of that word document i don't need to be  sending uh sending it that way of the length of   the two different files i'm not actually when  i change this though now if i go back to the   original file this never did change so it's not  changing the original file but it's allowing me   to work inside a word document and making the  changes through here so it's inside microsoft   word and it's opening up inside this as excel  inside so now i do want to point out you can   copy paste uh graphs over too so i'm just going  to go ahead and close this out and i'll go back to   this one here if i go ahead and take this right  here uh copy i can right click copy i could go   over here and i'm just going to give a couple  spaces now i can paste in different ways too   so i you as i go through we can paste with the  link and as i change anything on that excel   spreadsheet it will change in the document if i in  those two are within the formats or i can do the   image but we can also do it as paste special here  as the object and now if i go ahead as soon as i   double click in here you're going to see the exact  same thing again it's going to open up uh my chart   in here in one second there it is and so i can go  ahead if i wanted to alter it here you can see as   i spread it apart it's spreading apart down here  so if i was just picking one of the pieces and   bringing it out you can see it there so those are  some different ways you can be pasting into word   from microsoft excel to microsoft word let's go  over to powerpoint and look at the options there

so now i have microsoft powerpoint open on the  left and many of the things are very similar to   microsoft word but there's a couple differences  and i just want to show you those i'm going to go   ahead and copy this information here so i'm just  going to do control c when i go over here i could   right click and paste and it'll look as that be  pasted as the table just as this default one here   what i want to point out uh first of all i'm  going to go to paste special and the paste   special is there so you can see we can go paste  and put it in but inside this way if we go to   this one right here this works the same way as  that paste special for this table so if i click   on it now if i go ahead and double click in here  what happens is it's not going to pop open that   spreadsheet that it did in microsoft word it is  there though you can see how i can maneuver around   this spreadsheet it's just embedded in here so  any change i make in here so if i was changing   this to a hundred and click out everything works  it's that spreadsheet within it so i can go do the   same thing uh so i'm just gonna delete this really  quickly and if i was gonna go and i'm just gonna   copy it one more time just to point out if we look  at the different options here under paste special   we can do the link so we could link it and then  you're going to need both files that way i do want   to grab a um this chart right here so this pie one  and i'm gonna go right click on this one and just   copy like this time when i paste it over to this  slide here you can see i have different options   notice that the link one comes up right through  there so just like before when i did it inside   microsoft word these would be the link to it  whether they'd be the formatting or not or the   image i'm going to go to paste special to show you  if you do it as the paste in here hit ok and as it   puts it in if i double click on this and this time  it's going to open up and i have my information in   here it has that tab this time just like before  with microsoft word this chart is independent   of that spreadsheet you won't need them both but  if you are linking you will need them both so i   hope you liked learning about these ways that you  can copy and paste your data from microsoft excel   over to microsoft word or powerpoint finding  out which way would work the best for you if   you have that report coming up and you need to  or you need to make that presentation thanks   for watching this time on teachers tech i'll see  you next time with more tech tips and tutorials