The struggle to manage Sales Report can consume your time and overwhelm you. But no more - DocHub is here to take the hard work out of editing and completing your paperwork. You can forget about spending hours adjusting, signing, and organizing paperwork and stressing about data protection. Our platform offers industry-leading data protection measures, so you don’t need to think twice about trusting us with your sensitive information.
DocHub works with different file formats and is accessible across multiple systems.
hello everybody welcome back to new video tutorial in excel and in todays video we are going to learn how to create a product wise month wise sales report from a daily sales data for example here you can see our daily sales data in the column b the dates are given different dates are given in column c name of the product are given and in the column d the sales quantity is given and if you see this data this data is very big we have 500 rows and based on this uh sales data we need to calculate a product wise month wide sales report in this format here you can see the required format for the report here we need to display the unique products name then here we we have to prepare the report month wise for example if this we have to calculate how many quantity of headphone was sold on january and we have to put the quantity here similarly we have to calculate how many quantity of television was sold on january and we have to put the quantity here similarly we have to make the report for fe