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

        449 results for write a short note on ms excel

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

        449 results for write a short note on ms excel

        How can we draw a line chart

        How can we draw a line chart

        02:36

        How can we draw a line chart

        The line chart is mainly used to show the trends in data and is also one of the most commonly used chart styles at work. This table shows the number of newly hired employees and the number of employees who resigned from the company from 2000 to 2021. So how can we quickly generate a line chart on this? 1. Select all the data in column B. 2. Click the Chart button in the Insert tab, and choose the Line option. In this way, we can get a simple line chart.If we modify the data in the data....

        Spreadsheet 14.4K views
        Print out tables

        Print out tables

        02:43

        Print out tables

        In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

        Spreadsheet 6.8K views
        Rows and columns tools in WPS Spreadsheet

        Rows and columns tools in WPS Spreadsheet

        02:34

        Rows and columns tools in WPS Spreadsheet

        Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....

        Spreadsheet 40.1K views
        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
        Custom cell formats

        Custom cell formats

        03:48

        Custom cell formats

        When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

        Spreadsheet 8.4K views
        Format Cells Locked and Hidden

        Format Cells Locked and Hidden

        01:21

        Format Cells Locked and Hidden

        When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....

        Spreadsheet 19.5K views
        Get to know the cell widget

        Get to know the cell widget

        02:38

        Get to know the cell widget

        Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....

        Spreadsheet 8.0K views

        10 best itinerary example templates in excel

        10 Best Itinerary Example Templates in Excel: Itinerary means travel blogging. There are a lot of us who are unaware of the trip excel templates. The fact is different from what we believe, excel work is not all that the software is made up of. As is common knowledge, it offers a large number of templates that pique your curiosity regarding fresh and original ones. You can plan your travels, write down your plans for a romantic getaway, and generally prepare in a note book that resembl....

        xls Spreadsheet 4.6K views
        Prev 1 2 3 ... 56 57 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