MrExcel Excel Videos

How can you highlight the lowest value in each row? Episode 1206 shows you the answer! Check out 376 other tips - Learn Excel 97-2007 from MrExcel.

Create a Top 10 in a Pivot Table report where the grand total shows the total for all customers, not just the top 10. Learn Excel 97-2007 from MrExcel. Get the book!

Solving the same problem from episode 1203, doing a VLOOKUP that matches two columns, but without using a concatenated key. This solution uses the OFFSET function to dynamically change the position of the lookup table.

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