ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

Example of Pivot Table – Excel

EXAMPLE OF PIVOT TABLE
1. Select any cell in the data dump > Select Insert > Select Table
Then, create a PivotTable from that table:
2. In the Insert tab, select Recommended PivotTables
Choose from one of Excel’s Recommended PivotTables. In this example, we have chosen to summarize Sum of Sales (in thousands)
by Region, Month and Product.
If you change your data dump, choose Analyze and then Refresh All, to refresh data in pivot table.
Views: 7

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close