MrExcel Excel Videos

Rahim needs a solution: "When I change the date, I need it to Sum all of the figures of that region - SUMIF is not working." Using =MATCH, =SUMIF, =OFFSET, =INDEX and more, Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen come up with Formula based solutions to reach a solution for Rahim. Follow along with Episode #1707 and see how you can Sum a Range as Data is changed. Dueling Excel Podcast #123...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 as a DVD Bundle] Slaying Excel Dragons and "Learn Excel 2007 through Excel 2010 from MrExcel"...

Bill was conducting a seminar yesterday and was asked to wrap a Formula around existing Formulas. Today, in Episode #1705, Bill addresses this question and shows us what can be done to accomplish the 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 for all of your Microsoft Excel Needs!

Imagine This: You have a Sales chart displaying your particular transactions. Everything looks good until you are looking at unfilled, future dates - it looks as though your company has gone off the map! Today, in Episode #1704, Bill "MrExcel" Jelen shows us how to deal with the 'Drop to Zero' issue for future dates in our Chart. For more information on Charts and Graphs in Excel 2013, see bill Jelen's new book "Excel 2013 Charts and Graphs". Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly... so you drive your message home, and get the decisions and actions you're looking for! This book reveals data visualization techniques you won't find anywhere else and shows you...

He may not be able to spell Choropleth... but he can tell us about it! After Bill's latest week-long series centering on Microsoft GoeFlow, using Real Estate and Property locations [to find a Home in Florida, USA], a question came in about Heat Mapping. Today, in Episode #1703, MrExcel addresses 'Choropleth' Heat Mapping with the current Beta version of Microsoft GeoFlow. [youtube=] And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges...

Annabeth enters Credit Card Numbers, along with other information into an Excel Spreadsheet. The issue is that the last two numbers of the card number is lost. How do we get the full card number into a cell? Change the Cell Formatting so that the number is seen as Text and not a number. But then... there is more. And - of course - Bill and Mike have differing ideas about solving the issues. Follow along with Episode #1702 as Mike "ExcelisFun" Girvin and Bill "MrExcel" Jelen provide their solutions and allow you to choose which one works for you. Dueling Excel Podcast #122...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...

Finishing off the week-long series, Bill looks at the probability that this grid may not become a reality. The Grid, a Random selection of 676 Letters placed into a 26 x 26 Grid, without Repeats in Each Row and without Repeats in Each Column. Follow along with Episode #1701 to find out if creating this Grid in Microsoft Excel is possible. The macro can be downloaded from Dealing with a Puzzle "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen...

Bill is still working with our Randomly Generated Letter Grid today. The twist in today's Podcast is to produce a 26 x 26 Random Letter Grid with no Repeats in each Row and no Repeats in each column. Follow along with MrExcel, in Episode #1700, to see 'if' this can be done. "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Excel 2013 In Depth "The Learn Excel from MrExcel Podcast...

Yesterday, in Episode #1698, Bill looked at Generating Letters Randomly. Today, in Episode #1699, Bill will look at how to Generate Letters in Excel Randomly with No Repeats, Following along with MrExcel learn how to add a magic touch to the work in order to generate a 26 x 26 grid of Random Letters with No Repeats in each of the Rows. And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly...

Chris wants to generate Random Letters in a 26 x 26 Grid. Using the Ascii set of letters and a few tricks, Bill "MrExcel" Jelen shows us how to produce the grid in question. Follow along with Bill, in Episode #1698, as he goes through the 'how-to' on this topic and shows us the results. And for more information on Excel 2013, check out "Microsoft 2013 InDepth" -- by Bill Jelen. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013. Excel...