145 results for free microsoft training courses
- All Tutorials
- Video Tutorials
- Quick Tutorials
145 results for free microsoft training courses
Create a countdown calendar & Insert current time and date02:14
Create a countdown calendar & Insert current time and date
WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....
How to add a watermark02:14
How to add a watermark
WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....
Use the Mail Merge function to input tabular data quickly01: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....
Text direction in WPS Presentation02:34
Text direction in WPS Presentation
When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....
How to select words quickly01:47
How to select words quickly
Do you select words by simply holding down the left click and dragging the mouse to the desired position?Actually, many quick ways are available. Now let's learn about them one by one.· Click to select a line of words1. Move your cursor to the left of a line of words. 2. Left click to select the line of words.· Double click to select a paragraph1. Similarly, move your cursor to the left of a paragraph.2. Double left click to select the paragraph.Note that paragraphs are separated b....
How to create custom bullets in WPS Writer02:05
How to create custom bullets in WPS Writer
When we edit documents, insert project symbols into appropriate places that could highlight corresponding text contents. In this way, the text would be classified with structured classes. How can we insert project symbols in WPS text? Taking this document as an example, we can see that the difference in font size does not reflect the level of contents very well. If we want to emphasize the relationship between contents, how should we do it? 1. First, choose the corresponding text. 2. ....
More features in Document Encryption02:14
More features in Document Encryption
Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....
How to use the Review feature01:38
How to use the Review feature
If other people revise a document, we can use the review feature to view the revisions. Take this paper as an example. It is revised by two people.If we only want to read Miss Chan's comments, here are the steps. In the Review tab, click the Review drop-down button and click Reviewers. Check your desired reviewer.Then Miss Chan's comments are displayed on the right. Sometimes, a paper may go through multiple revisions and comments.If we only want to read the latest comments, we....