· 

Consolidate Data to Create a PivotTable

There will be occasions when a PivotTable needs to be created, however the data source is scattered in different worksheets and/or workbooks. Excel can consolidate this data first and then summarize into a single PivotTable report; via a feature called PivotTable and PivotChart Wizard.

Go to my Free Resources page to download a tip sheet.

 A video tutorial on this topic is also available on the 'Free Resources' page.

Write a comment

Comments: 0