Do you need to determine where you rank in a list? Use the tip in this podcast to rank values in a list. Episode 179 will show you how. This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

How to add numbers to a list so that the numbers will recalculate when you insert or delete new list members in the middle of the list. This podcast actually turns into a cool discussion of using a combination of mixed and relative references in a single count function. It is a technique that comes up once in a while and is very handy to master. Episode 178 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!

Why does Excel say I have two cells when any seven year old can see it is 9 cells? Because the COUNT function doesn't count like you do. Learn why =COUNT() doesn't always work and the obscure function to work around this problem. Episode 177 will show 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!

Yes - you can use the AutoSum icon to find averages, min, max and counts. Episode 176 will show 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!

Why the AutoSum icon doesn't always work. Learn the amazing trick to have AutoSum work all of the time in the 75th installment of the MrExcel podcast. Episode 175 will show 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!

Use the AutoSum button to quickly total columns of numbers. Episode 174 will show 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!

There are THREE popular ways for entering formulas. Like a midway carnival worker, MrExcel can predict your age based on which method you use most frequently. Watch Episode 173 to learn all three methods for entering formulas. (Plus - I bet that after you see which way MrExcel recommends, you too can guess his age!!!) 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!

Confused when your manager asks you to do some strange calculation in Excel? Use the fx button to easily discover new functions from amongst Excel's 455 built-in functions. Episode 172 will show you how. This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

Instant help with function arguments: Do you remember the function name but not the order of the arguments?

Want to see calculations of a loan payment if different interest rates, number of months or loan amount changes? Copy formula to several cells to create "what if" scenarios. Episode 170 will show you how. This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

Buying a cool new car or a house? Use Excel to calculate the loan payment.

Are your numeric entries sorting in the wrong place? Maybe you have a mix of text and numbers.

Not only does the Rand Function create/sort random numbers, but it also creates random letters. Episode 167 will show you how. This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

Use the random number generator to create dice in Excel. Episode 166 will show you how. This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!

Another great feature of the Rand Function is sorting a list into a random sequence.