I recently stumbled upon a very cool feature in Excel that I had to share in a blog post. This feature allows you turn a cell with a country, city, or company name into a lookup field, where you can quickly and easily add other information to your worksheet. To see this in action, keep reading! Read more
Flash Fill is one of those features in Excel that is easy to ignore or turn off, but it actually does have some very valid use cases that could make life easier! Flash Fill can be tremendously helpful when working on repetitive tasks that would be tricky to implement with formulas. Below are a few examples to demonstrate how this feature can be used. It’s pretty smart! If you’re doing any sort of repetitive task in Excel, I recommend giving it a try.