Learn how to perform regression analysis of your data in Microsoft Excel, a statistical process that helps you understand the relationship ...

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code.

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

If you have simple tasks that you need to perform in Excel often, you can actually “teach” Excel to do them for you by recording a macro.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

This article will teach you how to use the MATCH formula in Excel to find data entries that are partially linked to one another. How to perform a partial cell match on Excel? The below example shows ...