Today Bill addresses a question that Chandoo had brought along with him for the Mini-Summit in Ohio last Friday. Follow along with Episode #1709 to see how to mark Invoices Paid/Sent and learn a bit about Word Art in Excel.
"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. Excel 2013 In Depth
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
"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. Excel 2013 In Depth
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Learn Excel from MrExcel podcast, episode 1709 - Mark Invoice Paid!
You know last Friday Chandoo was here, and Chandoo had collected 211 questions for me, and we actually spent about two hours on Chandoo's podcast, going through and answering a lot of these questions, but we didn't get to some of them.
One of them that we didn't get to address with Chandoo is Ola: They create invoices in the finance departments, they follow one another on a sheet for easy purpose, but want to basically be able to stamp the invoice with "SENT" or "PAID" or something like that.
So I just created some simple little invoices here like Ola described, you know, just one after the other.
So here's the first invoice, did a page break, here's the next invoice, and so on.
I want to be able to mark these as "SENT" or "PAID" or something like that, and so I'm going to choose that cell, Insert, out of here on the right hand side of the Insert, under Text choose WordArt.
Alright, now I'll just choose one of these, I'm going to be able to change it, I'll choose that one there, and let's just mark this as "SENT", OK.
BUT, yeah, WordArt has those 25 styles, there's far more that you can do with WordArt.
So I'm going to select the characters there and, you know, just kind of look for some big interesting bold font there, from the Quick Access Toolbar.
Or if you prefer, back up here on the Home tab, you know, it's the same list, you just have more, so maybe this- no, too big, Britannic Bold, Broadway, yeah, sure, OK, there we go.
I changed the color of the font itself, and out on the Format tab we can actually add a shape outline.
So I can put this in a red box, and the shape outline will have, you know, some sort of weight, alright, so there's our first stamp like that.
You notice that there is a background color there, that is actually on the Format tab, under WordArt Styles, the Text Outline, you can control that.
So maybe an orange would look better back there instead of the red, let's take a look, OK.
Now, to make it look more like a rubber stamp, once you select this rotation handle here, allows you to rotate it, kind of like someone just grabbed the stamp and stamped the invoice.
Alright, so we have our first one there, I Ctrl+C to copy, and then go down our next invoice.
Once we've sent this one, I'll Ctrl+V, and here- I want to mark this one as "PAID", so I'm going to paste the "SENT" stamp, but then select the text and type "PAID", and I want the "PAID" stamp to be a little bit different.
So I'm going to choose that text, under Home we'll choose a different font, and also a different color.
So you know, the first time that I create each one of these, it's going to be a little bit of a hassle to go through, and I kind of get it right.
But then once I have one of each stamp, I have a "PAID" stamp, I have a "SENT" stamp, I have a "TREATED" stamp, then it's just a matter of copying and pasting, and you have effectively stamped your invoices using Excel.
QuickBooks has this feature, once you mark something as "PAID" you get the nice little "PAID" stamp on there.
I get it, it's cool, it feels like the old days when we actually had a rubber stamp, so great question there from Ola.
Alright well hey.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Learn Excel from MrExcel podcast, episode 1709 - Mark Invoice Paid!
You know last Friday Chandoo was here, and Chandoo had collected 211 questions for me, and we actually spent about two hours on Chandoo's podcast, going through and answering a lot of these questions, but we didn't get to some of them.
One of them that we didn't get to address with Chandoo is Ola: They create invoices in the finance departments, they follow one another on a sheet for easy purpose, but want to basically be able to stamp the invoice with "SENT" or "PAID" or something like that.
So I just created some simple little invoices here like Ola described, you know, just one after the other.
So here's the first invoice, did a page break, here's the next invoice, and so on.
I want to be able to mark these as "SENT" or "PAID" or something like that, and so I'm going to choose that cell, Insert, out of here on the right hand side of the Insert, under Text choose WordArt.
Alright, now I'll just choose one of these, I'm going to be able to change it, I'll choose that one there, and let's just mark this as "SENT", OK.
BUT, yeah, WordArt has those 25 styles, there's far more that you can do with WordArt.
So I'm going to select the characters there and, you know, just kind of look for some big interesting bold font there, from the Quick Access Toolbar.
Or if you prefer, back up here on the Home tab, you know, it's the same list, you just have more, so maybe this- no, too big, Britannic Bold, Broadway, yeah, sure, OK, there we go.
I changed the color of the font itself, and out on the Format tab we can actually add a shape outline.
So I can put this in a red box, and the shape outline will have, you know, some sort of weight, alright, so there's our first stamp like that.
You notice that there is a background color there, that is actually on the Format tab, under WordArt Styles, the Text Outline, you can control that.
So maybe an orange would look better back there instead of the red, let's take a look, OK.
Now, to make it look more like a rubber stamp, once you select this rotation handle here, allows you to rotate it, kind of like someone just grabbed the stamp and stamped the invoice.
Alright, so we have our first one there, I Ctrl+C to copy, and then go down our next invoice.
Once we've sent this one, I'll Ctrl+V, and here- I want to mark this one as "PAID", so I'm going to paste the "SENT" stamp, but then select the text and type "PAID", and I want the "PAID" stamp to be a little bit different.
So I'm going to choose that text, under Home we'll choose a different font, and also a different color.
So you know, the first time that I create each one of these, it's going to be a little bit of a hassle to go through, and I kind of get it right.
But then once I have one of each stamp, I have a "PAID" stamp, I have a "SENT" stamp, I have a "TREATED" stamp, then it's just a matter of copying and pasting, and you have effectively stamped your invoices using Excel.
QuickBooks has this feature, once you mark something as "PAID" you get the nice little "PAID" stamp on there.
I get it, it's cool, it feels like the old days when we actually had a rubber stamp, so great question there from Ola.
Alright well hey.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
