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

Friday, May 23, 2008

Episode 765 - Insert Shortcuts

You might already know these, but I recently was shown a few cool shortcuts for inserting rows, columns, or cells. Episode 765 will show 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, February 18, 2008

Episode 696 - Alt Shortcuts

Jim from California suggests that I take a look at the new Excel 2007 Alt shortcut keys. They are pretty cool, with one minor drawback. Episode 696 takes a look.

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 12, 2008

Episode 692 - Ditto

If you need to copy the *exact* formula from the cell above, there is an amazing shortcut key that will copy this formula down one row. I mean...the exact formula...not a formula with different references, but the exact formula. Episode 692 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:

Thursday, February 07, 2008

Episode 689 - Hiding in 2007

Justin asks how to hide columns in Excel 2007. Finding the command on the 2007 ribbon is a little tough, but Episode 689 shows a way to invoke any Excel 2003 command in Excel 2007.

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