Guest Post: How to Create a Dependent Drop-Down List in Excel

Note — this is a guest post from Kasper at Spreadsheeto.  He and his business partner Mikkel are doing some awesome Excel training — check out their site!  I was introduced to their work after Kasper’s Excel.TV appearance. Kasper and Mikkel of Spreadsheeto. We are kindred spirits! Spreadsheeto is also focused on teaching what’s not always evident […]

Setting cells to phone number format in Excel

I don’t know about you, but I’m always impressed when I’m filling out a contact form online, enter in my phone number 5551238776 and see it transformed to (555) 123-8776. It’s not much, but it shows that the form is designed with the user and aesthetics in mind. You can do the same in Excel! […]

Filter on just part of a tab in Excel

Usually when you apply a filter to your Excel workbook it applies to the whole data tab. Sometimes you don’t want this. Here is a great workaround from “Learn Excel 2007 through Excel 2010 From MrExcel: Master Pivot Tables, Subtotals, Charts, VLOOKUP, IF, Data Analysis and Much More – 512 Excel Mysteries Solved” by Bill […]

Anchors Away! A Better VLOOKUP

There is nothing wrong with the average vlookup. But do you really want to be average? The coveted analyst needs exceptional Excel skills. How can we make Vlookup even more accurate and efficient?  Subscribe to the newsletter and get even more VLOOKUP tips with my “Beginner’s Guide to Getting Hired wtih Excel,” yours free for subscribing. […]

#VlookupProblems: Cells Formatted as Text

This is a common problem that interns and coworkers often approach me with. “Can you take a look at my vlookup? I’m doing everything right but getting errors.” The culprit: incorrectly formatted data. The Problem Cells in Excel can be formatted in different ways. (Hint: see how your cells are currently formatted by keying Ctrl […]