Resources on Data Analysis @ ExcelOptimize.Com
Currently Browsing: Data Analysis
Posted by Andrian in Data Analysis on 01 25th, 2009 | No Comments

Formatting a pivot table

Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data or list of data. All you need to do is click a cell of the pivot table to add the PivotTable Tools contextual tab to the Ribbon and then click its Design tab to display...
Read More
Posted by Andrian in Data Analysis on 01 24th, 2009 | No Comments

Goal Seek

Creating a pivot table has never been as easy as it is in Excel 2007: simply open the worksheet that contains the data list you want summarized by the pivot table, position the cell cursor somewhere in the cells of this list, and then click the PivotTable command button on the Ribbon’s Insert tab or...
Read More