current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- What operators can be used to concatenate strings in excel?
- You can use the "&" operator in excel to concatenate strings. There are other operators in excel, such as: arithmetic operators (+, –, *, /, %, ^); comparison operators (=, >, <, >=, <=, <>); reference operators symbol(:,,).
- excel 19450 2020-07-03 09:53:58
-
- How to use the mmult function
- In excel, you can use the "MMULT()" function to return the matrix product of two arrays. This function is used to return the matrix product of two arrays. Its syntax is "MMULT(array1, array2)", and its parameters array1 and array2 are the Perform matrix multiplication of two arrays.
- excel 13126 2020-07-02 17:03:12
-
- What is the multiplication function in excel?
- The multiplication function in excel is PRODUCT. The PRODUCT function is used in the software excel to calculate the product of the given numbers. That is, it multiplies all the numbers given in the form of parameters and returns the product value.
- excel 38567 2020-07-02 14:26:33
-
- dcount function usage
- The formula of the Dcount function is [=Dcount(database,field,criteria)]. Its function is to return the number of cells in the data column that meet the specified conditions and contain numbers. The parameter database represents the cell range.
- excel 12050 2020-07-02 14:15:27
-
- How to align characters and numerical data in cells by default
- By default, the character data in the cell is left-aligned and the numerical data is right-aligned. The viewing method is: first enter a set of text content in the excel table; then enter the numerical data in the blank cell; and finally click Enter. You can see the default alignment.
- excel 17602 2020-07-02 11:42:15
-
- How to divide a column by a fixed value in excel?
- Method: First open the excel table, enter the equal sign in column C, then click A1 with the mouse (column A is the data column), then enter the division sign "/", then enter the divisor after the division sign, press the enter key to get the result, and finally Just drag down the mouse to complete the division of all values.
- excel 51966 2020-07-01 14:50:37
-
- How to put the official seal at the bottom in Excel?
- Method: 1. Open the excel table and drag the electronic chapter into the position where the text needs to be covered; 2. Left-click the electronic chapter, click "Graphics Tools" and click "Set Transparent Color"; 3. Click the electronic chapter to change the electronic chapter to After making it transparent, just adjust the position.
- excel 43664 2020-07-01 10:39:38
-
- How to insert a pivot table in excel
- The method to insert a pivot table in Excel is: 1. Set the data source, ensure that the field names are not empty, and the data format remains consistent in the same column; 2. Click the [Insert] option in the upper toolbar, and then click [Pivot Table] ]; 3. Set the data source and placement location of the pivot table.
- excel 13957 2020-07-01 10:04:04
-
- What is the reason why excel runs slowly?
- The reasons are: 1. There may be many small objects in the file that need to be deleted; 2. The slider is very small, and you can reach a very large line number by dragging it downward; 3. The file contains a large number of complex formulas; 4. Use Large pictures are used as work background; 5. Shared workbooks cause an inflated increase in size.
- excel 17460 2020-07-01 09:29:18
-
- How to compare and filter out the same data from two tables?
- Method: 1. Open two excel tables and select a cell range with more data; 2. Click the "Advanced" button in the "Data" tab; 3. Automatically identify the selected cells in the "List Area" of the pop-up window. Cell range, set the "condition range" to the corresponding cell range in another table, and click "OK".
- excel 105176 2020-06-30 17:04:11
-
- How to set excel to display red when greater than 0?
- Method: 1. Open the excel table and select the data that needs to be operated; 2. Click "Conditional Formatting" in the menu bar, and then click "Greater than (G)" in "Highlight Cell Rules"; 3. Select greater than "0 ", "Custom Format" is filled in red, click "OK".
- excel 47276 2020-06-30 13:59:40
-
- How to solve the problem of discontinuous serial numbers on the left side of Excel?
- Solution: 1. Open the excel table and enter continuous serial numbers below the non-consecutive serial number cells in column A; 2. Select column A, click "Data", click "Delete Duplicates", and click "OK"; 3. Select For data in column A, click "Sort" in "Data" and select "Ascending".
- excel 27459 2020-06-30 10:52:54
-
- How to solve the problem that Excel reading mode cannot be found?
- Solution: 1. Open the excel file and click "View" in the menu bar; 2. Click the "Reading Mode" button in the view menu; 3. There is a shortcut button for reading mode in the lower right corner of the table, click this You can also enter reading mode.
- excel 77957 2020-06-30 10:38:29
-
- What is the shortcut key to generate a chart in Excel with one click?
- The shortcut key to create a chart in Excel with one click is F11. There are other shortcut keys in Excel, such as F1 (displays the "Help" task pane); Ctrl+F1 (closes and reopens the current task pane); F5 (displays the "Location" dialog box); F8 (opens or closes extended mode).
- excel 51550 2020-06-30 10:29:46
-
- What should I do if the sub-tables below the Excel table are missing?
- Solution: 1. Open the excel table and click the "File" button; 2. Click "View" in "Options"; 3. Check "Sheet Label" in the pop-up window and click "OK" below.
- excel 61138 2020-06-28 16:04:56
Tool Recommendations
jQuery enterprise message form contact code
jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29
HTML5 MP3 music box playback effects
HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.
Player special effects
2024-02-29
HTML5 cool particle animation navigation menu special effects
HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29
jQuery visual form drag and drop editing code
jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29
Organic fruit and vegetable supplier web template Bootstrap5
An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03
Bootstrap3 multifunctional data information background management responsive web page template-Novus
Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02
Real estate resource service platform web page template Bootstrap5
Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02
Simple resume information web template Bootstrap4
Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02
Cute summer elements vector material (EPS PNG)
This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09
Four red 2023 graduation badges vector material (AI EPS PNG)
This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29
Singing bird and cart filled with flowers design spring banner vector material (AI EPS)
This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29
Golden graduation cap vector material (EPS PNG)
This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27
Home Decor Cleaning and Repair Service Company Website Template
Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09
Fresh color personal resume guide page template
Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29
Designer Creative Job Resume Web Template
Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
Modern engineering construction company website template
The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28
