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

        2330 results for use date in excel

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

        2330 results for use date in excel

        Use Date function to convert date format

        Use Date function to convert date format

        01:50

        Use Date function to convert date format

        We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

        Spreadsheet 40.6K views
        Use Validation to restrict date entries

        Use Validation to restrict date entries

        01:10

        Use Validation to restrict date entries

        When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....

        Spreadsheet 7.1K views
        Insert date and time in the header or footer

        Insert date and time in the header or footer

        00:55

        Insert date and time in the header or footer

        WPS Writer allows users to add various styles of header and footer, including text, pictures, and date and time. So how can we realize inserting date and time? A footer has been added to this document. So here we take the header as an example to show how to insert date and time. Get into the Header/Footer tab and click Date and Time to pop up the dialog. On the left-hand side of the dialog, we can choose from different formats to present the date and time. Check the Update automaticall....

        Writer 18.3K views
        How to use Notes Master in WPS Presentation

        How to use Notes Master in WPS Presentation

        01:30

        How to use Notes Master in WPS Presentation

        If slides show everything that a speaker says, the slides are dull and the speech is boring for audiences. Therefore, when making slides, we can present the necessary contents on the slides and put the supplementary contents on the notes page to print them out. In order to unify the style of each notes page, we can use the Notes Master feature. With this feature, we can have a unified format for all notes pages, including new notes pages after setting for it. Click the View tab on the ....

        Presentation 8.8K views
        How to use OCR in PDF

        How to use OCR in PDF

        02:12

        How to use OCR in PDF

        Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....

        PDF 21.1K views
        How to use WPSArt in WPS Presentation

        How to use WPSArt in WPS Presentation

        01:51

        How to use WPSArt in WPS Presentation

        Are you still struggling to create a hierarchy like this one when you use WPS Presentation to make the company's annual report? Next, let's learn how to quickly create a hierarchy. Click the Insert tab and the WPSArt button to pop up the Insert WPSArt Dialog pane. Here, we can see the different types of Hierarchy. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Click Hierarchy, and select one of the styles, finally c....

        Presentation 10.6K views
        How to use the screenshot tool in WPS Writer

        How to use the screenshot tool in WPS Writer

        01:29

        How to use the screenshot tool in WPS Writer

        Many people don't know how to take screenshots when using WPS Writer. Let's take a look at how to use the WPS screenshot tool. First, click the Insert tab to find the Screenshot button. And in the Screenshot drop-down list, we can choose the screenshots of areas with different shapes. They are respectively: Rectangle screenshot, Oval screenshot, Rounded rectangle screenshot and Polygon screenshot. We can click Screenshot to take a screenshot within the WPS Writer interface. Its....

        Writer 14.0K views
        How to use the Selection Pane in WPS Spreadsheet

        How to use the Selection Pane in WPS Spreadsheet

        01:49

        How to use the Selection Pane in WPS Spreadsheet

        How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....

        Spreadsheet 10.9K views
        Prev 1 2 3 ... 291 292 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