Three ways to create Excel PivotTable reports

Source: Internet
Author: User

For the huge data with Excel table of the data perspective function can be easily summarized display, today small make up to share to everyone three ways to create Excel tables, not friends quickly to learn!

Method/Step

The first method is to create a PivotTable report based on the data in the table, first selecting the cell in the data area, as shown in the following figure.

Then click the PivotTable report in the Insert button, as shown in the following image.

The PivotTable dialog box pops up, we move the data source, navigate to all the data regions in the datasheet, then output the PivotTable, select a new worksheet, and click OK, as shown in the following illustration.

When you're done, a blank PivotTable report pops up, and we pull the corresponding data option to the corresponding area, as shown in the figure below, and the arrow points to create our PivotTable report.

The second approach is to create a PivotTable report based on an external data source, first opening a blank data table, as shown in the following figure.

Then click the PivotTable report in the Insert Option button as shown in the following figure.

We choose to use external data after opening, then create a new worksheet Click OK, as shown in the following figure.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.