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.

To create an amortization table or loan repayment schedule in Excel, you'll set up a table with the total loan periods in the first column, monthly payments in the second column, monthly principal ...

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Yet, one of the biggest mistakes marketers make is trying to wrangle static data instead of taking advantage of Excel’s table formatting, which basically turns your data range into an ...

Turning the rows of call log data into an Excel table lets you search and sort by any column - a handy feature when you need to look up information quickly.

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.

You can use the RAND () function to establish probability and create a random variable with normal distribution.