344 results for quick tutorials
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
344 results for quick tutorials
The SUMPRODUCT function for quick calculation of total sales
01:44The SUMPRODUCT function for quick calculation of total sales
When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....
How to use the Quick Parts function in WPS Writer
02:20How to use the Quick Parts function in WPS Writer
Do you know how to skillfully use the Quick Parts function to improve efficiency instead of inputting tedious content repeatedly?In our daily life, the Quick Parts function is mainly used in two ways. · Input commonly used text quickly.The Quick Parts function is to save and reuse specified parts of the text, which act like building blocks. When we need to input the same thing repeatedly, we can build such building blocks in the document for quick use, that is, to create quick parts. T....
Quick to learn the time and dates functions
11:58Quick to learn the time and dates functions
1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other
A quick way to calculate sum, average, count, max, and min
01:34A quick way to calculate sum, average, count, max, and min
Here we have received a sheet on the Masks Sales in Single-Day Sheet from a supermarket. How can we quickly calculate the sum, average, maximum, and daily sales volume during the period from August 19th to 31st?We can use the AutoSum feature of the WPS Spreadsheet, rather than calculating all data one by one with a calculator, which would be a waste of time. Follow these step.1. Select the data area, click the AutoSum drop-down button in the Formulas tab.2. Find the Sum button and clic....
Must-have shortcut tricks in making slides
02:24Must-have shortcut tricks in making slides
During study and work, WPS Presentation is often needed to make a PPT. What makes a high-quality PPT during a short time? In today's tutorials, we will learn a few quick tips commonly used in creating slideshows and thus improving efficiency. · Create a new slideSelect any slide, use the shortcut key Enter, or press Ctrl+Enter together to quickly insert a blank slide. · Delete the current slideSelect the current slide and use the shortcut key Delete or press Ctrl+Delete to remove i....
How to customize the quick access toolbar
1. Open the PPT file. (Here, we take PowerPoint as an example.)2. The quick access toolbar is on the right side of Menu. 3. Click Menu in the upper left corner → Options.4. In the pop-up dialog, click Quick Access Toolbar. Then, we can customize the quick access toolbar.5. We can choose commands as needed in the left box, and click the Add button to add them in the Options Currently Displayed on the right side. Or we can delete the commands in the Options Currently Displayed box by cli....
10 Quick Inventory Spreadsheet Template Excel
10 Quick Inventory Spreadsheet Template Excel - WPS Office A spreadsheet is a versatile and easy-to-use tool for tracking and managing inventory, regardless of the size of your business. There's no reason to rely on manual methods anymore, whether you're operating a small retail store, restaurant, or manufacturing business. Using inventory spreadsheet template excel, you can digitize inventory and sales systems quickly and easily. A better cash flow is a result of less wastag....
10 Quick Vacation Schedule Template Excel
10 Quick Vacation Schedule Template Excel - WPS Office Getting everything done correctly during a vacation requires proper planning (Event Planning Templates) and preparations, which is where free and premium vacation schedule template excel can help. These top templates will help you plan a vacation easily. WPS Office down all the details about the timing, locations, activities, and places to visit, and organize them in pre-designed schedules. Explore the vacation schedule template ex....