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

        164 results for powerpivot update

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

        164 results for powerpivot update

        How to quickly update the table of contents

        How to quickly update the table of contents

        01:10

        How to quickly update the table of contents

        How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

        Writer 17.4K views

        How to update the table of contents

        When using WPS Writer to process word documents, how can we update the table of contents that is automatically created? 1. Open the Word document with WPS Writer. 2. Select the contents in the interface → the Reference tab → click Update TOC. No matter you are a student, teacher, or business professionals can create and edit documents efficiently by WPS Writer as text editors. Easy to use as Microsoft Word.

        doc Writer 13.0K views

        How to update only the page number in a table of contents

        1. Open the document we want to edit in WPS Writer.2. Click on the table of contents.3. Click References tab → and then click the Update TOC button.4. Now a Update Table of Contents small dialog box will pop up. Check Update page numbers only.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.

        doc Writer 8.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
        Make a countdown calendar in WPS Spreadsheet

        Make a countdown calendar in WPS Spreadsheet

        01:37

        Make a countdown calendar in WPS Spreadsheet

        It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

        Spreadsheet 7.6K views
        Create a countdown calendar & Insert current time and date

        Create a countdown calendar & Insert current time and date

        02:14

        Create a countdown calendar & Insert current time and date

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

        Spreadsheet 9.7K views
        Adjust the article structure in the outline view mode

        Adjust the article structure in the outline view mode

        03:01

        Adjust the article structure in the outline view mode

        When we edit a long article, we need to adjust the structure of the article. For example, we need to move parts of the content and quickly change the heading level. But, scrolling and searching page by page is time-consuming. At this point, we can switch to the outline view mode.Go to the View tab, and click the Outline button to switch to the outline view mode. First, I will show you what is displayed on the page in this view mode.1. In the ribbon above, we can adjust the level of the....

        Writer 8.9K views
        How to make elegant charts in WPS Writer

        How to make elegant charts in WPS Writer

        02:11

        How to make elegant charts in WPS Writer

        Plain charts in a word file may fail to attract viewers. Subscribe to WPS Template membership, and you will be free to download beautiful charts from the vast library of charts to enhance the design and appeal of your charts. Click the Insert tab, click the Chart library button, and you are provided with diverse chart types like Column, Line, Pie, etc. You can choose a preferred type, and on the detail page, choose the desired chart to insert into the document quickly. If we need to ....

        Writer 7.6K views
        Prev 1 2 3 ... 20 21 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