Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • creating quarterly reports in excel

      29 results for creating quarterly reports in excel

      • All Tutorials
      • Video Tutorials
      • Quick Tutorials
      • All
      • Spreadsheet
      • Presentation
      • Writer
      • PDF

      29 results for creating quarterly reports in excel

      How to link WPS Writer and Spreadsheet together

      How to link WPS Writer and Spreadsheet together

      02:26

      How to link WPS Writer and Spreadsheet together

      In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

      Writer 10 views
      How can we change the font in a cell

      How can we change the font in a cell

      01:09

      How can we change the font in a cell

      When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

      Spreadsheet 2,223 views
      Create the double-layer doughnut chart

      Create the double-layer doughnut chart

      03:22

      Create the double-layer doughnut chart

      The double-layer doughnut chart can visually display the proportion of multiple data. As shown in the chart, this is the annual sales of a certain sales company. In this chart, we can see the proportion of sales per month and the sales percentage for each quarter. So how do we create the double-layer doughnut chart?First select the quarterly sales data in the cell range B2:B13, click the Insert tab and click the Insert Pie or Doughnut Chart drop-down button, then choose Doughnut in the....

      Spreadsheet 103 views
      How to group data in a spreadsheet

      How to group data in a spreadsheet

      02:01

      How to group data in a spreadsheet

      When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

      Spreadsheet 387 views
      Use slash header to show the title name

      Use slash header to show the title name

      01:25

      Use slash header to show the title name

      Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

      Spreadsheet 71 views
      More features in Split and Merge

      More features in Split and Merge

      04:37

      More features in Split and Merge

      In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

      Spreadsheet 244 views
      Refresh pivotTable and change data source

      Refresh pivotTable and change data source

      01:28

      Refresh pivotTable and change data source

      If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....

      Spreadsheet 203 views
      Quickly create dynamic charts

      Quickly create dynamic charts

      01:12

      Quickly create dynamic charts

      We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....

      Spreadsheet 83 views
      Prev 1234 Next
      WPS Academy