Question

how to analyze data with pivotal in excel? ​

Answer 1

Step #1: Select the “File” menu in a new Excelspreadsheet. ...

Step #2: Select “Import” from the drop down menu. ...

Step #3: Select your file type. ...

Step #1: Select the data you want to analyze. ...

Step #2: Choose “Pivot Table” from the “Data” tab. ...

Step #3: Create the table. ...

Step #4: Open the new worksheet tab.

Answer 2

$<b><i>$ STEPS ⤵️⤵️

⭐enter the given data in a new worksheet and select the entire data range.

⭐choose insert>pivot table and select pivot table option.

⭐if the whole table is not selected then manually select the table including heading.

⭐the new worksheet option is selected by default.

⭐click on OK button.