I have an excel sheet including sales of each item within a particular period. See the below image.

I want to get the total sales of each item during this period. Can someone tell me a way to do this quickly?

I am very new to Microsoft excel and have a little knowledge.

I have seen some experts are using sort option for their works.

Can somebody explain me how to use the sort option in excel.

Thanks.

I recently started to learn about Microsoft excel. I heard about the many options available in excel. Further I heard using the filter option we can do a lot of work in exile. Can anybody explain me how to use the filter option in excel.

I have a list of members in a sport club and their age category. I just want to count how many members are each category. There are thousands of names in my excel sheet. How can I count these members easily by using an excel function. I have shown some of that member in the below image.

I have a spreadsheet including employee name and their salary details of all employees. I want to have a basic salary of selected employees in another excel sheet. Does anybody know an easy way to get that into the new excel sheet?

I want an excel formula to select players for an event. Please see the image.

In column D under status column I want to have results as selected or not which meet the following criteria.

Age between 20 and 30 together with Weight between 50 and 60 KG                     –   Selected

I have a Microsoft excel sheet including some dates. I just want to separate year, month and day to three separate columns. There are more than 300 days. Can someone tell me an easy way to do this?

I would like to know something about macro in Microsoft excel. I have heard that check boxes can create in excel and assign a macro. Can someone explain me how to insert a check box to assign a macro?

I prepare some reports using both Microsoft word and excel. In a report some pages are in word and some are in excel. My problem is how I can assign page numbers for such a report. As an example if pages 1 and 2 from word, how can I give page number 3 & 4 from excel. Can you help me?

I prepare financial reports from Microsoft excel. There are many headings in those reports. My problem is it is very difficult to place these headings in the center of the page. Can somebody give me a solution for this?