You worked hard to put that Excel sheet together, now protect it from unintended damage. Formulas are one of the most important components of an Excel sheet and as such, deserve–warrant–protection.

With the FILTER function, adding or changing criteria instantly updates my results, while the original data stays intact.

As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ever imagined. These are the tips and tricks you need to know.