Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
      • Home
      • Popular
      • get rid of duplicates in excel 2007

      164 results for get rid of duplicates in excel 2007

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

      164 results for get rid of duplicates in excel 2007

      Clear and avoid duplicates entries in WPS Spreadsheet

      Clear and avoid duplicates entries in WPS Spreadsheet

      01:56

      Clear and avoid duplicates entries in WPS Spreadsheet

      When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....

      Spreadsheet 2,732 views
      More features in Remove Duplicates

      More features in Remove Duplicates

      03:14

      More features in Remove Duplicates

      To remove the duplicate data when dealing with tabular data, we can use the function of Remove Duplicates. In Microsoft, we can select the needed cell range and click the Remove Duplicates button in the Data tab to remove them. In WPS Spreadsheets, in addition to removing duplicates, we can also mark them for further review and collation.1. Click the Data tab, click the Highlight Duplicates drop-down button, and select Set. 2. Then select the cell range that needs to be marked and clic....

      Spreadsheet 86 views
      The SUMPRODUCT function for quick calculation of total sales

      The SUMPRODUCT function for quick calculation of total sales

      01:44

      The SUMPRODUCT function for quick calculation of total sales

      When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

      Spreadsheet 714 views
      Track changes

      Track changes

      01:30

      Track changes

      Excel worksheets are frequently used for teamwork. We want to record and track the modifications made by each member. Today, we will learn how to use the "Track Changes" function.Take this table as an example, we want to get the revision history of the data.First, go to the "Review" tab, and click "Highlight changes" at "Track Changes."Then, check "Track Changes While Editing" to track the changes in your sheet. By doing so, you can highlight the changes including time, reviser, and r....

      Spreadsheet 12 views
      SUBTOTAL function: Calculate the data with the hidden value

      SUBTOTAL function: Calculate the data with the hidden value

      02:33

      SUBTOTAL function: Calculate the data with the hidden value

      Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

      Spreadsheet 1,546 views
      Edit settings in WPS Spreadsheet

      Edit settings in WPS Spreadsheet

      03:47

      Edit settings in WPS Spreadsheet

      WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

      Spreadsheet 257 views

      Clear and Avoid Duplicates Entries in WPS Spreadsheet

      When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some two options to delete duplicates. · Option 1: 1. Select a range of cells. 2. Get into the Data tab → click the Highlight Duplicates dropdown button3. Pick the Set option from the drop-down list. Then, duplicated cells within the selected range will be highlighted.4. Right-click to select the fifth row → choose Delete in the popup menu· Option 2: 1. Se....

      Spreadsheet 2,546 views
      How to filter data horizontally

      How to filter data horizontally

      01:34

      How to filter data horizontally

      The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....

      Spreadsheet 19 views
      Prev 123...2021 Next
      WPS Academy