WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • 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 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 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 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 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 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 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 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 views
    Prev 123...1516 Next
    WPS Academy
    Products
    Partners