MrExcel Excel Videos

Power Pivot Mashup - Learn Excel from MrExcel: Podcast #1178

The MrExcel Podcast returns with a demo of how to mash up two data sets in PowerPivot. Episode #1178 shows you how. 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!

View full article »

Dueling Excel - 2 Item VLOOKUP: Podcast #1267

In this week's dueling Excel podcast (Episode #1267), Mike and Bill take a look at formulas to perform a lookup that requires two key values to be found and displayed. Visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

View full article »

Comparing Worksheets: Podcast #1266

Ray asks how to use Conditional Formatting to compare two worksheets. This feature is "new" in Excel 2010 - compare two sheets using Conditional Formatting. Today, in Episode #1266, Bill shows you how to work with this new feature. Learn Excel!

View full article »

Excel Rev Up - Backstage View: Podcast #1265

With Episode #1265, Bill takes us on a tour of the Excel 2010 File Menu. In this review of the Backstage View, Bill touches on a few pros and cons of the Excel 2010 File menu. ...Get the upgrade guide: "Rev Up to Excel 2010" by Bill Jelen

View full article »

Excel in Depth - Copying Subtotal Rows: Podcast #1264

Today, in Episode #1264, Bill shows us how to add Subtotals to an Excel Data Set and then copy only the Subtotal rows. ...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.

View full article »

Counting Spreadsheet Entries - Podcast #1263

Ron asks how to count how many times each model occurs in a column. Today, in Episode #1263, use a Pivot Table to quickly solve the problem and display results. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.

View full article »

Learn Excel - Joining Dates: Podcast #1262

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!

View full article »

Excel Rev Up - Protected Mode: Podcast #1261

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.

View full article »

PowerPivot Calculated Columns: Podcast #1260

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

View full article »