WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to auto populate dates in excel

    268 results for how to auto populate dates in excel

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

    268 results for how to auto populate dates in excel

    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 views
    Use the Today function to quickly calculate days between dates

    Use the Today function to quickly calculate days between dates

    01:57

    Use the Today function to quickly calculate days between dates

    In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

    Spreadsheet 0.1814 views
    How to crop a PDF file

    How to crop a PDF file

    01:41

    How to crop a PDF file

    PDF is a common file format at work, which cannot be easily modified. If we want to delete a part of the page quickly, we can use the Crop function for WPS VIP members. Take this file as an example. We can see the proportion of the text and margins is obviously out of harmony. How can we adjust it? · Step 1You can find crop page in the Edit tab. Also, you can click crop page in the Page tab. When the dotted lines appear around the page, click Auto Cropping, and WPS Office will automati....

    PDF views

    How to set up auto scroll in a PDF file

    1. Use WPS Office to open the PDF file.2. Click the Home tab → the Auto Scroll button. Then the PDF file can roll pages automatically.3. Click the Auto Scroll drop-down button, then we can choose the speed of the scroll and the direction of the scroll. With WPS PDF, you can read, take annotation, compress, convert PDF to jpg, highlight, search, process & edit pdf documents on Windows, Mac, PC, and Android platforms.

    PDF 0.1272 views
    Use the DATEDIF function to calculate the intervals of dates

    Use the DATEDIF function to calculate the intervals of dates

    03:12

    Use the DATEDIF function to calculate the intervals of dates

    The DATEDIF function is mainly used to calculate days, months, or years between two dates. Now we are going to use this table to show you the usage of this function. This table records the entry date of the company’s employees. Now we want to calculate the employee’s year of service. We can first click cell C2 and then click Insert Function. Insert DATEDIF in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up.Start dat....

    Spreadsheet 0.1962 views

    How to unhide rows in excel

    When using WPS Spreadsheet to process data, the Hidden Row function can hide the data temporarily not in need. The double line presents in between two columns means one/several column(s) has/have been hidden. For instance, Column B is hidden in the following screenshot. How can we show the hidden rows again in excel?1. Select Columns A to C.2. Right-click on it, and choose Unhide. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    Spreadsheet 0.1578 views

    How to calculate attrition in excel

    Are you ready to master how to calculate attrition in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. · What is attrition? Attrition refers to the voluntary and involuntary reduction of a company's workforce during a period of time. Attrition rate is also known as employee turnover, which can reflect the percentage of outgoing employees. Attrition Rate = No. of employees left/Closing Balance Closing balance: Opening balance+Emplo....

    Spreadsheet views

    How to wrap text in Excel

    · Option 1:1. Double-click the cell that needs to be wrapped.2. Click where we want a line break, and press the shortcut Alt+Enter.3. Then, we can wrap the text in this cell. · Option 2:1. Click the cell that needs to be wrapped.2. Click the Home tab and the Wrap Text button. 3. Then, the Cell contents will be wrapped automatically according to the column width. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

    Spreadsheet views
    Prev 123...3334 Next
    WPS Academy
    Products
    Partners