Spreadsheets are indispensable tools to us data geeks so I always keep an eye out for new ideas and tips in managing data using spreadsheets. I use many of the features and functions listed in the article and even inspired by a few I never thought of before! In the Related links below the first link is one of the most popular posts on infophile.
Spreadsheets get a raw deal. We are so dependent on tools like Excel and Google Sheets for managing budgets and P&Ls that it’s easy to fall into the trap of seeing spreadsheets only as applications for managing money, or at the very least, for working with numbers.
But the structure and features of spreadsheets make them so useful for a wider range of purposes, from project planning to writing. Breaking information or text into cells helps you break your work into bite-size chunks so you can find different ways of structuring it. The ability to sort and filter cells makes it easy to find, categorize, or reorganize lists or content. And yes, it’s nice to be able to do quick calculations when you are working with numbers. READ MORE: An Ode to the Underappreciated Spreadsheet | HBR