Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Learn how to use the Excel PowerPivot functionality for data modeling in data analysis in your spreadsheets. Once mastered this function ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

How to Calculate a Model in Excel. Mathematical models are a way to attempt to predict the probable outcome of a complex situation. From climate, stock market and physics models, you can use ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

Here’s how to monitor your financial accounts from Microsoft's spreadsheet software with the 'Money in Excel' template.