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

Thursday, July 23, 2009

Custom Zones - 1064 - Learn Excel from MrExcel Podcast

In yesterday's netcast, I talked about using four zones in custom number formats for positive, negative, zero, and text. In Episode 1064, you will learn how to create your own zones for formatting.

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

Wednesday, July 22, 2009

Formatting Zones - 1063 - Learn Excel from MrExcel Podcast

LearnAccessByCrystal at YouTube asked for a podcast with information about the zones in a custom number format. In Episode 1063, an explanation of the four zones in a custom number format.

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

Monday, March 24, 2008

Episode 721 - Leading Zeroes

Many people were missing from the map on last Monday's podcast. Did I miss their entries? No! I use a common Excel trick to keep leading zeroes, but this confused MapPoint. In today's podcast, we take a look at other ways to keep leading zeroes in Excel. Episode 721 shows you how.

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

Monday, July 23, 2007

Episode 555 - Thousands Display

Need to convert a report or a chart to display in thousands or millions? Episode 555 shows two different methods to achieve this result.

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, July 20, 2007

Episode 554 - Formatting Zones

Building on yesterday’s podcast, Episode 554 shows how to make full use of the custom number formatting zones to add specific words to a balance due 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: ,