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:
-
- Can 9E307 still be used like this in Excel?
- This article brings you relevant knowledge about excel, which mainly introduces the usage of 9E307 in Excel. The complete expression of 9E307 is "9E+307". In Excel, it belongs to scientific notation, which means "9 *10^307", let’s take a look at it, I hope it will be helpful to everyone.
- excel 3681 2022-05-31 11:22:56
-
- Practical Excel skills sharing: How to make bar charts more vivid!
- In the previous article "Practical Excel Tips Sharing: Automatic Grouping and Numbering of 16,000 Rows of Data", we learned about the method to quickly achieve automatic grouping and numbering of 16,000 rows of data in 3 seconds. Today we are going to talk about Excel charts and see how to make bar charts more vivid. Come and learn!
- excel 3558 2022-05-31 10:56:29
-
- How to protect Excel cell formulas
- This article brings you relevant knowledge about Excel, which mainly introduces issues related to formula protection. Sometimes in a table, we just want the other party to see the number, and we don’t want them to know where the number came from. , let’s take a look at it, I hope it will be helpful to everyone.
- excel 4836 2022-05-30 11:32:58
-
- Practical Excel skills sharing: 16,000 rows of data are automatically grouped and numbered
- In the previous article "Practical Excel Tips Sharing: How to Ignore Hidden Columns for Sum?" 》, we learned about the method of summing ignoring hidden columns. Today we are going to talk about data grouping and numbering, and introduce how to quickly realize automatic grouping and numbering of 16,000 rows of data in 3 seconds. Come and learn!
- excel 4253 2022-05-30 11:03:50
-
- Three methods to remove excess spaces in Excel
- This article brings you relevant knowledge about Excel. It mainly introduces related issues about clearing redundant spaces, including splitting, pq and table methods to clear redundant tables. Let’s take a look at it together. I hope it will be helpful to everyone. help.
- excel 32052 2022-05-27 11:32:58
-
- Practical Excel skills sharing: How to ignore hidden columns and perform sums?
- In the previous article "Sharing Practical Excel Skills: Using "Conditional Formatting" and "Function Formula" Together", we learned how to use "conditional formatting" and "function formula" together through 2 examples. Today we will talk about data summation and introduce the method of summing by ignoring hidden columns. Come and learn!
- excel 11022 2022-05-27 10:42:15
-
- Excel data query INDEX and MATCH functions
- This article brings you relevant knowledge about Excel, mainly introducing the INDEX function and MATCH function. The combination of these two functions can complete all the search functions of the VLOOKUP function and HLOOKUP function, and can realize queries in any direction and multiple functions. Conditional query, etc. I hope it will be helpful to everyone.
- excel 9073 2022-05-26 10:59:08
-
- Practical Excel skills sharing: Use 'conditional formatting' and 'function formula' together
- In the previous article "Practical Excel Skills Sharing: "Data Validity" can be used in this way! 》, we learned 3 tips to make data effectiveness more efficient. Today we will talk about conditional formatting with function formulas. Through two examples, we will introduce how "conditional formatting" and "function formulas" are used together. Come and learn!
- excel 9503 2022-05-26 10:33:47
-
- Let's talk about Excel reverse query problem
- This article brings you relevant knowledge about Excel. It mainly introduces the related issues about reverse query, that is, the keywords are on the right side of the data table, and the content to be obtained is on the left side of the data table. Let’s take a look at it together. I hope it helps everyone.
- excel 2841 2022-05-25 12:03:14
-
- Practical Excel skills sharing: 'Data Validity' can be used in this way!
- In the previous article "Practical Excel Skills Sharing: How to Extract Numbers?" 》, we explain several common types of data extraction situations. Today we are going to talk about Excel’s “data validity” function and share 3 tips to make data validity more efficient. Come and learn!
- excel 7553 2022-05-25 10:44:57
-
- Detailed explanation of Excel examples to achieve multi-interval judgment
- This article brings you relevant knowledge about Excel, which mainly introduces issues related to multi-interval judgment. Everyone must have encountered the problem of multi-interval judgment, such as performance evaluation, performance appraisal, etc. The following is a Let's take a look at how to implement it. I hope it will be helpful to everyone.
- excel 5321 2022-05-24 11:59:41
-
- The omnipotent SUMPRODUCT for learning Excel functions!
- In the previous article "The amazing AGGREGATE of Excel function learning, one can actually be worth 19! 》, we learned about a powerful statistical function. Today we are going to talk about the SUMPRODUCT function. The SUMPRODUCT function with * is omnipotent!
- excel 4902 2022-05-24 11:49:44
-
- How to implement dynamic charts in Excel (detailed example)
- This article brings you relevant knowledge about Excel. It mainly introduces issues related to dynamic charts, including inserting column charts, modifying chart data sources, creating dynamic titles, etc. Let’s take a look at them together. I hope everyone has to help.
- excel 7240 2022-05-23 11:44:30
-
- Practical Excel skills sharing: How to extract numbers?
- In the previous article "Sharing Practical Excel Tips: 7 Ways to Improve Table Viewing Efficiency", we learned about 7 tips to improve table viewing efficiency. Today we will talk about extracting numbers in Excel and introduce several common extraction situations to explain. Come and learn!
- excel 31617 2022-05-23 10:42:22
-
- Master the skills of dynamically merging worksheets in Excel in one article
- This article brings you relevant knowledge about Excel. It mainly introduces the skills of dynamically merging worksheets and how to merge data in different worksheets. Let’s take a look at it together. I hope it will be helpful to you.
- excel 3054 2022-05-20 11:32:50