Episode 705 - Pivoting Time Columns

It is difficult to create a pivot table when you have a time component stretching across the columns in your data set. In today's episode, an amazing trick in Excel 2007 to change four quarterly columns into four rows. Episode 705 will show the multiple consolidation ranges trick.

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 704 - Deleting Blank Rows

In today's podcast, a simple process to delete the blank rows by sorting the data first. Episode 704 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 703 - Filling Outline Blanks

Continuing the process started in podcast 702, I will take a look at how to fill in all the blanks in the "outline view" of Column B. Episode 703 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!

Episode 702 - 2-Field Column

In today's podcast, we start with a data set where column A contains both Region and Model information. In Episode 702, I'll use formulas to split that data into two columns.

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 701 - VBA Userforms

Back in Episode 695, I used the InputBox function in VBA to ask for a couple of answers. In today's podcast, I will show you how to convert that macro to use a custom user form in Excel. Episode 701 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 700 - Mapping Data

Take your Excel data and plot it on a map using Microsoft MapPoint. Watch Episode 700 to learn how you can win a copy of MapPoint.

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 699 - 2007 Pivot Interface

Microsoft changed the pivot table interface in Excel 2007. While the new interface is much better, in this lesson, we will take a look at how to bring back the old interface. Episode 699 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 698 - Column Widths

Say that you need to copy column widths from one range to another range. The Paste Special dialog now offers the opportunity to paste column widths from one range to another range. Episode 698 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!

Episode 697 - VLOOKUP or INDEX?

Mel sends in today's question. She prefers VLOOKUP, but her husband prefers INDEX and MATCH instead of VLOOKUP. In Episode 697, we'll take a look at when to switch from VLOOKUP to INDEX and MATCH.

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

Episode 695 - Scale Selection

In today's podcast, a five line macro that will allow you to scale a selected range. This macro was inspired by engineers in one of my recent VBA seminars. They had been using a similar tool for years and we were surprised it was a five line macro to replicate the tool. Episode 695 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 694 - Double Greenbar

As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 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 693 - Easy Greenbar

Excel 2007 offers easy greenbar formatting using the table functionality. While the table functionality offers amazing tools that we'll discuss on another day, today's Episode 693 looks at the few clicks necessary to format a range with alternating row 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!

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!

Episode 691 - Intersection Operator

When specifying function arguments, if you put a space between two ranges, the space operates as an intersection operator. Episode 691 ponders what uses our viewers might have for this operator.

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 690 - Page Setup

Can you specify rows to repeat at the bottom? Can you specify columns to repeat at the right? Can you have a dynamic page number in the "rows to repeat at top" area? If you are asking these questions, I think you need to investigate the Page Setup Header/Footer tab. It will solve most of these questions. Episode 690 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 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!

Episode 688 - Month End

Calculate the last day of this month, using a new trick sent in by Bob. Episode 688 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 687 - VBA in 2007

Microsoft hides some of the VBA controls in Excel 2007. Episode 687 will show you how to access the Developer tab in the Excel 2007 ribbon.

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 686 - Preventing Spills

Ari sends in a better solution to podcast 677. If you want to prevent text from long cells spilling over to adjacent blank cells, the technique shown in Episode 686 works like a charm. This method might even clean up spills faster than Bounty...

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 685 - Tracking Runners

Marshall from Pennsylvania watched Episode 680 from last Friday and came back with a cool use for the same technology: scoring runners in a 5K or 10K race. In Episode 685, we take a look at a simple system in Excel to track the finishing times as you type in bib numbers.

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!