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: 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 4231 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 11207 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 11095 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 2390 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 2208 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 5192 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 1615 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 13381 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 9687 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 6526 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 10764 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 2348 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 2492 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 10478 2023-01-30 19:38:05
![[Organize and share] 10 sets of magical and practical Excel shortcut keys, even masters use them!](https://img.php.cn/upload/article/000/000/024/63d6418b0e753538.jpg?x-oss-process=image/resize,m_fill,h_100,w_220)
- [Organize and share] 10 sets of magical and practical Excel shortcut keys, even masters use them!
- Every Excel person has a dream of becoming a master, hoping that Excel can operate smoothly and all data work can be completed quickly. How to become a great god? Or how to get close to the great god? Let’s start with the shortcut key operations that all the masters like. Through these shortcut keys, you can improve the efficiency of daily work by at least 80%. The following article will share with you several sets of Excel shortcut keys that are also used by great experts. Come and learn to use them to quickly improve your work efficiency and never work overtime again!
- excel 1854 2023-01-29 20:29:18
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
