Today’s topic may seem like an unnecessarily basic one, but I can tell you that nine out 10 shared spreadsheets I receive from team members are unusable for analysis because they can’t be sorted. I’m ...

Spreadsheets are a nerd’s data-driven dream. For most regular people, though, they’re a complicated mess. Fortunately, they don’t need to be. Here’s how to bend data to your will with Microsoft Excel ...

One option for sharing reports with your team is to simply rattle off numbers. Think something like this: "We allocated 10% of operating budget to maintenance, 15% to hardware upgrades, 18% to ...

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 ...

If you use Microsoft Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher ...

These four overlooked Excel features completely changed how I design spreadsheets.

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...