123 results for office courses near me
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
123 results for office courses near me
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....
Recalculate the table formulas in the Manual Recalculation mode
01:20Recalculate the table formulas in the Manual Recalculation mode
Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....
Worksheet and workbook
01:48Worksheet and workbook
Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....
How to make a resume template in WPS Office Word
Welcome to WPS Academy! Are you searching for free courses about making a resume template? A professional and informative resume is the prerequisite for standing out from your competitors. Continue to read this free tutorial and quickly master how to make a resume template in WPS Office Word. lSteps to make a resume template in WPS Office WordØFirst of all, we need to figure out the basic sections that constitute a professional resume.u Full nameu Ideal positionu Contact informationu ....
Print out tables
02:43Print out tables
In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....
Combine the SUBSTITUTE and LEN functions
02:57Combine the SUBSTITUTE and LEN functions
Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....
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....
Quickly convert PDF to editable word in laptop
It’s convenient to save a document as a PDF document to protect the content inside, but what if you need to edit it later? WPS Office provides the PDF to Word function, allowing you to convert a PDF to an editable word document quickly! Now let’s have a try step by step. · Steps to convert PDF to editable word in WPS Office1. Open your PDF document in WPS Office.2. Navigate to the Tools tab > PDF to Word. Then a dialog pops up. 3. Select the document to be converted, set the Page Range....