Time Warp Wednesday - Excel Menus: Podcast 101

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 menu items are readily visible to the user. Enjoy and Thank You for Viewing!

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

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.

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

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.

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

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.

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

Nudge Selection - Episode 1198

Use the Selection Navigator in Easy-XL to nudge the selection. Episode 1198 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!

To learn more about the Easy-XL Addin, visit the Easy-XL website.

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.

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

Paste Values Chart - Episode 1196

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

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

Sparkline Shading - Episode 1195

As envisioned by Professor Tufte, sparklines could have a bit of shading to show the acceptable ranges. While this is not necessarily built in to Excel 2010, you can achieve the same effect. Episode 1195 show 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!

Sparkline Labels - Episode 1194

In Episode 1194, we take a look at how to add labels to your sparklines.

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

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.

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

Scale to Fit - Episode 1192

Mary asks about how to force a report to fit to one page wide. Episode 1192 takes a look at Layout mode, Scale to Fit, and orientation.

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

Validation Tooltip Trick - Episode 1191

This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Changing the location for the Validation Tooltip box? Maybe there is a use for this, or maybe not. Episode 1191 will show 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!

Add Print Area - Episode 1190

Excel 2007 offers a new way to set up non-contiguous print ranges. Episode 1190 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!

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.

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

Offset Lookup - Episode 1188

Find a value in this row and then get the values 1 and 2 columns to the right of that value. Mike and Bill duel it out in Episode 1188.

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

Fill Handle Regression - Episode 1187

A lot of behind-the-scenes math goes into dragging the fill handle...
Howie asks why the fill handle does what it does when you select four numbers and drag. Episode 1187 discusses trend lines, LINEST, and straight line regression.

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

Row Height .18"? - Episode 1186

In today's podcast, a quick way to hide the column headers, and a row height in inches Episode 1186 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!

Counting Mondays - Episode 1185

Mike and Bill get together for another live dueling podcast, counting the number of Mondays between two dates. Episode 1185 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!

Pivot SmartArt - 1184

Create a pivot table that drives a SmartArt diagram. Episode 1184 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!

Q1, Q2, H1 - Episode 1183

Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Episode 1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details!

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

Plus / Minus - 1182 Dueling Excel

Today's 'Dueling Excel' podcast - Episode 1182, with Bill Jelen and Mike Gel Girvin - shows you how to visually present statistical values (+/-) in a cell.

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

Dynamic Charting - 1181

Today, learn how to create a dropdown that allows you to change the chart displayed on your worksheet! View Episode 1181 to learn this tip!

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!

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.

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

Turn Data - 1173

Paula asks how to take a range and turn it on its side.
Episode 1173 Episode 1173 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!

Picture Lookup - 1172 - Dueling Excel

Today's dueling Excel podcast shows how to do a picture lookup in Excel.
Episode 1172 Episode 1172 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!

Concatenated Lookup? 1171a - 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 1171 Episode 1171 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!

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.

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

Microsoft First? 1170 Learn Excel Podcast

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution.

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!

MrExcel's Learn Excel #977 - Filtered Paste

Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way.

This video is the 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!

Episode 674 - Negative Invert

Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show 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!

Episode 673 - Custom Numbers

Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However... now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find.

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!