Videos tagged with Excel

Over the past several months, many emails and messages have come to us asking about earlier MrExcel Podcasts. In an attempt to make even the earliest episodes available, we are introducing... "Time Warp Wednesday".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 men...

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

Well, it was supposed to be for April Fools day, but after a slight mix up here Episode 1200 - MrExcel's 1100th Podcast - almost became 'The Lost Episode'.Here is a great trick with the Speak Cells tools. Episode 1200 shows you how....

Susan asks..."I have been using SUMPRODUCT a lot ever since you showed me how – since I can’t use SUMIFS for users with pre-2007 version. But, is there an AVERAGEPRODUCT or something similar? I know about AVERAGEIFS but, again, it can’t be used by pre-2007 version users. How about MAXPRODUCT?" Episode 1199 shows you how....

A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 Episode 1174 show why and how to fix this problem forever....

Excel 2010 offers a cool trick that anyone with a browser can try out right now. You can view and edit your Excel workbooks in a browser. Episode 1189 shows you how to try it out....

Robert asks about using a pivot table to report on text values. This would be easy if Microsoft offered a way to specify "First" as the calculation, but they don't. Instead, episode 1193 shows a Pivot/VLOOKUP solution to the problem....

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.Episode 1170 Episode 1170 shows you how....

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

Paula asks how to take a range and turn it on its side.Episode 1173 shows you how.