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

        1797 results for data validation in excel

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

        1797 results for data validation in excel

        Use Validation to restrict data change

        Use Validation to restrict data change

        02:24

        Use Validation to restrict data change

        We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

        Spreadsheet 6.2K views
        How can we use the data validation feature

        How can we use the data validation feature

        02:46

        How can we use the data validation feature

        We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Take this table as an example. This is the information collection form for US citizens joining tour groups for international travel. We need to fill in the information of all the participants. How can we ensure that the passport numbers and phone numbers we entered will not be wrong? 1. First, select the cell area where data needs to be filled.2. Click the Data tab.3.....

        Spreadsheet 41.1K views
        Data validation to help you limit the content of your forms

        Data validation to help you limit the content of your forms

        11:12

        Data validation to help you limit the content of your forms

        We have learned how to use the Validation function to restrict the entered content.1.To achieve this, we need to set different rules to restrict, such as the date format, text length, value range, and repeated value. 2.If the cell entry rules are restricted in advance, it is best to set up the corresponding error alert to help each other to enter in accordance with the specifications. 3.We also learned the method to create the drop-down menu and multi-level menus with the INDIRECT func....

        Spreadsheet 10.5K 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 27.0K 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
        How to insert a chart and edit the chart data in WPS Presentation

        How to insert a chart and edit the chart data in WPS Presentation

        03:29

        How to insert a chart and edit the chart data in WPS Presentation

        When we use PPT for data reporting, we often insert charts to help us further illustrate.Take this PPT file as an example. So, how can we insert a chart in the slide? Click the Insert tab above, and then click Chart.In the pop-up dialog, we can select many different types of charts.The double-layered doughnut chart provides an intuitive comparison of the changes in the sales data proportion over the past two years. This video takes Doughnut as an example. Click Pie and click Doughnut. ....

        Presentation 15.5K views

        How to use data validation in excel (Formula, Examples, Guide)

        To guarantee that users enter specific values into a cell, use Excel's data validation feature. Excel's Data Validation function can assist users in entering accurate and pertinent information into your worksheets. The type of information that can be input in a cell is limited by data validation, which also gives the user guidance on how to enter data in a cell. A practical and available tool for ensuring data integrity when developing a financial model is data validation in ....

        xls Spreadsheet 5.2K views

        How to use the data validation feature

        We can greatly improve the accuracy of data entry in our work if we use the data validation feature of WPS Spreadsheet. Since this feature is quite complicated, we only briefly introduce some basic usages here. If you want to learn more, you may feel free to watch more related videos in our WPS Academy.First, select the cell range where we want to fill data, and click the Data tab → the Validation button in the upper menu bar. At this time, the data validation box will pop up. We can s....

        xls Spreadsheet 9.4K views
        Prev 1 2 3 ... 224 225 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