current location:Home > Technical Articles > Topics > excel

  • Can 9E307 still be used like this in Excel?
    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!
    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
    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
    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
    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?
    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
    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
    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
    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!
    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
    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!
    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)
    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?
    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
    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

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.

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