Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

Step 1: Turn Your Data Into a PivotTable . The first step is to turn your raw Excel data into a PivotTable. To do this, select any cell in your formatted or unformatted table of data, and click ...

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.

Click the Insert tab and choose PivotTable in the Tables group. Excel does a good job of determining your needs, as you can see in Figure C. Take a moment to review the settings and then click Insert.

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

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.