There are 7 free training courses of how to use office suite for PivotTables
How to analyze data using pivot tables in WPS Office Excel
Welcome to WPS Official Academy, and this tutorial helps you master how to use pivot tables to analyze data in WPS Spreadsheet. Steps to create a pivot table and analyze data with it. lCreate a pivot table in WPS Spreadsheet1. Prepare your pivot table data and open it in WPS Office; for example, the following table illustrates the sales of a coffee brand in different countries and months in 2021. Select the range of data you want to analyze in a pivot table. Go to the Insert tab and cl....
How to create an impressive dashboard in WPS Office Excel
Welcome to WPS Official Academy! After reading this free tutorial, you will be able to master how to create an impressive excel dashboard in WPS Office. lWhat is a dashboard in Excel?A dashboard is a visual presentation of key metrics, which is usually composed of various elements including charts, gauges, tables, and figures. It simplifies the complex data and presents the current status at a glance, helping you make decisions easily and quickly. Dashboards are widely used in work rep....
How to use Slicers to filter pivot tables in Excel
Pivot Tables is a powerful feature used to design dynamic charts and extract significant information from a complex data set. And we can use Slicers to filter pivot tables to create awesome worksheets.Suppose we have a set of data illustrating the sales of a coffee brand in different countries in 2021. Here are the steps.1. Go to the Insert tab and click the Slicers button. In the pop-up dialogue box, select the check boxes for the fields you want to display and click OK. 2. You can ....
How to sort a pivot table
1. Open a Spreadsheet with Pivot Table.2. Place the cursor on the heading cell of the data we want to sort.3. Then click the small drop-down button on the bottom right corner of the cell.4. In the drop-down menu, we can select Ascending or Descending according to our needs. This skill could also be used in Microsoft Office Excel and OpenOffice.
How to refresh the pivot table in WPS Spreadsheet
1. Use WPS Office to open the spreadsheet.2. Click the Data tab → and then click the Refresh All button. This skill could also be used in Microsoft Office Excel and OpenOffice.
How to delete a pivot table in WPS Spreadsheet
1. Use WPS Office to open the spreadsheet.2. Click the pivot table we want to delete.3. Click the Options tab → and then click the Delete PivotTable button. This skill could also be used in Microsoft Office Excel and OpenOffice.
How to insert and change the name of the slicers
Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....