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
      • excel courses for beginners free

      125 results for excel courses for beginners free

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

      125 results for excel courses for beginners free

      How to convert word/excel/ppt to pdf for free in WPS Office

      Welcome to WPS Official Academy! Are you looking for free pdf converter with powerful functions? That's it! WPS Office is a perfect choice for you to convert word/excel/ppt to pdf files for free. After reading this quick tutorial, you are able to quickly perform conversions between word/excel/ppt and pdf. lSimple steps to convert word/excel/ppt to pdf for free in WPS Office1. Open the word/excel/ppt documents you want to convert in WPS Office.2. Go to the Tools tab, and click Expor....

      PDF 322 views
      Batch export multiple pictures

      Batch export multiple pictures

      00:54

      Batch export multiple pictures

      If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

      Spreadsheet 6 views
      Use Validation to prevent duplicate values

      Use Validation to prevent duplicate values

      01:23

      Use Validation to prevent duplicate values

      Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

      Spreadsheet 13 views
      Split Books by Sheet

      Split Books by Sheet

      01:09

      Split Books by Sheet

      Do you know how to split your worksheet?Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet. In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down m....

      Spreadsheet 3 views
      How to use the Selection Pane in WPS Spreadsheet

      How to use the Selection Pane in WPS Spreadsheet

      01:49

      How to use the Selection Pane in WPS Spreadsheet

      How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....

      Spreadsheet 20 views
      How to filter data horizontally

      How to filter data horizontally

      01:34

      How to filter data horizontally

      The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....

      Spreadsheet 19 views
      Remove parentheses and the content inside quickly

      Remove parentheses and the content inside quickly

      01:44

      Remove parentheses and the content inside quickly

      When processing a table, we may find that some information contains parentheses, but it'd be troublesome to delete them one by one. Today, we're going to learn the skill to delete these parentheses and the content inside quickly. Take this table as an example. There are parentheses following the actors' names, and we want to delete these parentheses and the nationality inside. 1. Select the cell range which contains the parentheses and press Ctrl+H to pop up the Replace di....

      Spreadsheet 3 views
      How to insert a text box in Spreadsheet

      How to insert a text box in Spreadsheet

      03:13

      How to insert a text box in Spreadsheet

      The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....

      Spreadsheet 33 views
      Prev 123...1516 Next
      WPS Academy