MrExcel Excel Videos

The Preview is Ending! Free Stuff! And Something New that you may not have seen in Excel 2013! This is Bill's First Podcast about "Power View" - a New Feature in Excel 2013! This is very powerful dashboarding tool that is new to Excel for 2013. Note that Today's podcast stretches to 9 minutes because of the cool stuff we have to talk about today! Also, The free preview download of Office365 is about to end. This is your 'Last' chance to try for FREE. Bill said early this morning that he is seeing the news stories on the Network news showing Office 2013, so it is here. Finally, a Giveaway! Download your FREE Trial Version of Office365 today or tomorrow and send Bill a screenshot of the download. First Prizes: $99 one-year...

Mike has 75,000 Data Points with three Values per Record. He wants to convert those Values to RGB and apply the color. This is an interesting proposition - but can it be done? Of course it can - this is Microsoft Excel! Today, in Episode #1633, Bill takes a look at the mechanics of RGB color and then shows us a six line Macro to convert the Values and apply RGB. ...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...

Today, a new podcast series: "Things that I Learned at Trainertage", by Bill 'MrExcel' Jelen. I spent a week in Lucerne Switzerland at the 8th annual Trainer Days. This is a team of Microsoft Office Trainers who began getting together once a year to teach each other new tricks in Office. Today, they allow others to attend. I was their guest speaker for Trainertage 2013. Now, the obvious problem: I don't speak German. But they were patient. I spoke slowly, and everyone got along well. My friend Tony Dejonker helped with translation during my first session, but it was decided that my "Slow English" was good enough for the remaining three sessions. First observation: doing training for other trainers is tougher than my normal...

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...