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

Friday, July 10, 2009

Dueling: Paper/Sticker - 1055 - Learn Excel Podcast

Faizee from Youtube posts a question about looking for certain words in a cell in order to create a category. While this sounds simple, Bill and Mike manage to come up with a number of possible formulae in Episode 1055!

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!

Labels: , , , ,

Tuesday, February 24, 2009

MrExcel's Learn Excel #957 - 954 Redux

Episode 954 brought an avalanche of mail on three fronts. (1) SendKeys is really cool, how do you do Alt instead of Ctrl? (2) Why the macro when you could select Entire Workbook in the dialog? (3) Application.Dialogs would have worked, the dialog is misnamed. Episode 957 discusses all of these tips.

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!

Labels: , , ,

Tuesday, June 05, 2007

Episode 522 - Finding Numerics

The Find command seems to work perfectly with text, but always has problems with finding numeric values. It is possible to find numbers with the Find command in Excel, but you have to know some fairly arcane steps. Episode 522 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, May 29, 2007

Episode 517 - Conditional Find

Rod calls in a question today; how to use conditional formatting to highlight all the track athletes from a particular school. This requires the conditional format to look for the school name within a cell. This is very easy in Excel 2007 but very difficult in Excel 2003. Episode 517 discusses the functions required to make it work.

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

Labels: , ,

Wednesday, April 04, 2007

Episode 479 - Parsing Irregular Text

Jason sends in our question today. He has a single column of cells that contain 5 bits of information in each cell. There aren’t any good delimiters and the fields are not fixed width. To extract the necessary information from the cell, Episode 479 shows how to combine MID, FIND, and FIND to locate the important data.

This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy.

Labels: ,

Wednesday, January 04, 2006

Episode 160 - Get characters after the Dash

Yesterday's podcast showed how to use LEFT and FIND to get all of the characters before a dash. What if you need all of the characters after the Dash? There are a couple of options. The first option discussed in the episode is to combined MID, FIND, and LEN to get the characters. Alternatively, you can use TRIM and leave off the LEN function. Or, in Excel 2003, just leave off the LEN function. Episode 160 will show you how.

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

Labels: , , , ,

Tuesday, January 03, 2006

Episode 159 - Get characters up to the Dash

Episode 159 - Get characters up to the Dash
The Left, Mid, Right functions are great, but what if you need to grab a variable number of characters from the left portion of the cell? For example, you need all of the characters up until the first dash? In this case, you will have to use =FIND() to find the position number of the dash. This episode also demonstrates a cool trick for combining functions. When you need to create a complex formula, you might build one part of the formula in one column and the rest of the formula in a second column. This episode shows a unique trick for copying the function from the first column and pasting it into the formula bar of the second function. Episode 159 shows you how.

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

Labels: , , , ,