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

## Friday, December 29, 2006

### Episode 412 - Joining Text

How to join text from two columns using the concatenation character. Episode 412 shows you how to do concatenation, plus how to convert upper case to proper case on the fly.

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, December 28, 2006

### Episode 411 - Expanding FormulaBar

Do you notice that in Excel 97-2003, if you have a really long formula in row 1, when you select a cell, the formula bar obscures the value in the cell? This is now fixed in Excel 2007. Episode 411 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:

## Wednesday, December 27, 2006

### Episode 410 - Absolute References

Sometimes, you want to enter a formula where one reference doesn't change when you copy the formula down. Episode 410 will show you the shortcut for creating absolute references.

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, December 22, 2006

### Episode 409 - Function Wizard

Learn how to use a simple English-language query in order to discover new functions. Episode 409 will show you how to find a function to calculate a monthly car payment. You can also use the Goal Seek function to immediately back into an answer.

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, December 21, 2006

### Episode 408 - 2 Column TextBox

How to use Excel as a word processor. This episode again covers the Edit - Fill - Justify command, but also shows off the cool ability to create a two column text box in Excel 2007. Episode 408 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: , ,

## Wednesday, December 20, 2006

### Episode 407 - Logo Shapes

Use the freeform tool to make a 3-D version of your company logo. Episode 407 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, December 19, 2006

### Episode 406 - Color Sort

New in Excel 2007 - you can sort by cell color! Today's episode takes a look at the new Sort dialog in Excel 2007. You can sort by more than three levels, and also choose to sort by font color, cell color, or icon. Episode 406 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, December 18, 2006

### Episode 405 - Morphing AutoShapes

Although Excel offers 100+ built-in AutoShapes, you can use the various handles on the shape itself, or the tools on the drawing toolbar to morph those shapes into thousands of different shapes. Episode 405 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, December 15, 2006

### Episode 404 - AutoShape Defaults

Have you ever needed to create many similar autoshapes? You can set the default color, line style, etc and then use an autoshape mode to crank out numerous autoshapes. Episode 404 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, December 14, 2006

### Episode 403 - 2007 Formats

Actually - there are three different file formats in Excel 2007. Episode 403 describes the differences and shows you how you can use a zip utility to take a look inside the new file format.

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:

## Wednesday, December 13, 2006

### Episode 402 - Find #####

When a number is too large to fit in the width of a column, Excel will display pound signs. Episode 402 shows a unique way to select all of the cells that are currently displaying as pound signs. This trick would seem to be useful for quickly formatting all of the cells that match some certain condition.

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, December 12, 2006

### Episode 401 - Big Grid

Excel 2007 sports a massive grid. Take a tour of cell XFD1084576 to get a sense of just how big the new grid really is. Also: how to unlock the extra rows when you open your legacy workbooks in Excel. Episode 401 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, December 11, 2006

### Episode 400 - OffSheet Precedents

It is a real pain to try to trace precedents that are on other worksheets or in other workbooks. Episode 400 shows some formula auditing tricks, including a trick to see all of the precedents on other worksheets. This is our 300th episode!

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, December 08, 2006

### Episode 399 - Workday Calculations

There are a couple of obscure functions in the analysis toolpak that will allow you to calculate how many workdays have elapsed. Enter a hire date and today's date, and you can calculate the number of workdays. This function even allows for you to enter a range of company holidays which are factored into the calculation. Episode 399 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, December 07, 2006

### Episode 398 - QAT Taming

The only toolbar that is easy to customize in Excel 2007 is the QAT or Quick Access Toolbar. Episode 398 shows you how to customize the QAT with your favorite icons.

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: , ,

## Wednesday, December 06, 2006

### Episode 397 - Leading Zeroes

A much better way of showing leading zeroes. After episode 392, several listeners called in with a better better way to show leading zeroes for any number of characters. Episode 397 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, December 05, 2006

### Episode 396 - Data Visualization

A look at Excel 2007 data bars and color scale features. These new features allow you to quickly see the largest/smallest values in a sea of numbers. Episode 396 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, December 04, 2006

### Episode 395 - Parsing Text

In today's episode a caller asks how to split names that are in one cell into first name in column A and last name in column B. Episode 395 shows how to do this trick, but then the annoying gotcha that will happen for the rest of the day.

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, December 01, 2006

### Episode 394 - Copy Values

Today's tip comes from Dave in Columbus, Indiana. Dave was at my Power Excel seminar last week and passed along a better way to invoke the Paste Special Values command. In the process of showing Dave's trick, I also talk about joining text using the concatenation operator, changing text from upper case to proper case, copying a formula by double-clicking the fill handle, using Ctrl+z to undo. Episode 394 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!