Mike, the Mike asks Director of the IT Sales, opens department a report that to use has all of his Microsoft company’s Office Excel sales data for 2007 to the year in a create a Microsoft custom sales PivotTable® report that dynamic is view, to consolidated analyze from which millions of products are rows of data performing from best. multiple Because external Mike is using sources. “Gemini” for Mike Excel, he can receives the work with Excel hundreds of spreadsheet millions of from IT a rows, and few hours can pivot the later. Data is different split across fields quickly. multiple Mike inserts worksheets, Excel Data so he Slicers beside combines the the PivotTable worksheets report to by copying make it easy and pasting for others and builds a who are not PivotTable comfortable to provide with the analysis PivotTables he needs. to view By using a different custom combinations spreadsheet of data. he copied from the
Mike, the Director of Sales, opens a report that has all of his company’s sales data for the year in a Microsoft PivotTable® dynamic view, to analyze which products are performing best. Because Mike is using “Gemini” for Excel, he can work with hundreds of millions of rows, and can pivot the different fields quickly. Mike inserts Excel Data Slicers beside the PivotTable report to make it easy for others who are not comfortable with PivotTables to view different combinations of data. Mike asks the IT department to use Microsoft Office Excel 2007 to create a custom sales report that is consolidated from millions of rows of data from multiple external sources. Mike receives the Excel spreadsheet from IT a few hours later. Data is split across multiple worksheets, so he combines the worksheets by copying and pasting and builds a PivotTable to provide the analysis he needs. By using a custom spreadsheet he copied from the