Learn Excel from Bill Jelen with this daily 2 minute video podcast.

## Wednesday, February 28, 2007

### Episode 454 - Lotto Probability

Scott from Australia sent in what should have been a simple lotto question. However, I chose to solve the problem using an array formula. Now, as far as I know, no one has ever tried to explain an array formula in a 2 minute podcast. Episode 454 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Tuesday, February 27, 2007

### Episode 453 - MegaMillions Lottery

After Scott’s question for tomorrow’s podcast, I thought it would be cool to see how a pivot table could analyze the most popular lottery numbers. The MegaMillions jackpot in several US states is up to \$216 million and today’s podcast will select the most popular numbers. Episode 453 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Monday, February 26, 2007

### Episode 452 - Formula for Worksheet Name

Rupal asks how to return the worksheet name as the result of a formula. Episode 452 shows the obscure function which can be adapted to solve this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Friday, February 23, 2007

### Episode 451 - Filling an Outline

Heidi asks a question that is a new twist on an old problem – how to fill in the blank cells in a range with an outline numbering system. Episode 451 shows how to adapt the technique discussed in Learn Excel to solve this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

## Thursday, February 22, 2007

### Episode 450 - Hidden Column Tricks

As a follow-up to yesterday’s netcast, Episode 450 shows you how to unhide column A and a cool trick left over from Lotus 1-2-3 where you can see what is in the hidden columns without unhiding them.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Wednesday, February 21, 2007

### Episode 449 - Unhide One Column

Stuart from the UK asks: say that you have columns B through H hidden and want to unhide only one of those columns? Episode 449 will take a look at the process of hiding and unhiding columns. Although I had never tried it before Stuart posed the question, it seems that there is a way to unhide just that one column.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Tuesday, February 20, 2007

### Episode 448 - Cone Chart Lies

Another popular way for people to lie with charts is to use a cone or pyramid chart. Episode 448 shows why your radar should go up anytime you see someone presenting data using these chart types.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the books!

Labels:

## Monday, February 19, 2007

### Episode 447 - Dates as Numbers

Here is a bizarre problem sent in by a viewer. Many of you will think that you know the answer, but this problem is not as simple as it appears. In a worksheet, any dates are instantly converted to their 5 digit serial number. The actual date is shown in the formula bar, but the worksheet cells show the underlying serial number. Yes – my first thought was that someone had formatted the worksheet using a Number format, but this is not the problem. Hint: this is a simple spreadsheet set up to log information, and there is not a single formula anywhere in the worksheet. Episode 447 solves the mystery.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Friday, February 16, 2007

### Episode 446 - PieChart Lies

Watch out when someone tips a pie chart backwards to show a 3-D perspective. They are either unintentionally or intentionally trying to misrepresent the data. Episode 446 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Thursday, February 15, 2007

### Episode 445 - Filter Copying

A question from Mike in Oklahoma City. Excel is supposed to copy only the visible rows in a dataset where AutoFilter is turned on. However, sometimes this does not work. Episode 445 shows the simple shortcut to make sure that you have only the visible rows.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , ,

## Wednesday, February 14, 2007

### Episode 444 - Overlay Charts

In a recent charting challenge, Jerome Sullivan sent in an interesting chart where the budget and actual numbers were actually plotted on top of each other. Episode 444 shows the non-intuitive steps required to create this type of chart.

This blog is the video podcast companion to the book, Learn Excel from MrExcel and Charts and Graphs for Microsoft Office Excel 2007. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

## Tuesday, February 13, 2007

### Episode 443 - Undo Toolbar Customizations

If you have inherited a computer where someone has customized your toolbars, you might want to go back to the default, out-of-the-box set of toolbars. Episode 443 will show you how to reset your standard toolbar, the formatting toolbar, and your worksheet menu bar to undo any rogue customizations.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Monday, February 12, 2007

### Episode 442 - Combo Chart

How to create a combination chart that includes both stacked columns and a line chart. Episode 442 shows you how.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: ,

## Friday, February 09, 2007

### Episode 441 - Paste Formulas

Eric from Shanghai writes in with a question about adding a Paste Formulas icon to the standard toolbar in Excel. While Excel only offers custom buttons for Paste Values and Paste Formats, Episode 441 will help you discover how to get a Paste Formulas icon on your toolbar.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Thursday, February 08, 2007

### Episode 440 - Virtual AutoFilters

Excel 2007 does offer a number of improvements in the AutoFilter arena. Episode 440 shows the new virtual date filters, such as selecting records from this week, next month, or last quarter.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: , ,

## Wednesday, February 07, 2007

### Episode 439 - AutoFilter Woes

Jim from Montreal calls in wondering why the AutoFilter dropdowns changed radically in Excel 2007. Episode 439 takes a look at the old AutoFilter, and the new AutoFilter.

This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every workday to learn a tip for both versions of Excel!

Labels: ,

## Tuesday, February 06, 2007

### Episode 438 - Translate

Excel 2007 offers an oddity - an icon to do translations between 20 different languages. Episode 438 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: ,

## Monday, February 05, 2007

### Episode 437 - Adding Without Formulas

Did you ever notice the status bar below your spreadsheet? Select some numbers in Excel and the totals will appear in the status bar. In Episode 437, learn how to change the number shown in the status bar, and also the new enhancements in Excel 2007.

This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every workday to learn a tip for both versions of Excel!

Labels:

## Friday, February 02, 2007

### Episode 436 - Goal Seek

Use the Goal Seek function to back into an answer. Episode 436 shows you how.

This blog is the video netcast companion to the books Learn Excel from MrExcel and Excel 2007 Miracle Made Easy. Download a new two minute video every workday to learn a tip for both versions of Excel!

Labels:

## Thursday, February 01, 2007

### Episode 435 - OneNote

The Home & Student edition of Office 2007 includes a product that may be new to you - OneNote 2007. Episode 435 takes a quick tour of OneNote.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Labels: ,