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

Friday, August 31, 2007

Episode 584 - Refreshable Validation

Store your validation lists on a separate worksheet and have the dropdown boxes automatically expand when you add new items to the list. Episode 584 shows you how. If you'd like to try this out, download the sample workbook. Monday in the USA is our Labor Day holiday and I'll be back Tuesday, September 4th.

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, August 30, 2007

Episode 583 - Validation Lists Elsewhere

Brent asks how you can set up validation lists on another worksheet. This is generally considered invalid, but Episode 583 shows you how to pull it off.

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, August 29, 2007

Episode 582 - Validation Dropdowns

Brent asks if it is possible to make the data validation dropdown arrow appear on the left side of the cell. In Episode 582, I show you a horrible way to accomplish this, that will be entirely unacceptable to 99.9% of the audience.

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!

Tuesday, August 28, 2007

Episode 581 - Massive Page Breaks

Steve wonders how he can add a page break after every student in his gradebook. In Episode 581, I show an alternate solution, using the Page Setup.

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!

Monday, August 27, 2007

Episode 580 - Fixing Crystal

Susan writes in with an annoying problem. Crystal Reports is creating a report where every physical record is taking three rows in Excel. Episode 580 will walk through the steps necessary to get this into a nice sortable data set.

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!

Friday, August 24, 2007

Episode 579 - Double Click Fill Handle

One of my Greatest Hits – a fast way to copy a formula down to all rows. Episode 579 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:

Thursday, August 23, 2007

Episode 578 - Merge Words

Mike from Kansas City asks if there is a way to take words from many adjacent cells and merge them into a single cell. Episode 578 shows many approaches to 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: ,

Wednesday, August 22, 2007

Episode 577 - End of Month

Using the EOMonth function to find the end of a month N months in the future. Episode 577 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, August 21, 2007

Episode 576 - RSS Size

In today's Episode 576, I ask, "How many episodes of the MrExcel Podcast should we include in our RSS feed?"

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!

Monday, August 20, 2007

Episode 575 - Editing Formula Ranges

A quick trick showing how you can make a formula point to a new range without typing the range. Episode 575 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: , ,

Friday, August 17, 2007

Episode 574 - Repeating Characters

If you need to fill a cell with a character, either with or without numbers, there are a couple of interesting alternatives. Episode 574 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!

Thursday, August 16, 2007

Episode 573 - Plus or Equals

All Excel formulas start with an equal sign, right? It turns out that Excel will allow you to create your formulas with a plus sign instead. Episode 573 shows off the arrow key method for creating formulas.

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!

Wednesday, August 15, 2007

Episode 572 - 2007 Filters

Excel 2007 adds some amazing new features to the Excel 2003 AutoFilter technology. Learn how you can filter to multiple items, by month or by color. Episode 572 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 workday to learn one of the tips from the book!

Labels: ,

Tuesday, August 14, 2007

Episode 571 - AutoFilter Doesn’t Contain

Joe asks about using custom autofilters with Excel. He can use a wildcard to find all of the cells that contain *abc*, but how about finding cells that do not contain “abc”? Episode 571 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, August 13, 2007

Episode 570 - Random Quiz

Giovanni asks how he can create a random multiple choice question; present a definition and four answers, one of which is right and three are wrong. While this sounds simple, the solution requires a mix of VLOOKUP, RANK, RAND, RANDBETWEEN functions. Episode 570 walks through the solution.

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, August 10, 2007

Episode 569 - Moving Columns III

Derek from the UK checks in with yet another way to sling columns around a spreadsheet. Episode 569 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!

Thursday, August 09, 2007

Episode 568 - Monthly Subtotals

If you have a column of daily dates, how can you subtotal by month? Episode 568 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!

Wednesday, August 08, 2007

Episode 567 - Truncation Justify

Are you a fan of Edit – Fill – Justify? If so, watch out if you try to justify particularly long text – anything over 255 characters in a cell. Excel fails miserably, and you lost part of your text, without any warning from Excel. Episode 567 shows you the details.

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, August 07, 2007

Episode 566 - Text to Columns

Going back to Podcast 453, I talked about taking data from the Mega-Millions website and parsing this data in Excel. Dave wrote in to say that the text to columns process was not working out well. In Episode 566, I show how using Text to Columns sometimes requires a few extra steps.

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, August 06, 2007

Episode 565 - Restoring Scrollbar

Back in Episode 548, I talked about the frustrating size of the scrollbar slider when you accidentally activate a cell that is outside of the normal range. Derek from the UK sends in a great solution in today’s podcast. Episode 565 shows the completely unintuitive way 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!

Friday, August 03, 2007

Episode 564 - Floating Point Errors

Have you ever had an Excel calculation show up with a tiny fraction like .0000000002 at the end of the number? This prevents Excel from seeing if two numbers are equal or not. Episode 564 will show you two methods for dealing with 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, August 02, 2007

Episode 563 - Mapping Data

Turn a list of customer locations into a map right in Excel using Microsoft MapPoint. In Episode 563, I show you how to use MapPoint to render a map in Excel, but then also how to make the map more suitable for viewing.

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, August 01, 2007

Episode 562 - Better Scientific Notation

Ryan from Schaumberg sends in a tip for improving Excel’s presentation of scientific notation. Episode 562 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: , ,