WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how do i create an electronic signature in excel

    1569 results for how do i create an electronic signature in excel

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

    1569 results for how do i create an electronic signature in excel

    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 7.4K views
    How to make a simple lottery through the RANDBETWEEN Function?

    How to make a simple lottery through the RANDBETWEEN Function?

    02:02

    How to make a simple lottery through the RANDBETWEEN Function?

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....

    Spreadsheet 4.0K views
    Use pivot chart to create a dynamic chart

    Use pivot chart to create a dynamic chart

    04:49

    Use pivot chart to create a dynamic chart

    A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

    Spreadsheet 3.9K views
    Page setup and print-out for spreadsheets

    Page setup and print-out for spreadsheets

    02:07

    Page setup and print-out for spreadsheets

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....

    Spreadsheet 2.8K views
    Elementary arithmetic functions in WPS Spreadsheet

    Elementary arithmetic functions in WPS Spreadsheet

    02:50

    Elementary arithmetic functions in WPS Spreadsheet

    Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....

    Spreadsheet 4.3K views
    Set Allow Users to Edit Ranges in a protected sheet

    Set Allow Users to Edit Ranges in a protected sheet

    02:04

    Set Allow Users to Edit Ranges in a protected sheet

    As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

    Spreadsheet 2.5K views
    Insert a table into the text & convert between text and table

    Insert a table into the text & convert between text and table

    02:48

    Insert a table into the text & convert between text and table

    When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....

    Writer 5.2K views
    Quickly create dynamic charts with the slicer

    Quickly create dynamic charts with the slicer

    01:12

    Quickly create dynamic charts with the slicer

    We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....

    Spreadsheet 2.9K views
    Prev 1 2 3 ... 196 197 Next
    WPS Academy
    Products
    Partners