MrExcel Excel Videos

The Looong awaited return is today! Dueling Excel with Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen return with a LOOKUP Spectacular! Today, in Episode #1631, Mike and Bill work out means to find a variety of results using differing methods of LOOKUP to get the figures. This one is tricky - one of the LOOKUPS uses the default but 'rarely-used' Approximate Match version of VLOOKUP. Follow along as Dueling Excel paves the way to a few tricks and shortcuts you may find useful. Dueling Excel Podcast #109...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...

Mike A. emailed in a Learn Excel from MrExcel Podcast Question. Having six (6) Columns of Data, Mike wants to count how many values in each Row are Even and how many are Odd. So, today in Episode #1630, we follow along as Bill 'MrExcel' Jelen explores the IsEven and IsOdd Functionality before creating an Array Formula to Count Even and odd in Mike's Data. ...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...

Jim wants to add a Page Break between each Department in a large Data file. Using Subtotals would be the fastest way, but he does not need a subtotal. So, instead of using Subtotals, in Episode 1629 Bill shows us a hybrid method. Using a Formula and 'Go To Special' to select the first record for each department, a short, 3-line Macro will add the Page Breaks right where Jim needs them. ...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"...

Cheryl reports that when she prints out her report from Excel, Excel randomly skips half a page on page 3. How bizarre is that? It turns out that Excel doesn't really behave randomly, it just seems that way. Today, in Episode *#1628, Bill teaches us about Manual Page Breaks, Margins, and Center on Page Vertically. ...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! *Note...

While at the ModelOff Championship Competition in New York City, NY in December 20102 Bill met Joseph McDaid. Joe was responsible for many of the questions that were posed to the contestants of the ModelOff 2012 Championship. Interestingly enough, Joe has also produced an interesting, free, add-in product created for Microsoft Excel called "Spreadsheet Studio". Today, in Episode *#1625, Bill tells us about 'Spreadsheet Studio' as he reviews the product in today's podcast. http://www.spreadsheetstudio.com/ You can find more information about the free 'Spreadsheet Studio' Add-In at the 'Spreadsheet Studio' website. http://www.spreadsheetstudio.com/ ...This blog is the video podcast companion to the book, Learn Excel 2007 through...

Due to time constraints, Tyler needs to set up a Chart and a Table and she would like to do both simultaneously. Can it be done? Of course! It's Microsoft Excel! Follow along with Episode #1625 as Bill "MrExcel" Jelen shows us how it's done with a little available 'control' in how the final product is produced. Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. 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 specializing in and dedicated to teaching others Microsoft Excel, from the...

As we come to the end of 2012 and our "Don't Fear The Spreadsheet" series... the ultimate question appears, as Tyler asks:"What is a Pivot Table?" Let me save you some time -- Watch This! Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel -- 'Don't Fear The Spreadsheet' actually will. 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 specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. Don't Fear the Spreadsheet And for more information about Pivot...

Most Popular Functions -#12 =NOW()- and -#13 =TODAY()- Over the summer of 2012 MrExcel started a series called "Most Popular [Excel] Functions"... but book writing and updating editions took the lead and our 'Most Popular Functions' series came to a pause. Today, Bill 'MrExcel' Jelen resumes the Most Popular [Excel] Functions series with the " =NOW " and " =TODAY " Functions. Follow along with Episode #1624 to see the differences between the two -- as well as a brief on " =INT(NOW( " -- and where each can be applied effectively! ...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...

*Note: I told Bill that we were on Podcast #1622...but what I should have said is "The next Podcast will be #1623". Though today's Podcast is labeled as #1622...it is actually #1623. Ok, now... Let's get to Today's Podcast! SJ needs to rearrange Data in her Spreadsheet but, the Data is delivered with Formulas so Paste Special with the Transpose Function is not going to work. In Episode #1623, Bill shows us how to use the =TRANSPOSE Formula with the Data while maintaining the integrity of the Formula Driven results. ...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...