17 results for free excel 2007 product key
- All Tutorials
- Video Tutorials
- Quick Tutorials
Elementary arithmetic functions in WPS Spreadsheet02:50
Elementary arithmetic functions in WPS Spreadsheet
Today I will introduce you to introductory calculation of functions, namely addition, subtraction, multiplication and division. In the table, there are three ways to enter the function, respectively, input in the formula bar input in the cell and click Insert Function. So how can we do elementary arithmetic in the table? We can enter the corresponding symbol for the operation in the formula bar or cells. Take this table as an example, we enter "= A2 + B2" in cell C2, press the Enter ke....
More features in AutoFilter02:39
More features in AutoFilter
When dealing with large amounts of table data, we often need to temporarily hide some of them with AutoFilter to focus on those we need. Here we will compare the AutoFilter function of WPS Spreadsheets and Microsoft Excel. In general, both of them support filtering data according to numbers, text, color and so on.WPS Spreadsheets has three special advantages. Let's go through them one by one.First, Click the Home tab, and click the AutoFilter drop-down button to turn on the AutoFil....
How to filter data horizontally01: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....
How to use the Selection Pane in WPS Spreadsheet01:49
How to use the Selection Pane in WPS Spreadsheet
How can we select and edit multiple pictures, texts, and other objects in excel? Today, we will learn some tricks about the Selection Pane.Take this table as an example. You may open the Selection Pane using the methods listed below.The first method is to select Selection Pane from the Find and Replace drop-down menu in the Home tab. The second approach is to go to the Page Layout tab and look for Selection Pane. Or, you can go to the right-hand navigation bar and look for Selection Pa....
How to create a revenue model in WPS Office Excel
You are visiting WPS Academy for free tutorials. In this article, you will know how to create a revenue model in excel with simple steps as follows: · Choose a revenue model in WPS Templates1. Go to the homepage of WPS Office > Apps > Templates. 2. Input “revenue” in the search box in the upper right corner, and press the Enter key.3. You are provided with diverse revenue models, and you can use any of them with one click. Note that Template Premium users can enjoy all the templates f....
How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
In the following example, Sheet1 ‘Client Order List’ records the equipment types ordered by corresponding client company names, while Sheet2 ‘Price List’ lists Sequence No. and Price for each type of equipment. Now we want to fill in Column D ‘Price’ for each company, using the VLOOKUP function with data in Sheet2.Sheet1: Client Order List Sheet2: Price List · Option 1:1. Input =VLOOKUP(B2,'Price List'!$A$1:$C$11,3,FALSE) in cell C2 of Sheet1 ‘Client Order List’. 2. Select cell....
How to convert PPT to PDF online for free in WPS Office
WPS Academy is here to provide you with a free tutorial of how to convert PPT to PDF online for free in WPS Office. · Steps to convert PPT to PDF online for free in WPS Office.1. Open your PPT in WPS Office.2. Navigate to the Tools tab, and click Export to PDF. In the Export to PDF dialog:1. Select the PPT file to convert.2. Input the pages to convert at Export range.3. Set the position to save the exported PDF file at Save Path.4. Choose the Export Type between Common PDF and Image PD....
How to capitalize letters in WPS Office Word
When editing a word document, we often need to capitalize the letters of some specific words like abbreviations, proper nouns, etc.It's quite simple to capitalize letters in WPS Office Word. Now let's begin!lSteps to capitalize letters in WPS Office Word1. Open the document in WPS Writer.2. Select the letter to be capitalized.（Tips: Press the Ctrl key to select multiple letters separately.) In the Home tab, click the Change Case button. And check Uppercase or Togglecase.3. You ....