Excel small program store, practical and efficient office assistant use evaluation
Brother Zhiqi 2021-06-10 04:32:13

1 What is? Excel Applet store ?

Excel Applet store Specially designed for excel and wps Tables provide extended functions The app store , There are many stores that can help users quickly complete various office operations Applet , There is no need for users to master functions and vba Code , Directly use the simple program interface, mouse click operation to complete the work .

Excel App download address :Excel Applet store - download

Interface after software installation : A list of app stores will appear on the right

All applets can be installed in the middle of the store page , Install what you use , The installation speed is very fast .


Excel Applet store , Practical and efficient office assistant use evaluation

Interface after software installation

Favorites applet Evaluation :

Click in the list of applets on the right to open the favorites Excel A favorite column appears above , Right click here to create a new favorite , And add local excel file . The process is similar to browser favorites .

Besides being able to collect excel Outside the document , And it's also like 、 Worksheet navigation function , Two buttons on the left side of favorites ,【B】 Move the mouse to B The currently open workbook appears above , Move to 【S】 All worksheets in the current workbook will appear on the , It's very convenient to switch between files and worksheets .


Excel Applet store , Practical and efficient office assistant use evaluation

A quick query Applet evaluation ( Automatic generation VLOOKUP,HLOOKUP function ):

On the right side of the applet list, click quick query to open the quick query applet , The interface is as follows .


Excel Applet store , Practical and efficient office assistant use evaluation

Automatic generation VLOOKUP

The process of small program is very simple , After the query area is specified, the 2 Enter... In the text box Query column ,3 Enter... In the text box The query value ,4 Enter... In the text box Return column , Click OK to automatically generate VLOOKUP function , Also supports Multiple conditions Query and Reverse order query , It is much more efficient and correct than handwritten function , Even if you are a function master, you are also recommended to use this small program , Avoid careless mistakes in handwriting , A waste of time .

That's what happened this time Excel Applet store And among them favorites and A quick query Simple use of two small programs , besides , There are also many useful extension applets in the store , Recommend it to every office worker .

The disadvantage is that the software is charged , But the price is very low, just 40 You can use it for one year , The average day is 1 Jiao Qian , Relative to office efficiency, it's still worth it , Sometimes I sort out the form for half a day, and the result small program only needs one button to complete .

Excel App download address :Excel Applet store - download

版权声明
本文为[Brother Zhiqi]所创,转载请带上原文链接,感谢
https://fheadline.com/2021/05/20210522094240115i.html
相似文章