MrExcel Excel Videos

Rick from Alabama sends in today's question: "How can I join two date cells into a single cell?" While Excel initially won't cooperate, Episode #1262 shows the function that you can use to answer this question. Learn Excel 97-2007 from MrExcel!

Chapter 3 of "Rev Up to Excel 2010" by Bill Jelen is about the new Excel 2010 Protected Mode. In this podcast, you will learn how to use Protected Mode to review a suspicious workbook before opening the workbook for editing.

Today, in Episode #1260, Bill investigates Calculated Columns in the PowerPivot grid using DAX. Also, tips to Format your data for a more visually aesthetic result using PowerPivot and Excel 2010 ... from Bill Jelen a.k.a."MrExcel".

Paul from Las Vegas offers a great workaround to underlining your headings! Some managers resort to adding tiny little columns between their columns to avoid this problem. Using the trick in Episode #1259, create better looking headings in Excel.

Creating a frequency distribution is one of the hardest things to do in Excel, because the function returns an array of values. Episode #1258 will help you group your data into 'Bins' and create a 'Bins Array' using the Frequency Function - Excel 2010

Diane from Alabama asks how to make a copy of a pivot table report for every region in a database. Episode #1257 shows you how, as well as a few other pivot table tricks such as rolling daily dates up to years and showing the top 5 customers.

In today's Dueling Excel Podcast [Episode #1256], Mike and Bill work on a formula that adds up all of the non #N/A values in a range. Traditional Excel meets Excel 2010 - and a few new menu items! ...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. AND "Slaying Excel Dragons: A Beginners Guide to Conquering Excel's Frustrations and Making Excel Fun", by Mike Girvin and Bill Jelen. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

One of the great things to return to Excel 2010 is the ability to customize the ribbon - without knowing XML and without being a programmer! Customize the Ribbon in Excel 2010 to make the interface more efficient for your needs. Episode #1255 and Chapter 2 of "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen show you how. This episode is the video podcast companion to the book, "Rev Up to Excel 2010: Upgraders Guide to Excel 2010", by Bill Jelen a.k.a. "MrExcel". For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

As a follow-up to Episode #1252, "Once you've used the HLOOKUP to return the last value in the row, can you find the date associated with that entry?" Yes, you can! Today, in Episode #1254, Bill shows us how to locate the last value in a row of data and return that value to our designated cell using the INDEX and MATCH Functions. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!