Having full control over your documents at any time is crucial to alleviate your day-to-day tasks and enhance your productivity. Achieve any objective with DocHub features for papers management and practical PDF editing. Gain access, modify and save and integrate your workflows along with other secure cloud storage.
DocHub gives you lossless editing, the opportunity to use any formatting, and securely eSign papers without having searching for a third-party eSignature option. Maximum benefit of your document management solutions in one place. Try out all DocHub features right now with your free account.
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 f