SPLIT DATA INTO MULTIPLE SHEETS IN EXCEL | PIVOT TABLES | DATA SETS

In this video, you will learn how to split data into multiple sheets using specific data sets. These data sets could either be regions, segments, divisions, customer names, sales person etc. depending on what you want. In the example used in this video, our data was splitted using regions as the filter. Here, the master data was duplicated into different sheets for specific regions. To achieve this result we used Excels Pivot Tables. With the pivot table if a new data is introduced in the source data, it will be updated automatically across all sheets. Watch this video to the end to see how it was done. Click to watch related and other educative videos https://youtu.be/w9MnSD4VEu0 https://youtu.be/JM4I1dXipnM https://youtube.com/shorts/26RD264rIVE?si=GAdBwg8kdsNpsWfs Click to download the practise file https://1drv.ms/x/s!AoCXdmMFWjS3bLOUjCgS-1peZL4 The below timestamps will help you locate any specific area you are interested in. 0:00 - Intro 1:09 - Data sets 1:43 - Insert Table 2:00 - Insert Pivot Tables 2:24 - Build reports 4:40 - Split data 5:37 - New data 5:43 - Wrap up