Red Data Labels - 1147 - Learn Excel from MrExcel Podcast

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses this 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!

MrExcel's Learn Excel #1010 - Dueling: Unwind Selection

A dueling podcast: how to unwind a rectangular selection to a single column. Mike & Bill weigh in with differing methods in Episode 1010.

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!

MrExcel's Learn Excel #1007 - Formula Conditional Formatting

William asks how to base his conditional formats on a start date in column A and a duration in column B. This calls for the Formula version of conditional formatting. Episode 1007 shows you how.

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!

MrExcel's Learn Excel #964 - Thu Mar 5, 2009

I bet you thought that I screwed up and put the date of the podcast as the title! But no... that really is the title. Tony asks how to change the long date format to show Thu Mar 5, 2009. Episode 964 shows you how.

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 905 - Shade Half a Cell

Jan asks if it is possible to shade half of a cell. Episode 905 shows one cumbersome way to do it .

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

Episode 545 - Sparse Copy

My favorite trick is to double click the fill handle to copy a formula. But, this requires the column to the left to have no blanks cells. Today, Suzanne from Chicago gives us a great trick of how to overcome a sparse column to the left of the formula. Episode 545 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!

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!

Episode 384 - Formatting Macro

Someone posed this question in a recent Power Excel seminar - he had to format cells with a strange format, and had to do this repeatedly. Learn how to record a simple macro to automate this task. Episode 384 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!

Episode 356 - Customizing Icons

You probably know that you can add new icons to your Excel toolbars, but did you know that those icons can also come from Word or PowerPoint? Episode 356 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!