Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques. The article Five ways to take advantage of Excel list features showed five ...

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...

Would you like to make your Excel spreadsheet and data management smoother, more efficient, and less error-prone? Excel tables have transformed data management, offering a wide range of features that ...

Have you ever carefully crafted a formula in Excel, only to watch it unravel into chaos the moment you copy it across columns? It’s a maddening quirk of Excel tables—structured references that seem to ...

How to export a Microsoft Excel table to Microsoft SharePoint for easy collaboration Your email has been sent If you’re the author of Microsoft Excel data that others in your organization need to view ...

In this tutorial, we will explain how to make a Step Chart in Microsoft Excel. Charts are known to many as a graphical representation of data that people can use to explain a point to their audiences.

Many of them are backward- and forward-compatible, but check the system requirements before you download anything. Note that newer isn’t always better: Many of the ...

In Microsoft Excel 2010, you can create large tables in which to store your data and then use it in formulas and store the results in the same table. You can insert and calculate almost anything ...