News

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.
Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.
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. Clicking the "Insert Worksheet" button ...
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.
And when you already have a column or row of an Excel spreadsheet loaded with the data in question, you can make a pie chart in about five seconds. Here's how. Check out the products mentioned in ...
Particularly in a healthcare setting, where protecting patient data can be a life or death issue, spreadsheet locking and encryption features give researchers a false sense of security. Another issue ...