Page 96-Topics-php.cn

Article Tags

Topics

Home

Technical articles

Topics

Teach you step by step how to create a dynamic fuzzy matching drop-down menu in Excel

This article brings you relevant knowledge about Excel, which mainly introduces related issues about how Excel makes dynamic fuzzy matching drop-down menus. Let’s take a look at them together. I hope it will be helpful to everyone.

Apr 24, 2022 pm 12:08 PM

Excel

Excel pivot table learning value field settings

In the previous article "Sharing Practical Excel Skills: Using Pivot Tables to Summarize Performance", we learned about Excel Pivot Tables and learned how to use Pivot Tables to summarize performance. Today we continue to learn Excel pivot tables and talk about value field settings. I hope it will be helpful to everyone!

Apr 24, 2022 am 10:24 AM

Excel

Practical Word Tips Sharing: 9 Text Formatting Methods

In the previous article "Sharing Practical Word Tips: How to Automatically Add Numbers to Tables", we learned how to automatically add numbers to Word tables. Today we are going to talk about 9 classic text formatting techniques in Word, which are simple but very practical!

Apr 24, 2022 am 10:05 AM

Word

Summary of usage of SUBSTITUTE function in Excel

This article brings you relevant knowledge about Excel, which mainly introduces issues related to the SUBSTITUTE function. This function is one of the most commonly used text functions in Excel. In the data analysis process, it is often used to organize and clean strings. , let’s take a look at it, I hope it will be helpful to everyone.

Apr 22, 2022 am 11:35 AM

Excel

Practical Excel skills sharing: Calculate the difference in years, months, and weeks

In the previous article "Sharing Practical Excel Skills: Using Pivot Tables to Summarize Performance", we learned about Excel Pivot Tables and learned how to use Pivot Tables to summarize performance. Today we will talk about how to calculate the time difference (year difference, month difference, week difference), I hope it will be helpful to everyone!

Apr 22, 2022 am 09:56 AM

Excel

Practical Word Tips Sharing: How to Automatically Add Numbers to Tables

In the previous article "Sharing Practical Word Tips: How to Delete All Numbers with One Click", we learned how to delete all numbers with one click in Word. Today we are going to talk about how to automatically add numbers in Word tables, it is simple but very practical!

Apr 22, 2022 am 09:44 AM

Word

Detailed graphic explanation of typical usage of XLOOKUP function in Excel

This article brings you relevant knowledge about Excel. It mainly introduces the relevant knowledge about the XLOOKUP function, including regular query, reverse query, returning multiple columns, automatic debugging and approximate search. Let's take a look at it together. I hope it helps everyone.

Apr 21, 2022 am 11:46 AM

Excel

Practical Excel skills sharing: Use pivot tables to summarize performance

In the previous article "Sharing Practical Excel Tips: How to Make Barcodes", we learned how to make barcodes in excel. Today we will learn about Excel pivot tables and see how to use pivot tables to summarize performance. I hope it will be helpful to everyone!

Apr 21, 2022 am 10:17 AM

Excel

Practical Word skills sharing: How to delete all numbers with one click

In the previous article "Sharing Practical Word Skills: How to Quickly Calculate Tabular Data", we learned how to quickly calculate tabular data. Today we will talk about how to delete all numbers in Word with one click, it is simple but very practical!

Apr 21, 2022 am 09:50 AM

Word

Summarize the usage of several Excel2021 special functions

This article brings you relevant knowledge about Excel. It mainly introduces the typical usage of several special functions, including SEQUENCE function, SORT function, SORTBY function, UNIQUE function, FILTER function, etc. I hope it will be useful to everyone. help.

Apr 20, 2022 pm 06:32 PM

Excel

Practical Excel Tips Sharing: How to Make Barcodes

In the previous article "Practical Excel Skills Sharing: Advanced Chart Production - Column Chart", we learned how to create high-level charts - column charts. The following article will introduce to you how to create barcodes in excel. I hope it will be helpful to you!

Apr 20, 2022 am 09:59 AM

Excel

Practical Word skills sharing: How to quickly calculate tabular data

In the previous article "Practical Word Tips Sharing: Multiple Methods to Enter Mathematical Formulas", we learned about various techniques for inputting mathematical formulas in Word. The following article will show you a super convenient formula application technique. It turns out that Word table calculations are also very simple!

Apr 20, 2022 am 09:50 AM

Word

Practical Excel skills sharing: Advanced chart production-column chart

In the previous article "Excel function learning: Let’s talk about the SUMPRODUCT function", we learned how to use the SUMPRODUCT function. The following article introduces practical Excel skills and talks about advanced chart production. I hope it will be helpful to everyone!

Apr 19, 2022 am 11:52 AM

Excel

Practical Word skills sharing: multiple ways to enter mathematical formulas

In the previous article "Sharing Practical Word Tips: Bookmarks and Cross-References!" 》In this article, we learned about a rarely used Word feature—bookmarks and cross-references. The following article will teach you various techniques for inputting mathematical formulas in Word. Come and save it and use it!

Apr 19, 2022 am 11:38 AM

Word