53 results for microsoft courses near me
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
53 results for microsoft courses near me
More features in Document Encryption
02:14More 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....
Text direction in WPS Presentation
02:34Text 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....
Use the ROUND function to round decimals quickly
01:57Use the ROUND function to round decimals quickly
In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....
Use VLOOKUP function to create dynamic charts
03:44Use VLOOKUP function to create dynamic charts
In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....
How to enter text vertically in cells
In most situations, when entering text context into a cell WPS Spreadsheet, the characters are arranged from left to right. How can we type vertically in WPS Spreadsheet?1. Right-click the cell → choose Format Cells in the dropdown list 2. Get into the Alignment tab in the Format Cells dialog, and check the Vertical text box. Then, the characters would present vertically.WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot ta....
How to convert PDF to PPT in WPS Office online?
In this free tutorial, you will master how to convert PDF to PPT in WPS Office with simple steps as follows: · Steps to convert PDF to PPT in WPS Office.1. Open the PDF file you want to convert to PPT.2. Navigate to the Tools tab, and click PDF to PPT. 3. Select the file you want to convert.4. Set the exported file format at Save as type.5. Set the location to save the exported file at Save as location.6. Click Start. 7. Then you can continue to edit the PPT in WPS Presentation as need....
How to capitalize letters in WPS Office Word
When editing a word document, we often need to capitalize the letters of some specific words like abbreviations, proper nouns, etc.It's quite simple to capitalize letters in WPS Office Word. Now let's begin!lSteps to capitalize letters in WPS Office Word1. Open the document in WPS Writer.2. Select the letter to be capitalized.（Tips: Press the Ctrl key to select multiple letters separately.) In the Home tab, click the Change Case button. And check Uppercase or Togglecase.3. You ....
How to split PDF file into multiple pages quickly in WPS Office
Are you ready to master how to split PDF quickly in WPS Office? After learning this WPS free tutorial, you will be advanced from a beginner in WPS PDF. · Steps to split PDF quickly in WPS Office.1. Open the PDF file you need to split.2. Go to the Page tab > Split PDF. 3. Select the PDF file to split.4. Set the Page range, and set the splitting method at Split by.5. Set the location to save the split PDF file at Save as location.6. Click Split. With these steps, you are able to split P....