MrExcel Excel Videos

In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill shows us alternative ways to set up a visual Comparative Histogram without using a Chart, thus giving us more options to represent our data. ...This episode is the video podcast companion to the book, "Charts And Graphs: Microsoft Excel 2010", by Bill Jelen a.k.a. MrExcel. Charts and Graphs: Microsoft Excel 2010 For more Excel 2010 knowledge, check out "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. Microsoft Excel 2010 In Depth by Bill Jelen For all of your Microsoft Excel needs visit MrExcel.com -- Your One Stop for Excel Tips and Solutions. MrExcel

JB asks, "How can I create a Comparative Histogram?" Today, in Episode #1522, Bill shows us how to set up our Data, create Data Lables, and Formatting for creating a Comparative Histogram Chart. Today's Episode is brought to you by "Easy-XL". Easy-XL From MrExcel adds over 50 time saving data analysis and manipulation features to Excel. Check it out here http://www.easy-xl.com/ ...This episode 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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel...

Bill looks at pasting Values today, in Episode #1521. Using one line of VBA code, Bill shows us how to convert Formulas to Values. Learn how to quickly - and Easily - modify your recorded macro [using the Macro Recorder] to Paste Values with one click. ...Today's Podcast topic may be found in 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 learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today's episode is a reversal of Episode #1517. In Episode #1520, Bill looks at two ways to solve the problem where you have text and a date in the same cell and the goal is to isolate only the date. [*Note - Bill mentions Episode #1518 in this podcast, but he is actually referring to Episode #1517*] ...This episode 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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today Bill shows us how to use the Macro Recorder to record the action of Double-clicking the Fill Handle. It isn't as straight-forward as you might think, but it can be done with only the macro recorder. Follow along with Bill in Episode #1519 to learn how. ...Today's Podcast topic may be found in 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 learning curve...Includes crucial information on making Excel 2010 VBA code work with older versions. MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

With a list of Products and a list of Dates, Bill's mission is to find the last order date for each product in the Dataset. Learn the use of MAXIF, changing Number Formats, and more in Episode #1518. [Previously slated as Episode #1516]

From a YouTube Viewer, Bill looks how to have text and actual dates reside in the same Cell. Follow along with Episode #1517 to learn how to add Custom text to your Date Field while retaining the actual Date. ...This episode 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! "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Bill "MrExcel" Jelen and Mike "ExcelisFun" Girvin compare data in columns to discern whether 'same' figures exist in both columns, by row. Bill goes the VBA Route and Mike chooses to use an Amazing Array Formula to get the query solved. "The Learn Excel from MrExcel Podcast Series" MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

We have a series of Dates. We want to show quarters for the year 2012. Bill 'MrExcel' Jelen goes Old School on this one while Mike 'ExcelisFun' Girvin goes for a more Functionally 'stream-lined' approach. Mike and Bill look at the =CEILING, =MONTH, VLOOKUP functions and more. Dueling Excel Podcast #97...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] and "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...