EXCEL filtering assistant

The computer version of EXCEL Screening Assistant is an EXCEL auxiliary tool that is often used in the office. The official version of EXCEL Filtering Assistant can not only filter out data in tables, but also implement a series of functions, such as proportion, sum, and difference combinations. The EXCEL filtering assistant facilitates users to customize searches. After setting conditions, they can also filter by conditions, which can meet the problem of filtering in different columns.

Introduction to EXCEL Filtering Assistant Software

The official version of EXCEL Filtering Assistant is a powerful data filtering form software. It is a data filtering form software specially developed for statisticians, so that people who do not use functions can easily use it. It is no longer complicated functions and Bitter Brain, thousands of data can be done easily and helps users to get the data quickly. EAL has a large number of Excel files, making it simple for workers is the purpose of our software, and provides users with online customer service personnel to solve corresponding problems for you.

Features of EXCEL filtering assistant software

1. Flexible and diverse printing functions: Print Assistant helps you when printing

1. Intuitive page settings and page adjustments are refreshing;

2. No matter what the structure of your data table is, you can freely set up paging;

3. Freely set the top title line and low-end footnotes (customized content), and the printing effect is full of personality;

4. Able to customize "double-sided printing", "odd-even page printing", "autonomous printing", etc.

2. Row and column operations:

1. Flexibly insert, delete, separate, merge, and move rows and columns, and convert rows and columns;

2. Ability to quickly and accurately search, mark, and delete duplicate values ​​in rows or columns;

3. Able to compare, search, label, and extract similar and different data from any two columns of data;

4. Automatically reduce rows and add columns to rearrange data in an orderly manner, making the data area neat and beautiful, and saving paper when printing;

5. Append one column of data to another column in order as needed.

3. Worksheet operations:

1. Easily implement the basic operations of creating, copying, sorting, and deleting data in worksheets;

2. You can quickly delete all blank worksheets in the specified or current workbook, delete specified worksheets, and batch rename the worksheets in the workbook;

3. The designated worksheet can be split into several worksheets or workbooks based on classes, departments, etc. to facilitate data distribution and management;

4. Merge all worksheets in the specified workbook into one worksheet to facilitate statistical analysis, comparison, and management of data;

5. You can export a specified worksheet or all worksheets in the workbook to the corresponding workbook to facilitate data distribution, management and use;

6. You can query and extract related data between any two worksheets based on a certain related field.

4. Workbook operations:

1. Notepad files can be imported into the current or specified workbook in batches to facilitate data summary and analysis;

2. Workbook files can be imported in batches into the current or designated workbook for data summary and analysis.

5. Database operations:

1. Microsoft Visual FoxPro database (*, dbf) files can be imported into the current or designated workbook for intuitive data summary, statistical analysis, and fast and efficient reporting and printing;

2. You can easily export the specified worksheet to a Microsoft Visual FoxPro database (*, dbf) file to achieve database reporting.

6. Access to educational affairs: educational administration and department management can help you

1. Easily carry out statistical analysis on the average scores and total scores of designated subjects in each class on a class and department basis;

2. Easily realize various types of headcount statistics in data tables and score tables: statistics of the number of people in each class with X points or above in designated subjects, statistics of the number of people in each class with scores in designated subjects, statistics of people in the ranking band of designated subjects in each class, statistics of people in each class with N points in designated subjects Celebrity statistics;

3. Quickly and efficiently calculate the difference between two subjects for each candidate or each record, the total score of the designated subject, and the average score of the designated subject;

4. Quickly and fully automatically rank department and class rankings, and compare the data at a glance to guide candidates to check for deficiencies;

5. Use complex data tables to quickly and accurately conduct intuitive statistical analysis of the five rates of designated subjects in each class: the number of "five levels" (excellent, good, average, passing, failing), the "five rates" (excellent rate) , good rate, average rate, passing rate, failing rate);

6. You can quickly and easily convert raw scores into standard scores;

7. The score sheet can be made into score strips and distributed to each candidate's email, so that candidates can quickly obtain personal scores and achieve privacy of personal scores (the function of sending score strips to email can only be used by registered users) .

7. Financial management, financial management: help you with financial management

1. Easily realize automatic paging subtotals and last page totals of financial data tables to achieve fast and accurate reports;

2. Employees’ salary sheets can be made into personal salary slips and distributed to each employee’s email address, so that employees can quickly obtain personal salary slips, conduct bank reconciliations, and achieve privacy of personal wages (salary slips are sent to The email function can only be used by registered users).

8. Excel Assistant Toolbox:

1. Search Wizard: Quickly search, query, index, mark, and extract data in all worksheets in the current or specified workbook;

2. Location Code Wizard: It can query the location code of Chinese characters while inputting it. It can also quickly query the location code of Chinese characters in specified columns in existing data tables, and then print and distribute them, so as to quickly and efficiently fill in the photoelectric information. card, eliminating the pain of searching in the Chinese character location codebook;

3. Fill wizard: can fill data tables quickly, efficiently and regularly;

4. Slash header: Personalize the data table that has been statistically analyzed, which is both beautiful and intuitive;

5. Data positioning selection: You can set conditions according to actual needs and perform data positioning processing and analysis;

6. Democratic evaluation and competition average score statistics: Each unit and department conducts various assessments and competitions every year. There are many judges and a lot of data. They also have to make a certain proportion of the highest and lowest scores, and finally make statistics. Average score, the workload is quite large, everyone pays great attention to the statistical results, and there is no room for any mistakes. This tool can help you;

7. Network application: Send data reports to the designated email address or upload data reports to the ftp server (this function can only be used by registered users);

8. Quick input device: Set the input direction, enter the column number or row number and the number of data digits, and then you can enter numbers. You can enter data quickly and efficiently without hitting the enter or direction keys. On the one hand, it reduces the number of keystrokes. , greatly improving the input speed. On the other hand, it avoids data separation, misalignment and other errors caused by accidentally hitting Enter or other keys in traditional data input methods;

9. Quick scrolling: Facing a complex data table with vertical and horizontal rows and columns, "one leaf obstructs the vision", and you can't look up or down, or left or right. Using this tool can help you get what you want and browse the data with just a flick of your finger;

10. Hongtong Perpetual Calendar: Intuitively compare the lunar calendar and the Gregorian calendar, and inquire about solar terms and traditional festivals;

11. Lock screen: If your computer's Windows operating system has a user password set, when you leave temporarily, using this function will keep your computer in a protected state, making your data safe and worry-free;

9. Excel system:

When users use the Excel Assistant to process data, they need to use some functions of the Excel system. This assistant also takes this into consideration and draws on some important functions, such as: selecting the continuous data area of ​​the current cell (&L) Select Define visible cell area, paste special, normal view, paged preview, header and footer, function, cell format (border, alignment), sort, auto-filter, subtotal, freeze pane, undo window freeze, current The worksheet automatically reduces column width and font size to fit the cell size.

EXCEL Filtering Assistant Installation Steps

1. Download the EXCEL screening assistant software from Huajun Software Park

2. Unzip the software package, and then you can see the EXCEL Filtering Assistant.exe application.

3. Double-click to open the application

4. The EXCEL filtering assistant is a green version, and users can use it after opening it.

EXCEL Filtering Assistant Instructions for Use

For example: you want [head teacher] to include the word "小" or the [category] is 2.

You can filter them out directly, using EXCEL is a bit troublesome!

EXCEL Filter Assistant update log

1. Modify user-submitted bugs

2.Add new features

​