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.

Excel Tables offer a range of features for working with list-style data.

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

Excel used to clean and process data; Stata for analysis. 2012: Aishwarya Subbaraman, Extraction Politics: An Economic Analysis of Rare Earth Elements (zip file with Excel workbooks and paper) Excel ...

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.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

If, on the other hand, you need a table of multiple transactions or currencies for multiple countries, you can use Excel to accomplish this task with the Excel Add-In called EUROTOOL.XLAM.