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

        1500 results for excel slicer

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

        1500 results for excel slicer

        Quickly create dynamic charts with the slicer

        Quickly create dynamic charts with the slicer

        01:12

        Quickly create dynamic charts with the slicer

        We often use dynamic charts in our practical work. Use the mouse to select different preset items in the slicer. Then the chart will change with the selected item. This video will show you how to quickly create simple dynamic charts. Take this table as an example. We select any cell in the table, click Table under the Insert tab to create a super table, or we can use the shortcut Ctrl+L to quickly open Create Table, and click OK. Get into the Table Tools tab, and click Insert Slicer. I....

        Spreadsheet 12.2K views
        Use PivotTable to analyze data 2

        Use PivotTable to analyze data 2

        10:15

        Use PivotTable to analyze data 2

        1.Introduces several causes of pivot table errors.We should standardize the original table. Blank cells in fields, irregular dates format, merged cells, or numerical texts in numerical values will trigger errors.2.Introduced the basic rules of using pivot charts.PivotChart can show the data trend. The X-axis will show the fields in ROWS, while the Y-axis will present the fields in VALUES.3.Slicer can show your leader what they want to see, including fields that aren't in the PivotT....

        Spreadsheet 7.5K views
        How to convert Excel to PDF

        How to convert Excel to PDF

        02:50

        How to convert Excel to PDF

        PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

        Spreadsheet 30.2K views
        Use VLOOKUP function to create dynamic charts

        Use VLOOKUP function to create dynamic charts

        03:44

        Use VLOOKUP function to create dynamic charts

        In the last video, we introduced the tips for making dynamic charts quickly. And this video will show you how to create dynamic charts with the help of the VLOOKUP function. Some knowledge points such as drop-down lists, VLOOKUP function, and absolute references are involved in making dynamic charts. If you are not familiar with these knowledge points, you're welcome to enter WPS Academy to search for learning. Take this table as an example. We're going to create a dynamic char....

        Spreadsheet 13.0K views

        How to add a table in excel cell (Full Guides)

        To create a structured Excel Table from a list of data, use the Table command. You may organise and view your data using the many functions that tables contain, such as sorting and filtering. How to add a table in excel online, 2016 and 2019: 1. Within your data collection, choose any cell. 2. Click the Table button or use the Ctrl + T keyboard shortcut on the Insert tab, in the Tables group. 3. All the data is automatically picked for you when the Create Table dialogue box loads, but ....

        xls Spreadsheet 14.6K views

        WPS Top 10 Excel Lesson plan Excel Templates

        WPS Top 10 Excel Lesson plan Excel Templates The lesson plan template is a detailed description of the course. A detail of the lesson plan varies with time; these plans are documented in order to get a clear idea of what actually students need to learn in a particular time period. These lesson plans excel templates keep the teachers active because they have to deliver the lesson as soon as possible in the given time period. Lesson plan excels templates are the step-by-step process in w....

        xls Spreadsheet 9.2K views

        How to Fix Excel Formulas Showing as Text in Excel

        The Excel software sometimes doesn't show proper results. We will show you to fix the excel showing formula instead of the result.

        xls Spreadsheet 47.1K views

        Top 10 free excel templates for business download for excel

        Top 10 free excel templates for business download for excel In business, there are different templates that it uses that include free formulas, sheets, etc. Excel templates are so widely downloaded and used in offices for so many reasons. Because of its adaptability, you may use it to monitor KPIs, produce sales receipts, and keep track of time sheets. Free excel templates for business is one of the most helpful in our business. These templates can be downloaded for free. It is worthwh....

        xls Spreadsheet 6.3K views
        Prev 1 2 3 ... 187 188 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