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

        1395 results for how big is the free dropbox account

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

        1395 results for how big is the free dropbox account

        How to insert a background image and print it out in WPS Spreadsheet

        How to insert a background image and print it out in WPS Spreadsheet

        01:31

        How to insert a background image and print it out in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

        Spreadsheet 47.3K views
        How to insert a signature in a PDF file

        How to insert a signature in a PDF file

        02:16

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

        PDF 27.8K views
        How to convert PDF files into pictures

        How to convert PDF files into pictures

        01:59

        How to convert PDF files into pictures

        We use powerful PDF in our daily life nearly every day. WPS pdf converter is easy and free for people to use.When viewing a PDF file, we may want to save the file content as a picture. So how can we do that? Take this file as an example. Click the Tools tab, then click PDF to Picture. Now a dialog box will pop up. Here, we can set the converted picture, such as Watermark, Pages, Quality and so on.We can choose output By Page or output Long picture according to actual needs.As for the u....

        PDF 43.9K views
        Combine the SUBSTITUTE and LEN functions

        Combine the SUBSTITUTE and LEN functions

        02:57

        Combine the SUBSTITUTE and LEN functions

        Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

        Spreadsheet 12.2K views
        How to set custom symbols and symbols shortcut key

        How to set custom symbols and symbols shortcut key

        01:32

        How to set custom symbols and symbols shortcut key

        In the process of editing documents, we occasionally need to re-enter the same symbols. Take this table as an example. When we make an account for purchased fruits, we need to enter the weight unit kg, so how can we quickly enter it? In the Insert tab, click the Symbol drop-down button, and then click More Symbol to pop up a dialog box.In the Custom Symbols tab, we can see many system-defined symbols, including the kg we need to enter. After clicking kg, click the Shortcut keys edit b....

        Writer 16.8K views
        How to use the formula function of table in WPS Writer

        How to use the formula function of table in WPS Writer

        02:38

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

        Writer 9.1K views
        Use subtotal feature to do statistic

        Use subtotal feature to do statistic

        04:35

        Use subtotal feature to do statistic

        The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....

        Spreadsheet 9.3K views

        How to combine debit and credit columns in WPS Office Excel

        Welcome to WPS Official Academy to check the contents of how to combine debit and credit columns in Excel. · What is Debits and Credits?According to WIKIPEDIA, debits and credits in double entry bookkeeping are entries made in account ledgers to record changes in value resulting from business transactions. A debit entry in an account represents a transfer of value to that account, and a credit entry represents a transfer from the account. Debits and credits are traditionally distinguis....

        xls Spreadsheet 20.0K views
        Prev 1 2 3 ... 174 175 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