852 results for wps office compatible with microsoft office
- All Tutorials
- Video Tutorials
- Quick Tutorials
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....
Create formula with structured references in WPS Office Excel
Welcome to WPS Official Academy to check the contents of how to create formula with structured references in WPS Office Excel. · Explicit reference & Structured reference in WPS SpreadsheetBefore learning how to use structured reference, it’s best to know what it is and why it is used first. Here we introduce another concept Explicit reference for comparison.1. What is Explicit ReferenceExplicit Reference is mostly used in our daily work. When you input the specific cell range like C2:....
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. · ....
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....
How to analyze trends with TREND function in WPS Office Excel
In this article, you will know how to analyze trends with TREND function in WPS Office Excel with simple steps as following: · Know about the TREND function in WPS Spreadsheeto Principle of the TREND functionThe TREND function predicts the linear increasing amount based on the current data (y=mx+b).o Syntax of the TREND functionTREND([known_y's], [known_x's], [new_x's], [logical values]) o Explanation of the TREND functionKnown_y's (required): the set of y-values you al....
How to convert ppt to pdf with hyperlinks in WPS Office
Sometimes when you need to save a presentation as a PDF file, some hyperlinks and notes may be lost. To avoid this problem, you can convert ppt to pdf with hyperlinks in WPS Office. Steps to convert ppt to pdf with hyperlinks in WPS Office:1. Open your ppt file in the WPS Office. 2. To save it as .pdf format, go to Menu and click Export to PDF, or go to the Tools tab and click Export to PDF to pop up the dialog box.3. Choose the ppt file and click Export to PDF. After completing the a....
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....