in

Check How‌ ‌to‌ ‌use‌ ‌PivotTable‌ ‌in‌ ‌Microsoft‌ ‌Excel‌ ‌

How‌ ‌to‌ ‌use‌ ‌PivotTable‌ ‌in‌ ‌Microsoft‌ ‌Excel‌ ‌

Microsoft‌ ‌Excel‌ ‌comes‌ ‌with‌ ‌wide-range‌ ‌of‌ ‌options‌ ‌from‌ ‌‌formulation‌formulation‌,‌ ‌spreadsheets,‌ ‌calculations,‌ ‌‌v‌v‌lookup‌ ‌and‌ ‌extra.‌ ‌PivotTable‌ ‌is‌ ‌one other‌ ‌necessary‌ ‌and‌ ‌highly effective‌ ‌software‌ ‌that‌ ‌Excel‌ ‌gives.‌ ‌It‌ ‌is‌ ‌additionally‌ ‌amongst‌ ‌the‌ ‌most‌-‌‌ ‌‌used‌ ‌options.‌ ‌It‌ ‌lets‌ ‌customers‌ ‌analyse,‌ ‌calculate‌ ‌and‌ ‌summarize‌ ‌information‌ ‌from‌ ‌a‌ ‌worksheet.‌ ‌Let’s‌ ‌see‌ ‌how‌ ‌to‌ ‌use‌ ‌the‌ ‌characteristic.‌ ‌ ‌

Necessities‌ ‌

  • An‌ ‌Excel‌ ‌spreadsheet‌ ‌with‌ ‌a number of‌ ‌rows‌ ‌and‌ ‌columns‌ ‌and‌ ‌information‌ ‌to‌ ‌analyse‌ ‌
  • Microsoft‌ ‌Excel‌ ‌should‌ ‌be‌ ‌put in‌ ‌on‌ ‌your‌ ‌laptop‌ ‌


Steps‌ ‌to‌ ‌create‌ ‌PivotTable‌ ‌ ‌

1.

Open‌ ‌any‌ ‌spreadsheet‌ ‌in‌ ‌Microsoft‌ ‌Excel‌ ‌on‌ ‌your‌ ‌laptop‌ ‌

2.

Now,‌ ‌choose‌ ‌the‌ ‌cells‌ ‌for‌ ‌which‌ ‌you‌ ‌need‌ ‌to‌ ‌create‌ ‌PivotTable‌ ‌

Make‌ ‌certain‌ ‌that‌ ‌chosen‌ ‌cells‌ ‌do‌ ‌not‌ ‌have‌ ‌any‌ ‌empty‌ ‌row‌ ‌or‌ ‌column‌ ‌and‌ ‌additionally‌ ‌have‌ ‌solely‌ ‌single-row‌ ‌heading‌ ‌

3.

Head‌ ‌to‌ ‌Insert‌ ‌and‌ ‌click on‌ ‌on‌ ‌PivotTable‌ ‌choice‌ ‌

4.

In‌ ‌the‌ ‌‌subsequent‌ ‌‌dialog‌ ‌field,‌ ‌select‌ ‌the‌ ‌information‌ ‌you‌ ‌need‌ ‌to‌ ‌analyse‌ ‌by‌ ‌choosing‌ ‌desk‌ ‌or‌ ‌vary‌ ‌from‌ ‌the‌ ‌present‌ ‌worksheet‌ ‌and‌ ‌click on‌ ‌Okay‌ ‌to‌ ‌create‌ ‌PivotTable‌ ‌

Do‌ ‌observe‌ ‌that‌ ‌Excel‌ ‌robotically‌ ‌creates‌ ‌a‌ ‌new‌ ‌worksheet‌ ‌for‌ ‌PivotTable.‌ ‌You‌ ‌can‌ ‌additionally‌ ‌choose‌ ‌Current‌ ‌worksheet‌ ‌choice‌ ‌from‌ ‌the‌ ‌identical‌ ‌dialog‌ ‌field‌ ‌in‌ ‌case‌ ‌you‌ ‌need‌ ‌to‌ ‌show‌ ‌the‌ ‌PivotTable‌ ‌in‌ ‌the‌ ‌identical‌ ‌worksheet.‌ ‌However,‌ ‌we‌ ‌would‌ ‌not‌ ‌advocate‌ ‌doing‌ ‌‌it‌ ‌‌this‌ ‌‌in‌ ‌case‌ ‌you‌ ‌‌have a big‌‌ ‌quantity‌ ‌of‌ ‌information‌‌ ‌to‌ ‌analyse‌.‌ ‌ ‌

‌‌

Steps‌ ‌to‌ ‌customise‌ ‌subject‌ ‌names‌ ‌in‌ ‌PivotTable‌ ‌ ‌

To‌ ‌add‌ ‌or‌ ‌take away‌ ‌fields‌ ‌in‌ ‌PivotTable,‌ ‌click on‌ ‌on‌ ‌the‌ ‌PivotTables‌ ‌Fields‌ ‌pane‌ ‌and‌ ‌select‌ ‌the‌ ‌subject‌ ‌title‌ ‌checkbox‌ ‌to‌ ‌add‌ ‌or‌ ‌take away‌ ‌any‌ ‌subject‌ ‌as‌ ‌per‌ ‌‌the‌ ‌‌your‌ ‌‌want.‌‌ ‌Additionally,‌ ‌ ‌You‌ ‌can‌ ‌additionally‌ ‌drag‌ ‌a‌ ‌subject‌ ‌from‌ ‌one‌ ‌space‌ ‌to‌ ‌one other‌ ‌‌to‌ ‌the‌ ‌goal‌ ‌space‌ ‌of‌ ‌‌in‌ ‌‌PivotTable.‌ ‌ ‌

Leave a Reply

Your email address will not be published.

10 Most Expensive Things Owned By North Korea’s Dictator King Jong-un

Wifi Hot spot Jio Phone

Latest OMG! Now You Can Use Wi Fi Hotspot on Your Jio Phone