How to create a pivot table in excel 2013





Posted By nikki
List ViewGrid View

This guide is part of the Microsoft Excel 2013 series



Make: Microsoft

Model / Product: Excel

Version: 2013

Objective / Info: Learn To Create A Pivot Table In Excel 2013.


1
Launch Excel by clicking on the desktop icon.

2
First of all, fill the Excel Worksheet with the relevant data. Now, select the entire data range you wish to create a pivot table for.
3
Go to the ‘Insert’ tab and click the ‘Pivot Table’ icon to insert the Pivot Table.
4
Select the targeted cell you wish the Pivot Table to be inserted in. For beginners, select ‘New Worksheet’ option to create the new worksheet with the Pivot Table.
5
The new worksheet will open. On the right, you can see the Pivot Table Panel containing useful options for working with the table.
6
This task should be complete. Review the steps if you had any issues and try again.Submit questions or request for more guides in the questions section below.

|






comments powered by Disqus

Tag : Pivot Table

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment