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

        1780 results for windows excel spreadsheet

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

        1780 results for windows excel spreadsheet

        Edit settings in WPS Spreadsheet

        Edit settings in WPS Spreadsheet

        03:47

        Edit settings in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

        Spreadsheet 24.3K views
        Hyperlink in WPS Office Spreadsheet

        Hyperlink in WPS Office Spreadsheet

        02:22

        Hyperlink in WPS Office Spreadsheet

        When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

        Spreadsheet 87.5K views
        Formatting time in WPS Spreadsheet

        Formatting time in WPS Spreadsheet

        01:08

        Formatting time 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. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

        Spreadsheet 15.5K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        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 how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 12.5K views
        TEXT formula in WPS Spreadsheet

        TEXT formula in WPS Spreadsheet

        03:09

        TEXT formula in WPS Spreadsheet

        The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

        Spreadsheet 22.6K views
        Get to know WPS Spreadsheet

        Get to know WPS Spreadsheet

        10:26

        Get to know WPS Spreadsheet

        1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

        Spreadsheet 52.3K views
        The Camera in WPS Spreadsheet

        The Camera in WPS Spreadsheet

        01:44

        The Camera in WPS Spreadsheet

        Today we will get to know the Camera in WPS Spreadsheet. With this feature, we can convert the table into a picture, and the contents of the picture will change as those of the table. Here are two sheets: Itinerary and Tour Route Planning Table. To make it convenient for comparison, we would like to place them side by side. Most people may choose to copy the data of the Tour Route Planning Table sheet and paste it into the Itinerary sheet. However, this is not a perfect way. First, we....

        Spreadsheet 7.0K views
        WPS Spreadsheet basic editing

        WPS Spreadsheet basic editing

        02:12

        WPS Spreadsheet basic editing

        This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....

        Spreadsheet 15.1K views
        Prev 1 2 3 ... 222 223 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