Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Whether you work for a small mom-and-pop operation or belong to a giant, multinational firm, spreadsheets are likely to be an invaluable tool for your business. All companies manage various sorts of ...

Q: I have an Excel spreadsheet that I update weekly with our employees’ Actual Sales and Sales Goals. I manually insert a red circle to indicate those who did not reach their sales goal by more than a ...

If you are looking for an easy way to enhance your Excel data analysis and visualizations you might be interested in learning more about the Filter feature available within Microsoft Excel ...

Manually organizing data in Microsoft Excel is a real pain. That's why we don't recommend doing it. One simple task, learning how to alphabetize in Excel, is not necessarily as intuitive as we would ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

Linked cells often make it easier to organize spreadsheet data that's spread among several worksheets. If you keep your raw data and totals in one worksheet, for example, you can transfer the totals ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Spreadsheets are super powerful, but they have limits. This article examines four big challenges of working in spreadsheets, and shows how data science tools such as notebooks can cleverly address ...