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...
Learn Excel Episode 1201: Pivot Date Grouping - Episode 1201
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 Episode 1200: April Fools ? - Episode 1200! MrExcel's 1100th Podcast!
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....
Learn Excel Episode 1199: AVERAGEPRODUCT? - Episode 1199
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....
Learn Excel Episode 1174: Links Failing - 1174
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....
Learn Excel Episode 1189: Web Excel - Episode 1189
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....
Learn Excel Episode 1193: PivotTable Text - Episode 1193
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....
Learn Excel Episode 1170: Concatenated Lookup? 1171 - Learn Excel from MrExcel
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....
Learn Excel Episode 1197: New vs New... - Episode 1197
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 Episode 1173: Turn Data
Paula asks how to take a range and turn it on its side.Episode 1173 shows you how.