The struggle to manage Bonus Program can consume your time and overwhelm you. But no more - DocHub is here to take the effort out of modifying and completing your documents. You can forget about spending hours adjusting, signing, and organizing paperwork and worrying about data protection. Our platform offers industry-leading data protection procedures, so you don’t have to think twice about trusting us with your sensitive data.
DocHub supports various data file formats and is available across multiple platforms.
[Music] thank you hi welcome you all to my channel the excelism friends in this video Id like to explain you how to split the data into different sheets year wise if you look into this data set having so many columns serial number company location date sales even in the date column it is from 2000 2022 are available now if I want to get 2000 Year all records at one place then I want to keep in in the next sheet 2001 related data then 2002 related data and so on then what I am going to do thats what you can watch in this video [Music] now Ill simply keep one column here called here as you all know here is the function which can give me a year from this serial number serial number is nothing but the date now let me enter copy and paste it now I will set this entire data anyway this is a continuous data without even selecting just go to the insert click pivot table by default it selects the entire data I want to insert a pivot table in the new worksheet just click ok once you keep the