MrExcel Excel Videos

How can you do a lookup to find records that match 2 columns? Episode 1203 shows how to use a concatenated key to solve the problem.

Bob from Kalamazoo shares a trick of how to fill a range of cells from 1 to 500000 in a couple of mouse clicks. Also, another way to have the fill handle work to fill 1, 2, 3. Episode 1202 shows you how.

Welcome to 'Time Warp Wednesday'! Today, the first MrExcel Podcast [created October, 2005]. Episode 101 deals with Excel Menus and how to work the Excel user interface so that all menu items are readily visible to the user. Thank You for Viewing! Here is why the first video debuted in October 2005: It is because Apple released the fifth-generation iPod on October 12, 2005. It had a 2.5 inch 320×240 QVGA screen. It was the first iPod to be able to play videos.

Deb from Wisconsin noticed that her date grouping was wiped out after refreshing a pivot table. Episode 1201 takes a look at how to find the bad dates and solve the problem. Learn Excel 97-2007 from MrExcel!

MrExcel's 1100th Podcast - almost became 'The Lost Episode'. Here is a great trick with the Speak Cells tools. Episode 1200 shows you how. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.

Susan asks..."I have been using SUMPRODUCT a lot ever since you showed me how since I cant use SUMIFS for users with pre-2007 version. But, is there an AVERAGEPRODUCT or something similar? How about MAXPRODUCT?"

Episode 1198 takes a look at the Nudge Selection tool in Easy-XL. ...This blog is the video podcast companion to the book,Learn Excel 97-2007 from MrExcel.

Jim from California asks why it takes two clicks to create a new workbook in Excel 2007. Episode 1197 shows you the solution. Learn Excel 97-2007 from MrExcel.com

Patrick from Alaska asks how to copy a chart but detach it from the original data set. In this Dueling Excel podcast, Mike and Bill show you various solutions. Learn Excel 97-2007 from MrExcel