MrExcel Excel Videos

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

Today's Dueling Excel Podcast, with Mike 'ExcelisFun' Girvin and Bill 'MrExcel' Jelen, looks at finding the Minimum and Maximum between Two Dates for Each Region. Follow along with Mike and Bill, in Episode #1697, as they find individual solutions to reach the objective for the today's Duel. Dueling Excel Podcast #120...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". Download a new two minute video every workday to learn one of the 512 Excel...

The Criteria: "If the Date is within the Taget Range, Color the Cell Green; If the Date is previous to the Target Range, Color the Cell Red and show the Number of Days Previous to the Target Range; If the Date is Greater than the Target Range, Color the Cell Blue and show the Number of Days forward from the Target Range." Uh... Really? Ok, well - as always - MrExcel comes to the rescue with a viable solution to reach the objective. Follow along with Episode #1696 as Bill shows us how to achieve the 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 Tips than the...

Do you remember Dan Mayoh from the 'ModelOff World Excel Championships' held in December of 2012 [refer to Podcast #1610 - ]? Dan suggested the latest in 'The MrExcel Challenge' series. Follow along today with Bill "MrExcel" Jelen, in Episode #1695, as he lays out the the goal of this current MrExcel Challenge as well as all of the details and prizes! Today's Podcast is sponsored by "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! 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition And if you are using Excel 2013, you may want to check out... "Microsoft 2013 InDepth" -- by Bill Jelen...