Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

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.

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.

How to make a conditional running total in Excel At this point, you’ve not really gained much; the PivotTable isn’t really any better than the Table and its simple expressions.

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

In addition to data organization, basic spreadsheet layouts, and performing calculations, Microsoft Excel can serve as a robust tool for making engaging, interactive dashboards. After all, static ...