How to consolidate multiple worksheets into Pivot Table in Excel Hindi By TeachToEach

TeachToEach Presents - In this tutorial, I teach you “How to consolidate multiple worksheets in a single Pivot Table sheet in excel”. Everyday users of excel are not aware about “how to combine or merge data into single pivot table in excel. You can use Excel Consolidate Option to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. You can also use it to quickly summarize data in a single sheet - without sorting the data. Please follow below the steps :- 1) Press CTRL then D then P. A new popup window will be appear 2) Choose “I will create the page fields” and click Next 3) Click in the Range field, highlight your data, click Add, then click Next 4) Decide where you choose to locate the PivotTable. I chose New worksheet 5) This will generate a PivotTable on a new worksheet 6) Your file is consolidate into pivot table, Now you can adjust rows and columns as per you requirement. Aaye jante hai alag alag worksheet ko ek hi pivot table me kaise dikhaye Watch more vidoes : A. How to Lock individual Cell - https://www.youtube.com/watch?v=4I8jGax27og B. Send delay delivery message on outlook Hindi -https://www.youtube.com/watch?v=JnWj48XRBNg C. How to import excel file into google drive - https://www.youtube.com/watch?v=BwACYdOC9hQ D. Mail Merge in Word - https://www.youtube.com/watch?v=1xuTbaHSYRQ E. How to hide a folder - https://www.youtube.com/watch?v=GS5VoeDzyIQ

Видео How to consolidate multiple worksheets into Pivot Table in Excel Hindi By TeachToEach автора Операции с ячейками Excel