**CONTEST ALERT**
It's Thursday and Bill is reviewing the week thus far and Bill has an interesting discovery - Excel Messagebox messages are sporting 'Attitude'. Take a look at Episode #1591, churn your ideas and then enter the contest! [Bill talks about the contest in the Podcast] This is Part IV of V in the Excel 2013 Review Series.
...This is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
It's Thursday and Bill is reviewing the week thus far and Bill has an interesting discovery - Excel Messagebox messages are sporting 'Attitude'. Take a look at Episode #1591, churn your ideas and then enter the contest! [Bill talks about the contest in the Podcast] This is Part IV of V in the Excel 2013 Review Series.
...This is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"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, Excel 2013 Preview Excel With Attitude.
Hey, everyone. This is Bill Jelen. All week, we’ve been taking a look at the new things in Excel 2013 and I've been doing all kinds of things in Excel 2013. I just want to refresh your memory here. We're going to do CONTROL+H, I'm going to replace MOTORS with MOTOS. I don't know why. ALT+A. EXCEL HAS COMPLETED ITS SEARCH AND HAS MADE 3 REPLACEMENTS. You've seen that thousands of times, right? It was late, late, late one night. I'd written, you know, lots of pages that day, and I did a CONTROL+H and I replaced MOTORS with MOTOS, and I said REPLACE ALL. ALL DONE. WE MADE 60 REPLACEMENTS, you know.
So, there’s a mailing list [ of some MVPs that the Excel PMs – 00:48 ] are monitoring, and I said, really, are you guys just…are you serious? Did you change this message, and they came back in and they said, it's our new attitude and we like it. I said that's cool. So, then, I went out and I started to figure out, you know, what other messages just drive me crazy. Here, let's go back to Excel 2010 and I want to insert a new row in a pivot table. ALT+I R. Oh my god, I haven’t…this is so long, I’d fall asleep by the time I'm done. I'm not even going to read it to you. Let's go to Excel 2013 and we'll go to the pivot table, this one, and same thing, ALT+I R, and it's a lot shorter now. I mean, there's a chance I'm going to actually read this, WE CAN’T MAKE THIS CHANGE, although, I said, you really should have made it a little bit more friendly than that.
Here's another one. How about circular references?
Oh my gosh. In Excel 2010, = that and then this is = to this. CIRUCLAR REFERENCE WARNING and it goes on and on and on and on, and no one actually reads this. They just click OK, right, but now we'll try it in Excel 2013.
Same thing. That formula is there. This formula’s here. Hey. Careful. CAREFUL, WE FOUND ONE OR MORE CIRCULAR REFERENCES IN YOUR WORKBOOK THAT MIGHT CAUSE YOUR FORMULAS TO CALCUALTE INCORRECTLY. For your…FYI. FYI. That's great.
A CIRCULAR REFERENCE CAN BE A FORMULA THAT REFERS TO ITS OWN CELL VALUE, OR REFERS TO A CELL DEPENDENT ON ITS OWN CELL VALUE, alright and I'm sure there's more.
You know, I started going through and just trying to do all crazy things I could think of that cause the messages to pop up and see these new attitude messages, and I realized this is a grand opportunity, right? Some messages we'd like to see, you know? For example, we are truly bummed out that we can't let you insert those rows in our pivot table, but to learn about some workarounds, click here, and then actually show them how to use the blank rows when they clicked here, or you've got a circular reference, just reboot the computer and start over.
So, here's the opportunity. For those of you who have your favorite or least favorite Excel message, the thing that pops up that just irritates the heck out of you, how would you like to have that rewritten, right? So, go ahead. If you're watching at YouTube or at learnmrexcel.wordpress.com, go ahead and post the comments. We’ll take a look at the best ones of those. There should be some funny ones. So, just get creative. We'll come up with a suitable prize, I'm sure for the…or maybe we’ll put your message on a mug. I don't know. Who knows? We'll come up with something. So, I think it's good, you know.
Excel has attitude.
Let's actually take a look at something serious here Now, so, [ unintelligible – 03:35 ], 640 by 480, but in real life, how many of you have 2 monitors? I mean, I have the laptop monitor and, then, on the right hand side, I’ve got a drive-in movie screen out there now, and I have that everywhere. Down at the office, I have that. Up where I write, I have that. Here at the podcast studio, I have that.
There's 2 monitors everywhere, and 2 monitors in Excel did not work well together in Excel 2010. That was one of the big downfalls, but now it's something called singular document interface.
So, if we have 2 Excel documents, open your…I’ll do CONTROL+N for new, every document gets its own ribbon. I can take this document.
Now, you're not going to be able to see this.
I just moved it out to the other screen. It's in the same instance of Excel. I'll bring it back from the other screen. You can see that there's 2 different workbooks open here.
Each one has their own ribbon. So, I can be on the INSERT tab in this one, and, on the other screen, in the FORMULAS tab. They don't share the same ribbon anymore. This is called SDI. Word’s had it. PowerPoint…it got…PowerPoint got it last time in Excel 2010. For those who write macros, this would make your life slightly miserable, but for everyone else, the people just want to show 2 Excel workbooks on 2 different screens, it is a beautiful thing.
Alright. Hey, remember to send your contest entry in and thank you for stopping by. We’ll see you next time for another netcast from MrExcel.
Learn Excel From MrExcel Podcast, Excel 2013 Preview Excel With Attitude.
Hey, everyone. This is Bill Jelen. All week, we’ve been taking a look at the new things in Excel 2013 and I've been doing all kinds of things in Excel 2013. I just want to refresh your memory here. We're going to do CONTROL+H, I'm going to replace MOTORS with MOTOS. I don't know why. ALT+A. EXCEL HAS COMPLETED ITS SEARCH AND HAS MADE 3 REPLACEMENTS. You've seen that thousands of times, right? It was late, late, late one night. I'd written, you know, lots of pages that day, and I did a CONTROL+H and I replaced MOTORS with MOTOS, and I said REPLACE ALL. ALL DONE. WE MADE 60 REPLACEMENTS, you know.
So, there’s a mailing list [ of some MVPs that the Excel PMs – 00:48 ] are monitoring, and I said, really, are you guys just…are you serious? Did you change this message, and they came back in and they said, it's our new attitude and we like it. I said that's cool. So, then, I went out and I started to figure out, you know, what other messages just drive me crazy. Here, let's go back to Excel 2010 and I want to insert a new row in a pivot table. ALT+I R. Oh my god, I haven’t…this is so long, I’d fall asleep by the time I'm done. I'm not even going to read it to you. Let's go to Excel 2013 and we'll go to the pivot table, this one, and same thing, ALT+I R, and it's a lot shorter now. I mean, there's a chance I'm going to actually read this, WE CAN’T MAKE THIS CHANGE, although, I said, you really should have made it a little bit more friendly than that.
Here's another one. How about circular references?
Oh my gosh. In Excel 2010, = that and then this is = to this. CIRUCLAR REFERENCE WARNING and it goes on and on and on and on, and no one actually reads this. They just click OK, right, but now we'll try it in Excel 2013.
Same thing. That formula is there. This formula’s here. Hey. Careful. CAREFUL, WE FOUND ONE OR MORE CIRCULAR REFERENCES IN YOUR WORKBOOK THAT MIGHT CAUSE YOUR FORMULAS TO CALCUALTE INCORRECTLY. For your…FYI. FYI. That's great.
A CIRCULAR REFERENCE CAN BE A FORMULA THAT REFERS TO ITS OWN CELL VALUE, OR REFERS TO A CELL DEPENDENT ON ITS OWN CELL VALUE, alright and I'm sure there's more.
You know, I started going through and just trying to do all crazy things I could think of that cause the messages to pop up and see these new attitude messages, and I realized this is a grand opportunity, right? Some messages we'd like to see, you know? For example, we are truly bummed out that we can't let you insert those rows in our pivot table, but to learn about some workarounds, click here, and then actually show them how to use the blank rows when they clicked here, or you've got a circular reference, just reboot the computer and start over.
So, here's the opportunity. For those of you who have your favorite or least favorite Excel message, the thing that pops up that just irritates the heck out of you, how would you like to have that rewritten, right? So, go ahead. If you're watching at YouTube or at learnmrexcel.wordpress.com, go ahead and post the comments. We’ll take a look at the best ones of those. There should be some funny ones. So, just get creative. We'll come up with a suitable prize, I'm sure for the…or maybe we’ll put your message on a mug. I don't know. Who knows? We'll come up with something. So, I think it's good, you know.
Excel has attitude.
Let's actually take a look at something serious here Now, so, [ unintelligible – 03:35 ], 640 by 480, but in real life, how many of you have 2 monitors? I mean, I have the laptop monitor and, then, on the right hand side, I’ve got a drive-in movie screen out there now, and I have that everywhere. Down at the office, I have that. Up where I write, I have that. Here at the podcast studio, I have that.
There's 2 monitors everywhere, and 2 monitors in Excel did not work well together in Excel 2010. That was one of the big downfalls, but now it's something called singular document interface.
So, if we have 2 Excel documents, open your…I’ll do CONTROL+N for new, every document gets its own ribbon. I can take this document.
Now, you're not going to be able to see this.
I just moved it out to the other screen. It's in the same instance of Excel. I'll bring it back from the other screen. You can see that there's 2 different workbooks open here.
Each one has their own ribbon. So, I can be on the INSERT tab in this one, and, on the other screen, in the FORMULAS tab. They don't share the same ribbon anymore. This is called SDI. Word’s had it. PowerPoint…it got…PowerPoint got it last time in Excel 2010. For those who write macros, this would make your life slightly miserable, but for everyone else, the people just want to show 2 Excel workbooks on 2 different screens, it is a beautiful thing.
Alright. Hey, remember to send your contest entry in and thank you for stopping by. We’ll see you next time for another netcast from MrExcel.
