Learn Excel 2010 – “VLOOKUP Into A Range of Zipcodes”: Podcast #1676

Find the Zip Code [Postal Code] That Fits!

Learn Excel from MrExcel – “Floating Box Visible While Scrolling”: Podcast #1660

A little VBA in a Module and Ta-Dah – Floating Message!!

Learn Excel from MrExcel – “Convert Various Currencies”: Podcast #1659

Using a VLOOKUP to provide Currency Conversions

Learn Excel from MrExcel – “Why is Excel AutoFilling my Formulas!?”: Podcast #1658

Good Data + Good Formula = Wrong Values… What Happened??

“Don’t Fear The Spreadheet” – VLOOKUP: Podcast #1646

What is the Big Deal about VLOOKUP? What is it?

“Don’t Fear The Spreadsheet” – Favorite Excel Functions: Podcast #1645

What Excel Functions pay off in a hurry? These, for starters…

“Don’t Fear The Spreadsheet” – Read Only and More: Podcast #1605

‘Mark as Final’ still allows changes!? That’s not Protection! Now What?

‘Don’t Fear The Spreadsheet’ – Every Way To Copy a Formula Down: Podcast #1604

How difficult is it to copy a Formula Down a Column? Not very – check this out!

“Don’t Fear The Spreadsheet” – Hide or Unhide Columns: Podcast #1603

I Have Data That I Want Hidden – How Do I Do That?

“Don’t Fear The Spreadsheet” – Selecting -Or Not Selecting- Hyperlinks in Excel: Podcast #1601

Hyperlinks + Excel = Frustration…but not anymore!