636 results for
**use of excel formulas with example**

- All Tutorials
- Video Tutorials
- Quick Tutorials

- All
- Spreadsheet
- Presentation
- Writer

#### Use COUNT function to count the number of cells with parameters

01:20### Use COUNT function to count the number of cells with parameters

When we do data statistics, we can use the COUNT function to count the number of cells containing values. Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number....

### How to use LEFT and RIGHT formulas together in excel

Are you ready to master how to use LEFT and RIGHT formulas together in excel? After learning this WPS free course, you will be advanced from a beginner in WPS Spreadsheet. · What is WPS Spreadsheet? WPS Spreadsheet is compatible with Microsoft Office Excel. As the world's leading developer of office software solutions, WPS Office provides free applications for individuals and businesses to improve productivity. · What is the LEFT and RIGHT function in WPS Spreadsheet? They both all....

#### The Trace Precedents function

00:57### The Trace Precedents function

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....

#### More features in picture inserting

01:53### More features in picture inserting

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

#### How to use Name Manager

01:13### How to use Name Manager

We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

#### Formatting time in WPS Spreadsheet

01:08### Formatting time in WPS Spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

#### Why error message #VALUE! occurs and how to solve it

03:11### Why error message #VALUE! occurs and how to solve it

The errors in a function or formula will result in calculation errors, and it returns "#VALUE!". The common causes are as follows: incorrect function syntax, the reference cells containing text in the formulas, the reference cells containing a non-character string in the formulas, and the lack of braces in the formulas. Let's go through them one by one. · Incorrect function syntax.For example, we want to calculate the difference in computer sales between the first half of this year....

#### Add comments to explain the content.

01:52### Add comments to explain the content.

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. In WPS Spreadsheet, we can supplement the contents by adding comments, which can make it easier for others to understand what the contents means. Take the table as an example, select the cell or cell range to which comments need to be added, click the Review tab, and click the Edit Comment button. You can also use the shortcut key Shift+F2 and fill in t....