

Category Archives for "Formula Hacks"

4 Separate First and Last Name in Excel (Split Names Using Formulas)

Resulting Data where names have been separated

Watch Video – Split Names in Excel (into First, Middle, and Last name) Excel is an amazing tool when it comes to slicing and dicing text data. There are so many useful formulas as well as functionalities you can use to work with text data in Excel. One of the very common questions I get […]

6 INDEX & MATCH Functions Combo in Excel (10 Easy Examples)

Three Way Lookup - Result using INDEX MATCH

Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I […]

19 Find the Last Occurrence of a Lookup Value a List in Excel

In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. […]

14 Excel Holiday Calendar Template (FREE Download)

Excel Holiday Calendar List Template - Demo

Last few weeks have been really hectic for me at work. Weekdays are crazy and the weekends are never enough. Early this week, I was going through our annual holiday calendar to check for the next holiday, and plan a vacation if possible. And that gave me the idea for this Excel holiday calendar template. In […]

1 How to Round to the Nearest Integer or Multiple of 0.5 / 5 / 10 in Excel

Watch Video – Round to the Nearest Integer or the Multiple of 0.5 / 5 / 10 in Excel Rounding a number to the nearest integer or the nearest 0.5 or 5 or 10 multiple is a common task for many people. For example, if you’re a project manager involved in effort estimate, you can’t […]

113 Get the List of File Names from a Folder in Excel (with and without VBA)

On my first day in my job in a small consulting firm, I was staffed on a short project for three days. The work was simple. There were many folders on the network drive and each folder had hundreds of files in it. I had to follow these three steps: Select the file and copy its […]

0 Test Multiple Conditions Using Excel IFS Function

Excel 2016 came with a new function – the IFS function. You can use this function to test multiple conditions at once and then return the result based on it. This is helpful as you don’t have to create those long nested IF formulas that used to get confusing. Note that the IFS function is […]

1 2 3 … 7 Next »