MrExcel Excel Videos

To buy or try WBMerge: https://mrx.cl/2HVj0wU Save 20% on WBMerge through June 30 2019 using discount code MREXCEL In this video, I try the WBMerge utility on a collection of Excel workbooks that might be problematic in Power Query. WBMerge is a $39 utility from Workbook Tools. The utility can merge data from multiple Excel workbook or multiple Google Sheets files.

I have two great things to report about Excel. First, the old Tool Tabs in the Ribbon have become smaller. I love the new style and it makes perfect sense. Second, I have a bit of a rant about the questionable Microsoft Search box that is now dominating the Title Bar in Excel. Who is using this? Why are they making it so large? Great news part 2: If you plan to never use the Search box, minimize it to a tiny icon.

I can't solve today's question using the regular Filter. I am sure someone has a better way. A person in my Milwaukee seminar wants to filter text account numbers to everything between 6 & 9. Do you have a solution?

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.