Shulou(Shulou.com)06/01 Report--

This article mainly introduces what the Excel plug-ins are, which are very detailed and have certain reference value. Friends who are interested must finish reading them.

First, Excel toolbox: square grid plug-in official website: http://www.ffcell.com/ square grid Excel toolbox is a square lattice studio independently developed large-scale Excel toolbox software. The toolkit is powerful, easy to operate, supports undo and supports DIY toolkit. The function of Excel is greatly enhanced and the office efficiency is improved. Supports 32-bit and 64-bit Office, and supports versions from Excel2007 to 2016. It has hundreds of practical functions: text processing, batch input, delete tools, merge conversion, duplicate value tools, data comparison, advanced sorting, color sorting, merge cell sorting, spotlight, macro storage box, etc., of which the "macro storage box" provides a large number of common macros and functions. Users can continue to collect macros and functions commonly used by themselves and on the network to create their own "arsenal". The storage box also provides Excel interface DIY function.

The toolbox has a simple interface, powerful function, close to users, simple operation, good user experience and other characteristics, has been praised by many netizens, the following are some animation cases.

1. Spotlight (to prevent misreading)

In the face of an Excel table full of large amounts of data, the previous row is often regarded as the next, which leads to errors. Spotlight is the biggest weapon to prevent misreading lines. Please take a look at the animation:

two。 Pointer tool (pointing to the key data, clear at a glance) holds an Excel report to the company leaders, how to point out the key data to them, so that the leaders do not know where the data you are talking about is. Pointer tool, is a very good choice, straight to the key data, let the audience at a glance.

3. Merge cell summation encounter merge cell summation, what should I do? The usual summation method doesn't work. Here's another quick way. Look at the animation:

4. According to the cell background color (font color) statistics summation, count according to the specified color (can be cell background color, font color), count the corresponding number of cells, or statistical summation, please see the animation:

2. Excel Chart plugin: EasyCharts

EasyCharts is an easy-to-use Exce plug-in, mainly with one click to generate charts, chart beautification, color reference and other functions that are not provided by Excel. You can easily handle charts that require programming or complex operations. The following shows some of the chart types in the plug-in. 1. Instrument panel chart

two。 Pyramid chart

3. Kernel density estimation Fig. 4. Correlation matrix diagram

These are all the contents of the article "what are the plug-ins for Excel functions?" Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.