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: 8 typical forms and problems of table headers
- Are you embarrassed by the header when making or printing tables? Although the header is very simple, many people waste a lot of time on the header because of different style needs and different printing needs. This article summarizes the typical forms and problems of 8 types of headers, so that you will no longer waste time on headers.
- excel 6704 2023-02-17 18:19:12
-
- Practical Excel skills sharing: various ways to play format brush!
- Format Painter is very simple. With one click, you can copy the format to other cells, graphics, and text. But the usage of Format Painter is not just that. It can also quickly fill alternate rows with color, hide alternate rows, and achieve "lossless" merging of cells, etc. Today let’s take a look at various ways to play with excel format brushing!
- excel 4472 2023-02-17 14:01:42
-
- Practical Excel skills sharing: data comparison in several different situations
- From time to time, daily work requires comparing data, finding differences, finding duplicate values, etc. Some compare data in the same worksheet, and some compare data between different worksheets. Here we summarize the data comparison in 12 different situations, and provide quick methods so that everyone can quickly complete the data comparison under different situations.
- excel 11602 2023-02-15 14:53:34
-
- Practical Excel skills sharing: How to extract data by keywords
- How to extract data in Excel? The following article will share with you a common data extraction technique: extracting data by keywords. I hope it will be helpful to you!
- excel 11321 2023-02-14 19:11:28
-
- Practical Word skills sharing: Flexible use of text boxes (2)
- Anyone who has used Word knows a truth: it is easy to write articles in Word, but it is very difficult to type them in Word. Especially some long documents often collapse due to some layout problems. For example, pictures and text are often not positioned in the right place, making it difficult to achieve the desired special layout effect.
- excel 2628 2023-02-14 19:08:06
-
- Excel chart learning: using whirlwind charts for data comparison
- You have to throw away when comparing goods, and you have to die when comparing people to others - you can see the power of comparison! Therefore, who doesn’t want to make the data more intuitive and convincing through comparison. Then don’t miss this whirlwind chart tutorial that specializes in data comparison, otherwise you will be despised by your boss and colleagues for not being able to express data comparison.
- excel 2438 2023-02-13 19:19:39
-
- Excel cross-table extraction, Microsoft Query KO all functions
- When extracting data across tables, the first reaction of many partners is functions such as VLOOKUP, or the INDEX+SMALL+IF formula. In fact, if you are extracting multiple columns of data, Microsoft Query, which has been left in the corner by many people for a long time, is the king! Not only is it easy to operate and easily solve "one-to-many" problems, but the result table it generates can form a dynamic link with the data source. If the data source changes, the results will be dynamically updated!
- excel 5419 2023-02-10 19:23:39
-
- Excel chart learning eclectic OFFSET dynamic table
- It’s the beginning of winter and it’s cold! No heating in the house? Just move, stamp your feet, rub your hands, and you will feel warm. It’s the beginning of winter, and another year is coming to an end! No salary increase yet? Let your watch move differently than before, update simultaneously, and display dynamically. Not only will it save you trouble, but your boss will also like to issue "salary"...
- excel 1864 2023-02-09 19:55:08
-
- Practical Excel skills sharing: 13 date input methods, how many of them do you know!
- Entering a single date is easy, but what about hundreds or thousands of date data? If you only know the most basic manual income, or you can also use ctrl+;, it will be really difficult to complete the entry work quickly. In fact, there are 13 methods for date entry, and different methods are suitable for different entry needs. Some are suitable for entering today's date, some are suitable for inputting multiple non-consecutive dates, and some are suitable for automatically recording dates. Only by understanding these methods can you find the fastest and most applicable date entry method according to your needs.
- excel 13715 2023-02-07 17:45:14
-
- Excel chart learning: making a combination of line chart and column chart
- How to create a combined line chart and column chart? The following article will take you to talk about how to make a combination chart of line chart and column chart. I hope it will be helpful to everyone!
- excel 10154 2023-02-06 20:02:12
-
- Excel table collaboration: share workbooks and create a table with colleagues!
- How to quickly create a table with colleagues? This article will share with you the correct way to open a table with colleagues: share an Excel worksheet. Through sharing, let 1~N colleagues help with different parts of the same form at the same time. In this case, the most you can do is have a meal after get off work, so why do you often work overtime?
- excel 6825 2023-02-03 17:56:40
-
- Tips for learning Excel functions: Use the COUNTIFS function to complete unique number statistics in 1 minute
- Counting duplicates and counting non-duplications are tasks that Excel people often encounter. The functions COUNTIFS (multi-condition counting function) and COUNTIF (single-condition counting function) are wonderful. They were originally used to count the number of repetitions, but through changes, they can also be used to count the number of unique ones (removing duplicate counting). For example, what are the repeated fruits below? How many fruits are there in total? If you can't answer within 5 seconds, just buy some fruit and love yourself and watch the tutorial!
- excel 11214 2023-02-02 20:00:42
-
- Practical Excel skills sharing: 7 practical positioning skills to help you improve work efficiency
- The positioning function in Excel is very powerful, but many newcomers in the workplace can only locate blank spaces. In fact, it also has many very useful functions. Today I will share with you 7 Excel positioning skills.
- excel 2593 2023-02-01 19:49:28
-
- Practical Excel skills sharing: two wonderful ways to find and replace
- This article will share with you two wonderful ways to find and replace in Excel. Today you will learn two techniques for summing data by color and identifying qualified data with one click. I hope it will be helpful to you!
- excel 2671 2023-01-31 20:11:07
-
- Practical Excel skills sharing: two ways to quickly split a worksheet
- If the worksheet is summarized, it will be split. How to quickly split a worksheet? In this article, we share two methods for quickly splitting worksheets that increase efficiency by 99.99%. I hope it will be helpful to everyone!
- excel 10785 2023-01-30 19:38:05