WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • free microsoft office lessons

    471 results for free microsoft office lessons

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

    471 results for free microsoft office lessons

    Free PowerPoint templates specially for you in WPS Office

    Come to WPS Office and get immediate access to thousands of free PowerPoint templates! With these appealing PowerPoint templates, you are free from the troublesome process of searching for decorative elements and racking your brains to design slides. To enjoy diverse fancy templates, don’t hesitate to click here to download WPS Office for free now. · Steps to download free PowerPoint templates in WPS Office.1. Open WPS Office on your device.2. Go to the homepage, click Apps and then cl....

    Presentation views

    Quickly convert PDF to JPG for free online in WPS Office

    Welcome to WPS Official Academy! Are you searching for the contents of how to convert PDF to JPG online free? After reading this quick tutorial, you will be able to master how to convert PDF to JPG for free online in WPS office within 4 steps.lSteps to convert pdf to jpg for free online in WPS Office1. Open the PDF you want to convert in WPS Office.2. Head to the Tools tab, and click the PDF to Picture button. 3. In the pop-up dialog, complete the settings as Export Type, Watermark, Pa....

    PDF views

    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

    Free Word templates specially for you in WPS Office

    The use of Word document is not limited to pure writing. Posts, resumes, schedules and the like can also be designed and created in a word document. To make a word page with a sense of design, you can download free Word templates in WPS Office. · Steps to download free Word templates in WPS Office.1. Open WPS Office.2. Head to the homepage > Apps > Templates to enter the template library. 3. Click Document on the left to view the templates for word.4. Click the theme on the top to view....

    Writer views
    Use the Mail Merge function to input tabular data quickly

    Use the Mail Merge function to input tabular data quickly

    01:49

    Use the Mail Merge function to input tabular data quickly

    WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

    Writer views

    How to convert PPT to PDF online for free in WPS Office

    WPS Academy is here to provide you with a free tutorial of how to convert PPT to PDF online for free in WPS Office. · Steps to convert PPT to PDF online for free in WPS Office.1. Open your PPT in WPS Office.2. Navigate to the Tools tab, and click Export to PDF. In the Export to PDF dialog:1. Select the PPT file to convert.2. Input the pages to convert at Export range.3. Set the position to save the exported PDF file at Save Path.4. Choose the Export Type between Common PDF and Image PD....

    Presentation 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
    Prev 123...5859 Next
    WPS Academy
    Products
    Partners