MrExcel Excel Videos

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

More things that Bill learned at Trainertage 2013.

Todays Excel Question goes like this... We want to figure out a Tier One bonus, a Tier two bonus and they are tied to a lot of rules; how can we sort this out? And since Bill recognizes immediately that this question is only good for one person's use, this turns into a great lesson on Bonus Calculation, Formula Structure and more. Follow along with Episode #1639 to learn a lot in a short "Learn Excel from MrExcel" Podcast! Thank you Bill! ...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...

Well...In Excel 2013 the Ribbon Menu has items identified in All Caps. Some people have found this 'All Caps' Menu to be very annoying - so...get rid of it! How? Today, in Episode #1638, Bill 'MrExcel' Jelen shows us how! And this trick not only applies to Excel 2013, but to all of the Office 2013 Applications! [Incidentally, I just want to point out that this is not a trick that Bill learned at Trainertage 2013; it is a trick that he learned from a Microsoft Power Point MVP and Guru - Ute Simon.] ...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...

Bill Explains it like a 'Swiss Army Knife' - which is a bit...odd... but it really does make sense. Ron is trying to get a better understanding of the use of OFFSET...but sometimes there are better means to an end. Follow along with Bill Today, in Episode #1637, as he explains the functionality of the 'Swiss Army Knife', the OFFSET Function and where each applies. ...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...

Another Dueling Excel Episode with Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen! Today, a really confusing title with a simple objective: "1234Burchy" wants to Find the Slowest time that is 'within' Two (2) Seconds of the Fastest Time. Bill reaches back to a Function =DMIN, which he hasn't used in years... Mike opts for a twist to Bill's set up and takes a practical look at the =SMALL Function. Follow along with Episode #1636 to see how Mike and Bill arrive at a Duel-Solution to this quest. 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...