Page 93-Topics-php.cn

Article Tags

Topics

Home

Technical articles

Topics

How to find combinations whose sum is a certain value in Excel

This article brings you relevant knowledge about Excel, which mainly introduces the problem of how to use functions to find combinations that sum to a certain value. Let’s take a look at it together. I hope it will be helpful to everyone.

May 18, 2022 am 11:25 AM

Excel

Practical Excel skills sharing: How to sum data with units?

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 data processing. It turns out that numbers plus units can be summed. Take a look, you must not know this method!

May 18, 2022 am 10:40 AM

Excel

Sharing practical Word skills: cleverly use 'Find and Replace” + 'Wildcard” to extract data

In the previous article "Sharing Practical Word Tips: Cleverly Using "Wildcards" to Batch Insert Tables", we learned how to use Word wildcards to batch insert tables. Today we will continue to share practical Word skills. Let’s talk about how to use “Find and Replace” + “Wildcard” to extract data. Learn it quickly!

May 18, 2022 am 10:19 AM

Word

How to use a mobile phone to create an Excel spreadsheet in an emergency without a computer?

In daily life, people often go out and suddenly need to make an Excel spreadsheet. However, we cannot carry the computer on our back all the time. At this time, we only have a mobile phone when we are injured. So how do we use the mobile phone to make a spreadsheet? ?

May 17, 2022 pm 07:22 PM

Excel

Example summary of eight uses of the AGGREGATE function in Excel

This article brings you relevant knowledge about excel, which mainly introduces the relevant content about the AGGREGATE function. The usage of this function is similar to the SUBTOTAL function, but it is more powerful in function than the SUBTOTAL function. Let's take a look at it together. I hope Helpful to everyone.

May 17, 2022 am 11:37 AM

Excel

Learn the amazing AGGREGATE function in Excel, one is worth 19!

In the previous article "Sharing practical Excel skills: Using "Find and Replace" to filter date data", we learned about several practical operations of "Find and Replace". Today we are going to talk about a magical Excel statistical function, which can actually be worth 19. It is simply an artifact! Collect it quickly.

May 17, 2022 am 10:35 AM

Excel

Practical Word Tips Sharing: Clever Use of 'Wildcards” to Batch Insert Tables

In the previous article "Sharing Practical Word Tips: Quickly Replace English Quotation Marks with Chinese Quotation Marks", we learned how to replace English direct quotation marks with Chinese quotation marks at once. Today we will continue to share practical Word skills, introducing an advanced use of Word wildcards, and how to insert tables in batches. Learn it quickly!

May 17, 2022 am 10:19 AM

Word

Detailed example of using Excel to create countdown cards

This article brings you relevant knowledge about excel. It mainly introduces the relevant content about zenmm making countdown cards. You can use the date function in Excel combined with the VBA code to refresh according to the specified time to create the countdown card. Below Let's take a look, I hope it will be helpful to everyone.

May 16, 2022 am 11:53 AM

Excel

Practical Excel skills sharing: Use 'Find and Replace' to filter date data

In the previous article "Sharing Practical Excel Skills: Cleverly Using Functions to Create an Automatic Statistics Invoicing, Sales and Inventory Table", we learned four functions and used them to create a statistics table that can automatically count inventory. Today we will share some practical operations of "find and replace". It turns out that you can use it to filter date data. Let's take a look.

May 16, 2022 am 10:47 AM

Excel

Practical Word tips to share: Quickly replace English quotation marks with Chinese quotation marks

In the previous article "Sharing Practical Word Tips: How to Quickly Find Document Differences", we learned how to quickly find document differences. Today we will continue to share practical Word skills. Let’s talk about how to replace English direct quotation marks with Chinese quotation marks at once. Learn it quickly!

May 16, 2022 am 10:26 AM

Word

Practical Excel skills sharing: cleverly use functions to create an automatic statistical purchase, sales and inventory table

In the previous article "Sharing Practical Excel Skills: Several Practical Operations of the "Column Sorting Tool"", we learned the practical operations of several sorting tools. Today we are going to learn four functions. Using them skillfully, we can create a "Purchase, Sales, Inventory and Inbound and Outbound Statistics Table" that can automatically count inventory. It is simply 666.

May 13, 2022 pm 02:58 PM

Excel

Practical Word Tips Sharing: How to Quickly Find Document Differences

In the previous article "Sharing Practical Word Tips: Using Mail Merge to Batch Print Conference Cards", we learned how to quickly batch produce printed conference cards. Today we will continue to share practical Word skills, let’s talk about how to quickly find differences in documents, learn it quickly!

May 13, 2022 pm 02:32 PM

Word

Teach you five ways to determine the day of the week in Excel

This article brings you relevant knowledge about Excel. It mainly introduces how to determine the day of the week today, including methods such as custom formats, text functions, WEEKDAY functions, etc. Let’s take a look at it together. I hope it will help Everyone is helpful.

May 13, 2022 am 11:44 AM

Excel

One article teaches you the folding table classification and summary function of Excel

This article brings you relevant knowledge about Excel. It mainly introduces related issues about folding tables, which is the function of classification and summary. This will be very convenient for viewing data. Let’s take a look at it together. I hope it will be helpful to everyone. .

May 12, 2022 am 11:58 AM

Excel