Microsoft Excel is arguably the greatest spreadsheet application from Redmond, and there’s a good reason so many number crunchers use it for all of their number crunching needs. While using Microsoft ...

I traded the static results of Flash Fill for dynamic formulas that update automatically.

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...

I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner in ...

In 7 useful Excel formulas and functions for PPC, I shared tips to quickly identify high-impact PPC optimizations that will move the needle for your brand or client. I am a firm believer in an ...