Whether you work with paperwork day-to-day or only from time to time need them, DocHub is here to assist you take full advantage of your document-based tasks. This platform can wipe date in Annual Report Template – Foreign for Profit, facilitate collaboration in teams and create fillable forms and legally-binding eSignatures. And even better, every record is kept safe with the top security standards.
With DocHub, you can access these features from any place and using any platform.
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