I am working with pivot table and facing some problems. The pivot tables in which I want to avoid the row selection permanently to a set of specific items, for example excluding any new fields when refreshing the pivot table. Is this possible in a pivot table?

I am looking for a kind help.

Thanks.

I did a fixed asset verification and details are in an excel sheet including the following details.

Department, Category & item.

Eg.          Department       Category              Item                      Number

I have seen some word sheet has been split (two columns). I would like to know how we can split to two columns in such a way.

I have a table in Microsoft excel including the student's name and their marks for the subjects mathematics, English and Accounts. I want a formula in a front column which meets the following criteria.

If marks of each subject are more than 50, column should be displayed as “passed” if not “failed”.

And in another place I want the number of passed and failed student separately.

Can someone tell me a formula?

I have an excel sheet including thousands of codes. Please see the image below.

I want to make a new code using this code. The new code should include the first 5 characters, a dash (-) and the last five characters of the current code.

Eg:25500-25789

Can someone tell me an easy way to do this instead copy paste and edit?

I want to know something regarding Microsoft word. I know how to enter the table to word sheet. However I want to have few sub headings under a main heading in a table. Can someone help me?

I have an excel sheet including sales of each item in each day. Please see the image below.

This is for an example. There are about 100 items.

I want to extract sales of selected items in a particular date. Is there any easy way?

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.

The Gaddafi Stadium in Lahore is one of the iconic stadiums in Pakistan. Having a seating capacity of 27000, it is the first stadium in Pakistan in which modern floodlights and backup power generators were installed. Apart from regular matches, it also hosted the final of the 1996 Cricket World Cup between Sri Lanka and Australia. In this article, we will have a look at the top 10 highest scores scored by batters at this stadium. 1. Shoaib Mohammad (203*) Shoaib Mohammad played as an opening batsman for Pakistan. He represented his country in 45 test matches and 63 ODIs, in which he scored 7 test centuries and 1 ODI century. Out of his 7 test centuries, his best score of 203 not out came against arch-rivals India at the Gaddafi Stadium. He played 338 balls to achieve this feat. This score is the 10th-highest score at this stadium by any batsman. 2. Hanif Mohammad (203*) Hanif Mohammad was a wicket-keeper batsman of Pakistan and also the father of Shoaib Mohammad. Like his son, he was also an opening batsman who represented his nation in 55 test matches and has 12 centuries to his name. His score of 203 not […]