848 results for office wps kingsoft
- All Tutorials
- Video Tutorials
- Quick Tutorials
848 results for office wps kingsoft
Hyperlink in WPS Office Spreadsheet02:22
Hyperlink in WPS Office Spreadsheet
When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....
Set the page printing area in WPS Office Spreadsheet00:47
Set the page printing area in WPS Office Spreadsheet
What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....
Get to know the WPS Spreadsheet02:04
Get to know the WPS Spreadsheet
WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....
Top 5 useful functions of Kingsoft Excel
A good command of Excel is a great advantage in the workplace. To help you through the necessary skills in Excel, Kingsoft Office, also called WPS Office, offers thousands of free tutorials. This article collects 5 top functions of Kingsoft Excel for you to learn quickly. Without further ado, let’s go through them one by one. · Quickly learn 5 top functions of Kingsoft ExcelNote: You can click the following pictures to watch the video tutorials.1. Learn pivot table from the beginning.A....
Adjust shape fill in WPS Presentation01:33
Adjust shape fill in WPS Presentation
When using WPS Presentation to create a presentation, sometimes we need to insert shapes to assist with the presentation and beautify the slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. How can we change the design of shape fill and outline? Left-click the inserted shape, and get into the Drawing Tools tab. Then click the Shape Fill button. There are two options. One is to choose the default style provided by WPS Office,....
Edit settings in WPS Spreadsheet03:47
Edit settings in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....
TEXT formula in WPS Spreadsheet03:09
TEXT formula in WPS Spreadsheet
The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....
Formatting time in WPS Spreadsheet01:08
Formatting time in WPS Spreadsheet
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....