We know that we can 'Insert Shapes' for use in Microsoft Excel... but how can we edit our shapes to the visual that we would like to show? Today in Episode #1671, Bill shows us how to use Microsoft Power Point to Edit our shapes for use in Excel.
Today's Podcast is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Amazon.com: Excel 2013 In Depth (9780789748577): Jelen, Bill: Books
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Today's Podcast is sponsored by "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Amazon.com: Excel 2013 In Depth (9780789748577): Jelen, Bill: Books
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel with MrExcel podcast episode 1671: Subtract Shapes.
Okay, I know yesterday I was making fun of Excel 2013 but it has a cool, cool feature that we can do.
So you know we've always been able to do Insert Shapes right?
And they have all these different shapes and so I'm going to take the oval and I'm going create a perfect little circle here by holding down the Shift key and dragging to create the circle.
Now you know there's a lot of shapes but there's not every shape you can conceive of, so I'm going to take this heart shape here and inside the circle I'm going to draw a heart shape.
Something like that and I'm going to try and see if I can get it centered, probably right about there, alright.
So now I have two shapes.
I have this first shape which is the circle and then Ctrl + Click on the second shape, the heart, alright.
I'm here in Excel I'm going to Ctrl + C from Excel.
I'm going to switch over to this other program that came on your Excel DVD.
I guarantee that it's there no matter what version of Office you bought.
Even Office RT for the surface has this program on the disc.
It's called PowerPoint.
Here I'm going Ctrl + V. Alright, so you see here I have my two shapes.
Why do I have to come to PowerPoint?
Because they added this feature to PowerPoint but they didn't add it to Excel.
So I'm in PowerPoint 2013 and I come back here to the Drawing Tools format tab, right here, this icon; merge shapes which merges the selected shapes.
I can create a union.
I can combine them.
I can fragment them, intersect them or subtract and subtract this what I'm going do it although it looks like combine is very similar but I'm going subtract.
So it subtracts the second shape, the heart from the first shape, the circle.
Alright, so now that's a single shape Ctrl + C from PowerPoint back to Excel and we'll paste here, alright.
And so now I have a shape that is not one of the standard shapes but I've created a brand new shape and it has all of the features of regular shapes.
So I came out to Drawing Tools then on to Shape Fill, I can make it to be red.
I can come here to Shape Effects, Presets and choose you know one of the rotated presets you know it's a shape I can do anything that I can do with a regular shape, one of the standard 173 shapes.
So I can literally create infinite shapes.
You just kind of have to round-trip your shapes from Excel again to this program you probably may never have used it, I understand, but it's on the DVD, just go back and find it.
PowerPoint and a great little merge shapes icon new in Office 2013 All right, well, hey I want to thank you for stopping by.
We’ll see you next time for another netcast of MrExcel.
Learn Excel with MrExcel podcast episode 1671: Subtract Shapes.
Okay, I know yesterday I was making fun of Excel 2013 but it has a cool, cool feature that we can do.
So you know we've always been able to do Insert Shapes right?
And they have all these different shapes and so I'm going to take the oval and I'm going create a perfect little circle here by holding down the Shift key and dragging to create the circle.
Now you know there's a lot of shapes but there's not every shape you can conceive of, so I'm going to take this heart shape here and inside the circle I'm going to draw a heart shape.
Something like that and I'm going to try and see if I can get it centered, probably right about there, alright.
So now I have two shapes.
I have this first shape which is the circle and then Ctrl + Click on the second shape, the heart, alright.
I'm here in Excel I'm going to Ctrl + C from Excel.
I'm going to switch over to this other program that came on your Excel DVD.
I guarantee that it's there no matter what version of Office you bought.
Even Office RT for the surface has this program on the disc.
It's called PowerPoint.
Here I'm going Ctrl + V. Alright, so you see here I have my two shapes.
Why do I have to come to PowerPoint?
Because they added this feature to PowerPoint but they didn't add it to Excel.
So I'm in PowerPoint 2013 and I come back here to the Drawing Tools format tab, right here, this icon; merge shapes which merges the selected shapes.
I can create a union.
I can combine them.
I can fragment them, intersect them or subtract and subtract this what I'm going do it although it looks like combine is very similar but I'm going subtract.
So it subtracts the second shape, the heart from the first shape, the circle.
Alright, so now that's a single shape Ctrl + C from PowerPoint back to Excel and we'll paste here, alright.
And so now I have a shape that is not one of the standard shapes but I've created a brand new shape and it has all of the features of regular shapes.
So I came out to Drawing Tools then on to Shape Fill, I can make it to be red.
I can come here to Shape Effects, Presets and choose you know one of the rotated presets you know it's a shape I can do anything that I can do with a regular shape, one of the standard 173 shapes.
So I can literally create infinite shapes.
You just kind of have to round-trip your shapes from Excel again to this program you probably may never have used it, I understand, but it's on the DVD, just go back and find it.
PowerPoint and a great little merge shapes icon new in Office 2013 All right, well, hey I want to thank you for stopping by.
We’ll see you next time for another netcast of MrExcel.
