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：
-
- Excel chart learning: bar chart comparing actual and target
- Speaking of charts, the images that pop up in everyone's mind should be the styles that come with Excel. Not to mention they are not good-looking, and these built-in templates cannot display data intuitively. It is obviously inappropriate to hand such charts to leaders. of. The following article will share with you an Excel stacked column chart tutorial to teach you how to make different contrasting column charts, which will amaze everyone when making work reports.
- excel 5513 2022-11-08 19:55:53
-
- Excel case sharing: How to use Excel to create an electronic inventory ledger? (Summary of inbound and outbound ledgers)
- Many warehouse managers have to summarize inventory ledger balances every month. If they don’t know how to design inventory ledger forms, they have to work overtime every day. In fact, using three functions in Excel, you can design a warehouse entry and exit ledger template in a few seconds. Solve the problem! Today, this article will share with you an article on how to use Excel to create an electronic inventory ledger. The author's explanation is from simple to deep, which is very helpful for beginners to learn. Come and take a look!
- excel 10140 2022-11-07 19:44:50
-
- Excel function learning: Let's talk about how to use countif() (detailed case explanation)
- In the previous article "How to quickly count working days by learning Excel functions, take a look at these two functions! 》, we learned two working day functions. Today we are going to learn countif() and share 5 cases of countif function checking for duplicates. Come and take a look!
- excel 2870 2022-11-03 20:39:14
-
- Example parsing Excel: Split names mixed in the same cell into one column
- This article brings you relevant knowledge about Excel, which mainly introduces the relevant content on how to split the names mixed in the same cell into one column. Let's take a look at it together. I hope it will be helpful to you.
- excel 3445 2022-11-02 17:44:52
-
- Practical Excel skills sharing: How to divide a column into multiple rows and columns
- In the previous article "Sharing Practical Excel Skills: Search, Positioning Functions, and Entry Techniques", we learned the search, positioning functions, and entry techniques in the table. Today we are going to talk about the practical skills of dividing a column into multiple rows and columns in Excel. Let’s take a look!
- excel 20002 2022-11-02 13:36:04
-
- Practical Excel skills sharing: search, positioning functions, entry skills
- In the previous article "Sharing practical Excel skills: Four methods for summing across worksheets", we learned four methods for summing across worksheets. Today we are going to talk about 3 commonly used skills in excel tables: search, positioning functions, and entry skills. Come and collect them now!
- excel 6005 2022-10-04 07:00:28
-
- Excel case sharing: Use Powerquery to merge multiple sheets with one click
- After sharing the Power Query merge worksheet with you last time, many friends left messages asking what should be done if the worksheet is increased or decreased? Today I will introduce to you how to use Power Query to merge workbooks, so that no matter the worksheet changes or data changes in the workbook, you can refresh the summary with one click. Come and learn now!
- excel 9846 2022-09-19 11:06:37
-
- Excel Case Sharing: Using Power Query to Merge Multiple Tables
- In the previous article "Practical Excel Tips Sharing: Four Methods for Summing across Worksheets", we learned four methods for summing across worksheets. Today we are going to get to know the Power Query plug-in in excel. It turns out that summarizing worksheets is so convenient and fast!
- excel 9087 2022-09-16 10:07:41
-
- Excel chart learning: Excel bullet chart that reflects the difference between actual and target
- In the previous article "Excel Chart Learning: How to Use Controls to Make Bar Charts", we learned how to use controls to make bar charts. Today we continue to share the tutorial on how to make Excel charts. The whole graph is like a bullet, so it is called a bullet chart. If you use this bullet chart to make a performance report, you will wonder whether you will get a promotion or a salary increase! The operation is also very simple, let’s learn how to make an Excel bullet chart together!
- excel 4270 2022-09-15 13:02:04
-
- Practical Excel skills sharing: Four methods for summing across worksheets
- In the previous article "Excel Case Sharing: Using Function Formulas to Verify the Authenticity of the ID Number", we learned about the Excel function formula to verify the authenticity of the ID number. Today we will talk about summing across worksheets in Excel and introduce to you 4 methods. For different tables, you can quickly merge data across worksheets in Excel, faster than you can imagine!
- excel 93692 2022-09-14 10:29:19
-
- How to merge data into one cell in Excel
- This article brings you relevant knowledge about Excel, which mainly introduces the related issues of merging multiple data into one cell. There are always some special needs at work, and the most troublesome ones are Put all the multiple results that meet the conditions into one cell. Let's take a look at them together. I hope it will be helpful to everyone.
- excel 8722 2022-09-13 17:57:24
-
- Excel case sharing: Use function formulas to check the authenticity of ID numbers
- In the previous article "Excel case sharing: 5 efficient techniques that can be realized by just "drag and drop"", we learned 5 efficient techniques that can be realized by "drag and drop" in Excel tables. Today we are going to talk about Excel’s function formula for checking the authenticity of ID card numbers, come and take a look!
- excel 12632 2022-09-13 10:15:53
-
- Excel case sharing: 5 efficient techniques that can be achieved by just 'drag and drag'
- In the previous article "Excel Case Sharing: Calculation Methods for Year-on-Year Growth Rate and Month-on-Month Growth in Each Year", we learned the calculation methods for year-on-year growth rate and month-on-month growth in each year. Today we are going to talk about 5 commonly used skills in Excel tables. Unexpectedly, the problem that has troubled me for a long time can be solved with just drag and drop shortcut keys. To be honest, you think function charts are too difficult to learn, but today you must learn these few tips to solve problems by just dragging with the mouse!
- excel 4000 2022-09-06 10:19:17
-
- Excel case sharing: Calculation methods of year-on-year growth rate and month-on-month growth in each year
- How to calculate year-on-year growth rate in Excel? How to calculate the month-on-month growth of Excel? The following article will introduce the Excel calculation method of year-on-year growth rate for each year. This is a method used by every company for data analysis.
- excel 12543 2022-09-05 10:22:43
-
- Excel chart learning: how to use controls to create bar charts
- In the previous article "Excel chart learning: How to make the chart move like a web page", we learned how to make the Excel chart move like a web page. Today we continue to share the tutorial on how to make Excel dynamic charts. There are even check boxes to select the data that need to be displayed! If anyone uses this chart to give a work report, I guarantee that the boss will look at you twice. Are you sure you don’t want to learn such a high-level and easy-to-learn dynamic chart?
- excel 2982 2022-09-02 10:52:33
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
