Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

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

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

How to create a script in Excel for the web At this point, you have a conceptual idea of what Office Scripts and TypeScript are, so let’s move on and create a script in Excel for the Web.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.