It’s probably not a secret anymore that I love Microsoft Excel for data crunching. Nothing makes me happier than getting a whole mess of data and making sense of it. While I’m definitely not an Excel ninja on the level of Mike Pantoliano, I’ve learned a number of tricks in the past couple of years to help out a lot with my work. Whether it’s keyword research, building a sitemap, or cleaning up URLs and finding duplicates in rows, here are eight of my favorite Excel functions that make my life easier every day.

For all of these, the data is in cell A1, unless otherwise noted.

Stick these in your list of functions!