Episode 717 - Event Calendar

Matthew from Washington wants to take an event database and create a visual calendar that shows availability.

While this sounds simple, it requires several steps. The end result is fairly cool. Episode 717 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!

Episode 676 - Recording Naming

Paul uses the macro recorder to record the action of naming the current region. The macro recorder never gets this correct. There is a far simpler version of code to create named ranges. Episode 676 will show you how to replace the recorded code.

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 675 - Named Ranges

Today we revisit Episode 672. Rather than using the difficult syntax from that episode, Paul from Darby suggests using a named range. Episode 675 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!

Episode 359 - Circular Data Entry

A great call from Georgia - how to ease the data entry when you need to enter cells in an unusual pattern. Even if your data entry cells are in a circle or other strange path, you can define a named range that will remember the sequence for entering cells. Episode 359 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!