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

        324 results for excel group of companies careers

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

        324 results for excel group of companies careers

        How to group data in a spreadsheet

        How to group data in a spreadsheet

        02:01

        How to group data in a spreadsheet

        When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

        Spreadsheet 13.1K 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 9.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 10.0K views
        How to make a resume to impress picky HR

        How to make a resume to impress picky HR

        04:35

        How to make a resume to impress picky HR

        An amazing resume is a must-have for the employee who wants to stand out among job applications.Today we will learn how to create a resume in excel.First, set the page size.Head to the "Page Layout" tab and set the page as A4 at "Size." Then select the default "Narrow" at "Margins." Step two, decide where to arrange your texts.Before setting the area, click "Page Break Preview" in the lower right corner to change the view mode. So we can better understand the sector locations for the s....

        Spreadsheet 16.0K views
        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL function: Calculate the data with the hidden value

        Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

        Spreadsheet 23.9K 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

        Top 10 excel property management templates

        Top 10 excel property management templates Top 10 Excel property management templates are used for better management of real estate by individual owners and companies. The companies manage the information of the land records and documents are preserved in these templates or sheets. These Top 10 Excel property management templates are free sheets are downloaded from WPS office. These free to download templates provide better experience for proper management of all kinds of properties. R....

        xls Spreadsheet 5.7K views

        How To Convert Text To Columns in Excel (A Complete Guide)

        How to Convert Text to Columns in Excel-WPS Academy Having Excel has become an essential tool in an individual’s daily life has become an important aspect. While recognizing the importance of excel and its benefits, companies are now working towards providing solutions that are easier than excel. However, they have failed to do so, as Excel has proven itself to be one of the easiest available software for accounting and generic work. Having said that, it is important to understand seve....

        xls Spreadsheet 4.0K views
        Prev 1 2 3 ... 40 41 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