Tutorials

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?

Learn Excel from MrExcel