WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • excel in different windows

    569 results for excel in different windows

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

    569 results for excel in different windows

    More features in Document Encryption

    More features in Document Encryption

    02:14

    More features in Document Encryption

    Both WPS Spreadsheets and Microsoft Excel have the function of document encryption. For users' actual needs, WPS Spreadsheets additionally provide two practical features: Encryption at different levels and Password hints. In Microsoft, two methods are available for document encryption.Method 1Click the "Protect Workbook" drop-down button in the "Info" interface and select "Encrypt with Password." We can only set a password for the excel document in the pop-up dialog but not make it....

    Spreadsheet views
    How to view two sheets side by side

    How to view two sheets side by side

    01:09

    How to view two sheets side by side

    When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

    Spreadsheet views
    More features in Screenshot

    More features in Screenshot

    01:56

    More features in Screenshot

    Both WPS Spreadsheets and Microsoft Excel have the function of a screenshot. What are the differences between them? In Microsoft, we can click the Screenshot drop-down button and select one of the Available Windows to take a screenshot. Click Screen Clipping to capture the screen by adjusting its size manually, and only the area outside the Excel document is available. In WPS Spreadsheets, we have two ways of screenshot for your selection.Option 11. Click the Insert tab, click the Scre....

    Spreadsheet views
    How to consolidate data in WPS Spreadsheet

    How to consolidate data in WPS Spreadsheet

    01:28

    How to consolidate data in WPS Spreadsheet

    In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

    Spreadsheet 0.1635 views
    More features in Screenshot

    More features in Screenshot

    02:02

    More features in Screenshot

    Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....

    Writer views

    How to view documents in multiple windows

    1. Open the document.2. Click the title of the document with the left mouse button, and pull out the document directly by pressing the left mouse button to display the document independently. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

    Writer views
    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 views

    How to insert footnote in word document on Mac or Windows

    In our daily life and work, it is a necessary skill to insert footnote in Office software. When we want to explain some words or sentences, we can insert footnotes in one or a new page in word document on Mac or Window. It is a good choice to insert footnotes in Microsoft Office Word or WPS Office Writer on Mac or Windows. However, many users don't know the methods of inserting footnotes. Today, this article will introduce to you how to insert footnotes in word document on Mac or W....

    Writer views
    Prev 123...7172 Next
    WPS Academy
    Products
    Partners