Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical ...

I still remember the first day I figured out how to run a vlookup command in Excel; I was sitting at my coffee table wondering what the point of this silly little command was. Once I realized its ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...