Bob Umlas' new book just arrived from the printer - "Excel Outside the Box: Unbelievable Excel Techniques". Today, Bill takes a look at the new book, tells you where you can buy an advanced copy, and shows you a trick from the book in Episode #1457.
...This blog 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!
"The Learn Excel from MrExcel Podcast Series"
MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!
...This blog 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!
"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 from MrExcel podcast, episode 1457: Excel outside the box.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
I’m radically excited today.
Anytime a new book shows up from the printer, it is always a good thing.
Check this out: Excel Outside the Box.
Now, this book is not by me.
This book is by my favorite Excel guy in the whole world: Bob Umlas.
Bob has been an MVP since the MVP program began.
He started using Excel, not in version 1, but in version 0.9, right, way back in the Mac.
Bob is the guy at the MVP summit that knows things that no one else-- none of the other Excel MVPs know.
So here he is in his-- he showed up this day-- one day, asked me about my vow of silence.
He's a funny guy but he's really, really smart about Excel.
He's done two other books that I think I mentioned in Excel.
This Isn’t Excel, It’s Magic! and This Isn’t Excel, It’s Magic!
Part 2.
You know, I run the Holy Macro!
Books publishing company and I think it is an incredible coup that I convinced Bob to write a third book and it is published by me.
Now, this book doesn't come out until April, but here is the wild thing.
I have copies.
So, even though the book stores won't start carrying it until April, just go to mrexcel.com and it's right here.
We have both an eBook and we have the print edition.
So, you can get it here.
What’s in it?
It has 54 amazing techniques.
From just straight Excel techniques, pivot tables, features, formulas-- his section on array formulas just made my head spin, a few chart things, some VBA-- for those of you who like VBA, some really hard things, the things that would be tough to do.
Bob has figured out how to do it in a little bit of VBA and then some miscellaneous.
So, again, coming out in April, but I have it now.
It's the super-secret on all secrets.
It is right on my home page there; a chance for you to get this book.
So, today's podcast-- today's podcast is something I'm stealing from Bob's book.
This is just one of the very simple examples, you know.
This is another one of those advanced Excel books.
Don't buy this if you're a beginner.
You will hate it.
This is for the people that use Excel all the time and will love these new techniques we have.
So, someone wrote in and they need to fill this series on the fifteenth of the month and the last of the month, all right?
When you try and fill this, it fails miserably because then we get the 16th, the 18th, the 19th, the 20th and it doesn't give you the last of the month.
The 2nd, the 3rd, the 4th, the 7th, the 8th and so on.
Bob gives us a really complicated formula way to do it, but then he also points out that hey, it's really easy.
Just right-click, right-click the fill handle and drag and let go and choose fill months and it does exactly what you need.
That's incredible.
Now, that's just one of the 54 and it's one of the simplest of the 54 because most of the things would take too long to do on the podcast.
Bob, I’m going to say, great friend of mine, an amazing Excel guy.
I always say he's the smartest Excel guy I know and his new book Excel Outside the Box coming in April, but available from mrexcel.com right now.
Check it out.
Hey, well, 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 1457: Excel outside the box.
Hey, welcome back to the MrExcel netcast.
I'm Bill Jelen.
I’m radically excited today.
Anytime a new book shows up from the printer, it is always a good thing.
Check this out: Excel Outside the Box.
Now, this book is not by me.
This book is by my favorite Excel guy in the whole world: Bob Umlas.
Bob has been an MVP since the MVP program began.
He started using Excel, not in version 1, but in version 0.9, right, way back in the Mac.
Bob is the guy at the MVP summit that knows things that no one else-- none of the other Excel MVPs know.
So here he is in his-- he showed up this day-- one day, asked me about my vow of silence.
He's a funny guy but he's really, really smart about Excel.
He's done two other books that I think I mentioned in Excel.
This Isn’t Excel, It’s Magic! and This Isn’t Excel, It’s Magic!
Part 2.
You know, I run the Holy Macro!
Books publishing company and I think it is an incredible coup that I convinced Bob to write a third book and it is published by me.
Now, this book doesn't come out until April, but here is the wild thing.
I have copies.
So, even though the book stores won't start carrying it until April, just go to mrexcel.com and it's right here.
We have both an eBook and we have the print edition.
So, you can get it here.
What’s in it?
It has 54 amazing techniques.
From just straight Excel techniques, pivot tables, features, formulas-- his section on array formulas just made my head spin, a few chart things, some VBA-- for those of you who like VBA, some really hard things, the things that would be tough to do.
Bob has figured out how to do it in a little bit of VBA and then some miscellaneous.
So, again, coming out in April, but I have it now.
It's the super-secret on all secrets.
It is right on my home page there; a chance for you to get this book.
So, today's podcast-- today's podcast is something I'm stealing from Bob's book.
This is just one of the very simple examples, you know.
This is another one of those advanced Excel books.
Don't buy this if you're a beginner.
You will hate it.
This is for the people that use Excel all the time and will love these new techniques we have.
So, someone wrote in and they need to fill this series on the fifteenth of the month and the last of the month, all right?
When you try and fill this, it fails miserably because then we get the 16th, the 18th, the 19th, the 20th and it doesn't give you the last of the month.
The 2nd, the 3rd, the 4th, the 7th, the 8th and so on.
Bob gives us a really complicated formula way to do it, but then he also points out that hey, it's really easy.
Just right-click, right-click the fill handle and drag and let go and choose fill months and it does exactly what you need.
That's incredible.
Now, that's just one of the 54 and it's one of the simplest of the 54 because most of the things would take too long to do on the podcast.
Bob, I’m going to say, great friend of mine, an amazing Excel guy.
I always say he's the smartest Excel guy I know and his new book Excel Outside the Box coming in April, but available from mrexcel.com right now.
Check it out.
Hey, well, I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
