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 Perform Multiple Queries on an Excel Spreadsheet. Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server.

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.

Appending records from different data sets into a single list or data range can be tedious if you’re doing it manually. Instead, use Microsoft Excel’s VSTACK() function.

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.

Clinical researchers increasingly understand that electronic data capture (EDC) solutions, such as Elsevier’s Veridata platform, can be more beneficial to their projects than manual spreadsheets.