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

Screen-capturing programs such as the Windows Snipping tool are fine for capturing graphics you see on your screen's visible area. However, if you need to print a document with a height that exceeds ...

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

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

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

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