Opening Balance VLOOKUP Excel Tutorial

In today's dueling Excel podcast, how to do a VLOOKUP left. In Episode 1060 Bill and Mike show differing methods, from INDEX and MATCH to LOOKUP. This is the video podcast companion to the book, Learn...

Carrie from yesterday's podcast called in to say that the links are not working. It turns out that Carrie and Mike wanted to copy the cell shading of the linked cell and regular links don't...

Another question from Gopal. New India Pay Commission guidelines suggests that pay should be rounded to increments of 10. If the amount over the last 10 is less than or equal to 0.99, then round...

It is frustrating that commands in Excel 2007 are spread out amongst 7 different ribbon tabs. Episode 930 will show you how to add your favorite commands to the QAT - Quick Access Toolbar so...

Jack from Boston sends in a cool Windows trick to change the color of the selected cells. You would this this would solve the problem in Episode 907, but it doesn't. Still, you can watch...

Yesterday, I talked about Jason's request to format a grouped pivot field in the row area of a pivot table. There is a solution, but it requires a bit of work in the original data...

The one problem with icon sets is that they are always left-justified in the cell. Episode 923 will show you why this is a problem and how to overcome it. This video is the podcast companion...