Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

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.

Click a cell in the date column of the pivot table that Excel created in the spreadsheet. Right-click and select "Group," then "Days." Enter "7" in the "Number of days" box to group by week.

You have a table on paper but need the data listed in Excel? There's a simple trick for importing.

How to Convert Access Reports to Excel Tables. One of the prime attractions of Microsoft Office Suite is the ability to transfer and convert data for use in each of the different programs that ...