2390 results for how communication transformed with the use of technology
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
2390 results for how communication transformed with the use of technology
Use COUNT function to count the number of cells with parameters
01:20Use COUNT function to count the number of cells with parameters
When we do data statistics, we can use the COUNT function to count the number of cells containing values. Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number....
How to use the read mode of PDF files
02:09How to use the read mode of PDF files
With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process&edit pdf documents on both windows, mac pc and android mobiles.Today, We will learn how to use PDF read mode.Click the Home tab before clicking the read mode, then the page will automatically hide other irrelevant function buttons, enabling users' immersive reading. · BookmarksWhen the e-book is too lengthy to read all at once, we can add a Bookmark and name it.1. Right-click the b....
How to use the formula function of table in WPS Writer
02:38How to use the formula function of table in WPS Writer
You know what? In WPS Writer, not only can we perform simple calculations on the table data, but apply the formulas of built-in functions. Here are a few commonly used functions for you to explore. Take this table as an example. Assume that we want to count how many Expense there are in the whole table. We can use the COUNT function to count the number of data in the table.Tips: The COUNT function in WPS can only be applied in counting number data, while the empty cells, logical value....
How we can use the settings of borders and shading
01:43How we can use the settings of borders and shading
When we are using WPS Document to edit text, we sometimes need to put a border around the text, or we may also want to add a special shading color to the text in order to highlight the keywords. So now the problem is, how can we do that? Take this resume as an example. If we want to highlight the border, we should select all the content first, and click the Home tab, and then lick the Outside Borders drop-down button. Here, we can see different styles of border lines. Click Borders and....
How to use the fast calculation function of table in WPS Writer
01:21How to use the fast calculation function of table in WPS Writer
Do you know how to perform statistical operations on tabular data inserted in a document? It teaches you to perform quick calculations in a document in one minute.For example, let's say we want to figure out the total sales of small businesses in Q1 for all regions.First of all, insert a total column on the right of the table,select the data cell of row Q1, click the Table Tools tab, click the Fast Calculation drop-down button, and select Sum to calculate the Sum of the data in thi....
How to filter data horizontally
01:34How to filter data horizontally
The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....
How to insert a signature in a PDF file
02:16How to insert a signature in a PDF file
We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....
How to use Slide Master to unify the background of slides
1. Use WPS Office to open the presentation file and click the View tab → and then click the Slide Master button.2. After we jump to the Slide Master interface, click the Object Formatting button on the right side. We set the background in the right column as needed, and click Apply to All.3. Now click the close button to exit the editing process. Note: (a) Now all new slides will use this unified background. (b) If we use this feature only on a single slide that does not belong to any ....