MrExcel Excel Videos

A question from my Minneapolis seminar: How can you do a VLOOKUP for Apple when then matching text has characters both before and after Apple? It turns out that VLOOKUP can accept a wildcard or a pair of wild cards and this is easier than you would think. The same concept can be used with SUMIFS to find the total of all records that contain Apple anywhere in the text.

Improvements have been made to the Geography data types in Excel. This video shows how Excel will detect if you are entering geography and encourage you to try out the geography data types. Improvements to the data card allow you to add new columns directly from the card. Also - an explanation of how other cells in the column will help Excel to determine which city you mean.

I've been doing it wrong! If you want to report a bug to Microsoft in order to improve Excel, there are four easy steps to elevating your "Send a Frown" to Microsoft. Follow these steps to ensure they reach a real human who can fix the bug. Leave a comment below before March 31 to have a chance to win an Office Insider vintage distressed ball cap.

Just four months ago, the views of my podcast asked if Microsoft could add exchange rates in addition to the stock data type. Breaking news: Excel will now provide exchange rates for currency pairs. Type in USDEUR and get the currency conversion from US Dollars to Euro. This is an awesome improvement from the Data Type team in Redmond. Title card photo credit: Christine Roy on Unsplash

An easy way to add a tooltip to cells in Excel. This is useful if you are using Excel to create a form for people to fill out.

Troubleshooting Excel VLOOKUP. You enter a VLOOKUP but all of the numbers are returning the #N/A error. You can see the 4399 in the lookup table, but here is the difference. The number in A2 is a text 4399 and the number in the lookup table is a number. Today, a new way to solve this with just two extra characters.

Download the tool from here: Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center Today, a look at the Fuzzy Lookup tool released by Microsoft Labs for Excel back in 2013/2014 time frame. The tool is fairly cool for matching imperfect data. This episode shows you the portfolio example that ships with the add-in.

A fast way to close all workbooks in Excel

A Power Excel audience member in Omaha asked about the difference between 9 and 109 in the Excel SUBTOTAL function.