Have you ever wanted to use tags in Excel? Maybe you want to assign tags in Excel for your business contacts, friends, or favorite recipes. You may have many different tags, frequently create new ones, and an arbitrary amount of tags assigned to each individual. It’s extremely easy to do this using filters and Excel’s […]
Tags in Excel: How to Implement Them in Seconds Read More »
You may want to standardize names in Excel if you’re combining multiple sources where the names come in different formats. Sometimes the first and last name are in different columns. Sometimes you have the full name – or the first and last name separated by a space. And sometimes you have the last name, comma,
How to Standardize Names in Excel Read More »
Have you ever wanted to remove duplicates from a list in Excel? It’s a common issue. You have a long list of names or other values where some of them are repeats, and you need a list where each value appears only once. There are two quick and easy ways to do this. Method 1:
2 Easy Ways to Remove Duplicates From a List in Seconds Read More »
Sometimes you need to compare large data sets. You may have two workbooks with thousands of rows, and want to know what’s changed between them. There are a lot of ways to do this in Excel, but some are harder and more time-consuming than others. I received a question about the best/fastest way to do
Three quick ways to compare data sets in Excel Read More »
There are sometimes leading zeros in zip codes in the United States. Meaning that a 5-digit US zip code could be something like 03842. But Excel assumes numbers shouldn’t start with zeros, and removes them. There’s an easy way to fix leading zeros in zip codes that takes literally 10 seconds – no matter how
Fix leading zeros in zip codes in Excel in 10 seconds Read More »
SUMIFS is one of the most powerful tools in Excel. In this video, I show how you can easily use SUMIFS to rapidly create a fully functional, well-polished tool to track and categorize your expenses, in under 15 minutes. To learn more about creating tools like this, using Excel to get more done in less
Using SUMIFS to Build an Expense Tracker in 14 Minutes Read More »
Extra rows in your ranges are important to prevent extra work and bad calculations. When you insert rows to a spreadsheet, Excel can sometimes behave in an unexpected way. To make things worse, Excel doesn’t make it obvious that it’s doing something weird. If you aren’t paying close attention, you could easily end up with
Always Include Extra Rows in Ranges Read More »
Reader SV wrote in to ask: “How to I transpose a table, like copying and pasting a vertical column of cells to a horizontal row of cells?” Great question! Let’s say you have data that looks like this: Then you decide that you’d rather have the dates running across the top, with each individual and
How to Transpose Information in Excel Read More »
