MrExcel Excel Videos

Starting on August 16, 2013, the stand-alone boxed edition of Excel 2013 now includes Power Pivot and Power View. Amazon currently sells this edition for $98: Amazon.com: Microsoft Excel 2013 Key Card (1PC/1User): Software From Bill Jelen: "Microsoft marketing has made it incredibly difficult to buy Excel 2013 with PowerPivot. I've heard a lot of people say that they won't upgrade and will stick with Office 2010 forever, but this really isn't practical. In today's video, I offer a workaround that will allow individuals or small companies to actually purchase Excel 2013 with PowerPivot 2013.

Another set of Microsoft Excel Tips from Bill's latest Seminar in Orlando, Florida this year. Do you know about the "Customize Quick Access Toolbar" dialog in Excel? If not, today is your lucky day because today, with Podcast Episode #1648, Bill shows us how to Customize The Quick Access Toolbar by adding 'Close All' and 'Switch Windows'. If you've never used this 'Customizing' ability, you may be interested to know that instead of going through multiple clicks to find a command, you can apply your choice Functions to the 'Quick Access Toolbar' to make them "One-Click-Ready"! ...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...

Any operation in Excel can be repeated in Excel - and this ability is extremely helpful and time saving if you have repetitive operations to perform. Follow along with Bill in Episode #1647 to Learn the technique and see it in action! ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Today is our last podcast in our first "Don't Fear The Spreadsheet" series. Tyler asks: "I hear and see all of this information about VLOOKUP - What is is and what is the big deal? Follow along with Bill in Episode #1646 to learn what VLOOKUP is, what it can do and why you will find it more useful than you imagined. Bill Also covers a site devoted to VLOOKUP as well as other resources. If you are just starting out in Excel or you want to go back and find the things that you missed when you started using Excel, then "Don't Fear the Spreadsheet" is the 'Beginner Oriented' Excel How-To book for you. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers...

Today, coming down to the last in our "Don't Fear The Spreadsheet" series on Learn Excel from MrExcel, Tyler wants to know what some of Bill's Favorite Excel Functions are. Follow along with Episode #1645 as Bill covers a variety of Excel Functions that are useful, effective, efficient and worth learning as you grow your knowledge of Microsoft Excel. If you are just starting out in Excel or you want to go back and find the things that you missed when you started using Excel, then "Don't Fear the Spreadsheet" is the 'Beginner Oriented' Excel How-To book for you. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs...

Leon runs a Macro that copies previously filtered records, per Worksheet, in his Workbook. This works great, but it presents a bit of a problem. The issue is that the Headings are also being copied - Leon does not need the headings each time the Macro runs and the data is copied. Follow along with Bill 'MrExcel' Jelen today, in Episode #1644 as he discerns the issue, institutes the necessary change and produces those copies without the Headings each time. Learn More about VBA/Macros [Visual Basic for Applications] and how it can really ease your work-day! Look for Bill's book, "VBA and Macros: Microsoft Excel 2010" by Bill Jelen and Tracy Syrstad. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA...

Bill brings us another Podcast in the "Things that I Learned at Trainertage" Series. [To get a background on 'Trainertage 2013, see the first episode in this new series: "Dynamic Range Without OFFSET" Podcast #1632] Bill really likes Formatting. Today, in Episode #1643, MrExcel takes us on a tour of Formatting in Microsoft Excel that is likely to change the way you see your data from now forward. ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel...

By now, we should know to expect the unusual with the "Learn Excel from MrExcel" Podcast Series...Richard wants to use a VLOOKUP to to find two Values, but Bill thinks that there is a better way to achieve the result using =SUMIFs. Following along with Episode #1642, see how MrExcel uses =SUMIFs to show us a more efficient means than using VLOOKUP for this task. ...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! Power Excel With MrExcel - 2017 Edition "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com...

Once again, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen show us multiple methods of achieving our intended result. Today, in Episode #1641 The Dueling Excel Podcast takes on finding the Address of Matching Cells. Carlos want to find the exact match to a Value in his Data Matrix and return the Address of the Cell which cntains that Value. Mike and Bill take different approaches to the question and the means to obtaining the result. Follow along to see how it is done! Dueling Excel Podcast #110...This episode is the video podcast companion to the book, "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and...