WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        344 results for quick tutorials

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        344 results for quick tutorials

        The SUMPRODUCT function for quick calculation of total sales

        The SUMPRODUCT function for quick calculation of total sales

        01:44

        The 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....

        Spreadsheet 13.0K views
        How to use the Quick Parts function in WPS Writer

        How to use the Quick Parts function in WPS Writer

        02:20

        How 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....

        Writer 7.7K views
        Quick to learn the time and dates functions

        Quick to learn the time and dates functions

        11:58

        Quick 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

        Spreadsheet 10.3K views
        A quick way to calculate sum, average, count, max, and min

        A quick way to calculate sum, average, count, max, and min

        01:34

        A 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....

        Spreadsheet 52.6K views
        Must-have shortcut tricks in making slides

        Must-have shortcut tricks in making slides

        02:24

        Must-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....

        Presentation 7.3K views

        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....

        ppt Presentation 9.5K views

        The 10 quick excel donation spreadsheet templates

        The 10 Quick Excel Donation Spreadsheet Templates Excel Donation Spreadsheet Templates can be a quick and easy way to keep track of your donations. You can use them to track both monetary and non-monetary donations, and they can be customized to meet your specific needs. Excel Donation Spreadsheet Templates can be used for both one-time and recurring donations, and they can be emailed or printed for easy tracking. If you're looking for a quick and easy way to track your donations,....

        xls Spreadsheet 7.5K views

        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....

        xls Spreadsheet 22.1K views
        Prev 1 2 3 ... 42 43 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube