471 results for free microsoft office lessons
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
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....
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....
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....
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....
Use the Mail Merge function to input tabular data quickly
01:49Use 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....
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....
Batch export multiple pictures
00:54Batch 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....
Use Validation to prevent duplicate values
01:23Use 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, ....