How to use the Excel 2016 vlookup formula?

If you use Excel daily to organize your work or business data, you should know how to use some tools. In this opportunity, you will know everything about the vlookup formula and how you will use it correctly. Vlookup is nothing more than a vertical data lookup that you can apply to your Excel document.You have to learn to master the vlookup formula for the sole purpose of improving your work rate. Next, you will learn how to use the tool and apply it in the vlookup formula in excel bet....

How to start a presentation in Chinese?

How to start a presentation in Chinese? It's time for you to learn how to make a Powerpoint presentation, not in a traditional way, but another language. You may need to make a PowerPoint presentation in Chinese for your language school, but you can't find how to do it. If that is your case, you should prepare to know how to make a powerpoint presentation templates easily and safely. However, for you to make the file, you will have to know how to use a power point presentation template....

How to filter blanks or non-blanks with one click

Multiple blank cells in a table are inconvenient for us to look up data. How can we hide them with just one click?Place your cursor at any cell. Click the Filter button at Home or you can use shortcut Ctrl+Shift+L. Then a green corner marker will show in the header line, indicating you are in the filter mode.2. Select the column you'd like to filter. Click the green icon and the data list to filter will pop up. Here, you can choose what to filter. Hover the cursor at Blanks and two....

How to use Slicers to filter pivot tables in Excel

Pivot Tables is a powerful feature used to design dynamic charts and extract significant information from a complex data set. And we can use Slicers to filter pivot tables to create awesome worksheets.Suppose we have a set of data illustrating the sales of a coffee brand in different countries in 2021. Here are the steps.1. Go to the Insert tab and click the Slicers button. In the pop-up dialogue box, select the check boxes for the fields you want to display and click OK. 2. You can ....

How to remove duplicates in Excel

· Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....

Collapse or expand rows or columns in a sheet

We can group the rows or columns to collapse or expand parts of the details. The following screenshots compare a worksheet before and after grouping data.Before grouping data Group data to collapse or expand columns Here are the steps to group the data.1. Select the rows or columns to be grouped.2. Go to the Data tab → click Group.Steps to group data You can also further group the data following the previous steps. Here is an example to further group the data. Further group the data T....

How to sort data in a worksheet

1. Select the cell range filled with data to be sorted.2. Click Data → Sort → choose a sorting method (Ascending or Descending) When choosing Descending, the data would be sorted from the maximum to the minimum values (or Z to A for text). When choosing Ascending, the from the minimum to the maximum values (or A to Z for text). Note:When you see the Sort Warning pop-up dialog, you can choose one of the two options for array to be sorted.lIf you choose 'Continue with the current ....

How to create a dropdown list in WPS Spreadsheets

When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....