WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to switch between desktops mac

    924 results for how to switch between desktops mac

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

    924 results for how to switch between desktops mac

    Easily drag videos into your presentation

    Easily drag videos into your presentation

    00:48

    Easily drag videos into your presentation

    Hi there, friends. How did you insert audio or videos into slides?You may be familiar with the following procedures: Click Movie in the Insert tab. Click Local video to switch back and forth between different files. If there are multiple videos, you have to pick each one individually before clicking Open.Let's count how many steps are involved? Good news! It takes only one step in WPS Office's latest version. Select the files to insert, and drag them into your slides. Whoosh! T....

    Presentation 3.3K views

    How to switch rows and columns in WPS Spreadsheet

    How to switch rows and columns in WPS Spreadsheet1. First use mouse to select all table contents.2. Use the shortcut key CTRL+C to copy cell contents. 3. Click the sell where we want to put the table.4. Then right-click Paste Special → Transpose. Now the horizontal data is changed to vertical. Remember to select the original data and right-click to delete.This skill could also be used in Microsoft Office Excel and OpenOffice.

    xls Spreadsheet 7.1K views

    How to extract text between two characters in Excel

    How to extract text between two characters in Excel – WPS Academy. Nowadays excel plays a vital role in every financial need and performs its functions in every manner. It makes work easy for individuals to work properly and smartly. Furthermore, it also saves a lot of time. There is also a function in excel which is known as, How to extract text between two characters in Excel. This function can be performed in a spreadsheet through various methods. First, we use MID, LEFT, and FIND f....

    xls Spreadsheet 3.9K views
    How to view workbooks side by side

    How to view workbooks side by side

    01:21

    How to view workbooks side by side

    Switching back and forth between different workbooks is inconvenient for checking data. Today we will tell you how the View side by side function can help.For example, suppose we want to check whether the data in March is identical in the Quarterly Sales and Monthly Sales sheets. Click the View side by side in the View tab. The interface will then be divided into two sections, one on the left and one on the right. The quarterly sales sheet is on the left while the monthly sales sheet i....

    Spreadsheet 1.7K views
    How to group objects in WPS Spreadsheet

    How to group objects in WPS Spreadsheet

    01:20

    How to group objects in WPS Spreadsheet

    In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....

    Spreadsheet 2.5K views

    How to add comma in Excel column between names

    Comma in excel online, 2016 and 2019: Excel uses the comma style to separate different lengths of numbers, such as hundreds, thousands, millions, etc. Users are able to read and spell the numbers incorrectly because to this. Select Format Cells from the right-click menu, then check the option next to Use 1000 separator in the Number section to enable the comma in any cell (,). In the number part of the Home menu ribbons, we may also utilise the comma style. To apply comma style, we ca....

    xls Spreadsheet 19.0K views
    Create simple and intuitive mini charts

    Create simple and intuitive mini charts

    03:10

    Create simple and intuitive mini charts

    The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

    Spreadsheet 2.2K views

    How to switch data from rows to columns in Excel

    1. Select the table for operation, and right-click to copy it (Shortcut key: Ctrl + C).2. Right-click on the cell for the new table → click Special Paste → click Transpose.WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

    xls Spreadsheet 2.8K views
    Prev 1 2 3 ... 115 116 Next
    WPS Academy
    Products
    Partners