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：
-
- Practical Excel skills sharing: the use of double-layer pie charts
- Hello everyone! When it comes to making column charts, bar charts, and pie charts, I believe everyone has no problem. Just select the data and insert the corresponding chart. But if you want to make a two-layer pie chart, would you still do it? "What? There is also a double-layered pie chart?" Hey, I don't know. Compared with ordinary pie charts, a double-layered pie chart has a clearer structure and can display a variety of data more intuitively. Hurry up and follow the editor to take a look~
- excel 2610 2023-04-17 18:13:29
-
- Practical Excel skills sharing: formula routines for ranking according to conditions
- When it comes to ranking data in excel, the first thing that comes to mind is the rank function, but what if you want to rank data according to conditions? Friends, are you confused all of a sudden? It seems that you have not heard of the function of ranking according to conditions. So today I will share with you a formula for ranking according to conditions in Excel. Let’s take a look!
- excel 4301 2023-04-14 14:58:30
-
- Practical Excel skills sharing: One chart to handle data comparison, trend and proportional contribution
- Hello everyone! Recently, a classmate in the excel learning group complained about their leader in the group, saying that the leader asked him to display three different projects in one picture, including the data values and trends in 12 months, and also to show various aspects. The proportion of projects in the total data of all projects in this month! After hearing the demand, this classmate's mentality collapsed and he thought, "Boss, how about you give it a try?" Today we will make this excel chart based on the needs of this strange leader!
- excel 8060 2023-04-13 17:27:45
-
- Practical Excel skills sharing: 5 small steps to help you create a high-quality line chart
- Line charts are a very common way of displaying data in our daily data visualization, and I think everyone is already familiar with it. Line charts are very simple and everyone can make them, but the line charts produced by different people vary widely. Most people's line charts are generated by directly inserting the default line chart style. Regardless of whether they have made such a line chart carefully, the boss is tired of looking at it just because of this style. Today, this article will teach you how to make a high-quality line chart. Let’s take a look!
- excel 6798 2023-04-12 17:43:29
-
- Excel function learning: Use summation function to calculate complex product costs
- Hello everyone! Recently, a friend was stumped by a problem of calculating product cost. The requirement was to calculate the cost of the finished product based on the cost of accessories. This problem seems a bit complicated, and I feel like I can't think of a good solution at once. In fact, it is very simple, and you can easily solve the problem using only a common summation function. Without further ado, let's take a look. Bar!
- excel 2311 2023-04-11 18:48:11
-
- Excel function learning: Let's talk about the king of dynamic statistics OFFSET()
- Hello everyone! Today is the 6th lesson of Tribe's Function Class. We will get to know the OFFSET function, nicknamed the "King of Dynamic Statistics"! The OFFSET function is a very practical function. It plays an irreplaceable role in drop-down menus, dynamic charts, dynamic references and other operations. It is no exaggeration to say that a considerable part of the efficiency of Excel tables comes from OFFSET. Let’s get to know it with the editor today! (Due to the length of the tutorial, it will be divided into two parts. This is the first part.)
- excel 2937 2023-04-10 19:02:56
-
- Practical Excel skills sharing: Two magical skills will help you see the secret of counting unique numbers!
- How to count the number of unique data? I guess many friends have read a lot of similar articles, but most of them give formulas and explain them a little. At the time, they understood it, but when they encountered problems, they were confused again. In the final analysis, they still didn’t understand the formula. principle. In fact, understanding the principle of this formula is not as difficult as everyone imagines. As long as you know these two magical skills, you can crack the secret of the formula.
- excel 2846 2023-04-07 20:12:42
-
- Practical Excel skills sharing: Let's talk about the three major methods of interval query!
- The problem of interval value selection is often encountered in our daily work, such as: sales commission, grade assessment, production standard assessment, performance appraisal, etc., all belong to this type of problem. Today I will introduce to you several commonly used methods. , aiming to enrich everyone's knowledge and at the same time broaden their horizons on the application of functions.
- excel 2170 2023-04-06 18:24:37
-
- Practical Excel skills sharing: 10 most commonly used formulas among professionals
- This article has compiled 10 of the most commonly used excel formulas for professionals. I hope it can help you solve your problems. Come and take a look!
- excel 3471 2023-04-04 19:23:39
-
- Practical Excel skills sharing: How to create two-level and three-level drop-down menus
- When it comes to making drop-down menus, everyone knows that it can be achieved by directly using data verification in Excel, but drop-down menus with two, three, or even more levels may be a bit confusing. In fact, it is not difficult at all to use Excel to create a three-level drop-down menu. It is as simple as copying and pasting! Do not believe? Let’s read the article together and you will know!
- excel 5350 2023-04-02 07:30:03
-
- Practical Excel skills sharing: Explore the 'little secrets' hidden in automatic sorting
- It is said that there are hidden secrets in Excel. The MAX function that finds the maximum value can be used for searching, and the LOOKUP function used for searching can round the data... Even Excel's automatic sorting, which everyone seems to know, hides many things that we don't know. "little secret". Today we will explore these "little secrets" hidden in automatic sorting.
- excel 2294 2023-04-03 16:48:21
-
- Excel function learning: the dark horse in the query world - MAX()!
- Isn’t MAX a function that finds the maximum value? When did you become the “dark horse in the query world”? Did VLOOKUP even feel defeated? The following article will give you an in-depth understanding of MAX's query function. I hope it will be helpful to you!
- excel 1990 2023-03-31 15:16:05
-
- Practical Excel Tips Sharing: How to Ignore Error Values for Sum
- "What should I do to sum data that contains wrong values? If I sum it directly, the result will also be an wrong value. What should I do?" Don't worry, today this article will share with you three formulas. Just ignore the method of summing error values and take a look!
- excel 3346 2023-03-29 17:44:57
-
- Excel function learning is one against ten SUBTOTAL functions!
- Friends who are just getting started always like to complain, "Excel has too many functions and I can't always remember them. Is there a function that can summarize the functions of many functions?" To be honest, there is! The biggest function of the function we are going to talk about today is that it can replace 11 functions. In addition, it can also change the final calculation result based on different filtering results! How about it? Doesn’t it just sound awesome? Without further ado, let’s take a look with the editor!
- excel 1677 2023-03-28 18:56:24
-
- What should I do if the keyboard arrow keys cannot move cells?
- Solution to the problem that the keyboard arrow keys cannot move cells: 1. Open a spreadsheet and check whether the cell is selected; 2. Find and press the "Scroll Lock" key on the keyboard or "SCR LK" is displayed , "scroll lock" key; 3. Re-enter excel to make the cells move with the keyboard arrow keys.
- excel 30036 2023-03-28 14:12:36
Recommended Articles
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
