- All Tutorials
- Video Tutorials
- Quick Tutorials
269 Search results
Look up data quickly with LOOKUP function04:23
Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
How to set up a slideshow in WPS Presentation01:47
How to set up a slideshow in WPS Presentation
Before we preview or make a presentation with slides, we should set up the slideshow in advance. So, how are we going to set it? Take these slides as an example. We first need to click the Slide Show tab at the top and then click the Set Up Show drop-down button. Here, we can set the slideshow as Manual or Auto.If we want to customize the slideshow settings, click the Set Up Show button. In the popup Set Up Show dialog box, we can also set the show type, multiple monitors, etc... In Sh....
How to set up custom slide shows in WPS Presentation01:40
How to set up custom slide shows in WPS Presentation
When using WPS Presentation, how can we adjust the content and order of the slide show without deleting the original slides or even changing the page order of the original slides? The Custom Slide Shows feature can help us. Click the Slide Show tab at the top of the screen, and click the Custom Slide Shows button. In the popup dialog, click the New button to customize the settings for the slide show.In the popup Define Custom Show dialog, we can enter the name of the custom show in the....
How to set up multilevel numbering in WPS Writer03:45
How to set up multilevel numbering in WPS Writer
When editing a long article, we can insert bullets and numbering to present the article structure clearly. In the following example, you will see a demonstration to create multilevel lists. Here are the steps. 1. Select the text to be numbered. Next, go to the Home tab, click the Numbering drop-down button, and choose More Numbering. The series of operations will pop up the Bullets and Numbering dialog. 2. Click the Outline Numbered tab inside. After that, we can see several numbering ....
How to insert a GIF into slides in WPS Presentation
1. After we open a slide in WPS Presentation, we first click select the slide we want to insert a GIF into. 2. Then click the Insert tab, and click the Picture button.3. Now select the GIF we want to insert in this popup window and click the OK button below.4. We can click the slide show from current button in the status bar below, and then we can view the GIF in our presentation.This skill could be compatible with Microsoft Office powerpoint.
How to set up a slideshow in WPS Presentation
1. Use WPS Office to open slides.2. Click the Slide Show tab → the Set Up Show button.3. In the pop-up dialog box, we can set up a slideshow in details, including "Show type", "Show options", "Multiple monitors", "Range of slideshow", and "the way to change slides".4. After we have finished settings, click the OK button. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.
Learn pivot table from the beginning04:27
Learn pivot table from the beginning
A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....
Print page setup in WPS Spreadsheet01:20
Print page setup in WPS Spreadsheet
When we need to print a table, if we are not satisfied with the effect of the currently displayed page, how can we quickly set up the page? Take this table as an example. Click Print Preview in the quick access toolbar to enter the print preview interface. Click the Page Setup button, then the Page Setup dialog box will pop up. In the Page tab, we can adjust the Orientation and Scaling of the page and the related settings of the printer. In the Margins tab, we can precisely adjust the....