Excel Tool

Order Online
Our company contact information There you can find frequently asked questions and answers

Home | Products |Purchase | FAQ | Contact Us | Useful Resources

Excel Merge, Split, Match Table, Complex Filter, Pivot Table, Summarize, Count, Remove Duplicates, SQL

The software add advanced data analysis capabilities to Microsoft Excel and are guaranteed to save you time and speed up your work.
With the tools you can merge, split, match, filter, remove duplicates, query, create Crosstab / Pivot Table, summarize, count , average, maximum, minimum, median, subtotal, count blank and SQL Query your data. Over 50 powerful features are included in this easy-to-use package.

Function List:

 

Merge Excel Data From Multiple Sources

Merge multiple sheets from other workbooks into one new sheet

Merge multiple sheets from other workbooks into one new sheet

Merge multiple sheets from other workbooks into one new workbook

Merge multiple sheets from other workbooks into one new workbook

Merge all same name sheets from other workbooks into one sheet

Merge all same name sheets from other workbooks into one sheet

Merge 2 Tables by Matching Data

Merge 2 Tables by Matching Data

Merge Columns in Excel (Combine)

 

Merge Columns in Excel (Combine)

Add on Character(s) to Column

Add on Character(s) to Column

Split Excel

Split Sheet Into Sub Sheets Based On One Selected Column

 

 

Split Sheet Into Sub Sheets Based On One Selected Column

Split Table Into Sub Sheets Based On Multiple Selected Columns

Split Table Into Sub Sheets Based On Multiple Selected Columns

Split Table Into Sub Sheets Based On Multiple number of rows

 

Split Table Into Sub Sheets Based On Multiple number of rows

Split or Save Each Sub Sheet as Separate Excel File

Split or Save Each Sub Sheet as Separate Excel File

Save or Split Each Worksheet Of One Workbook As Separate Excel Workbook

Save or Split Each Worksheet Of One Workbook As Separate Excel Workbook

Filter Data, Match Table, Filter or Count of Unique Values, Lookup Table

Filter Data That Based on the Multiple Criteria Range

Filter Data That Based on the Multiple Criteria Range

Match Tables Based on Columns in Excel

 

Match Tables by Columns in Excel

Visual Lookup In Excel (Dictionary Queries)

Visual Lookup In Excel (Dictionary Queries)

Visual Horizontal Lookup

Visual Horizontal Lookup

Join Several Rows Into One Cell With Separator Comma

Join Several Rows Into One Cell With Separator Comma

Filter or Count of Unique Values In The Range In Excel

 

 

Filter or Count of Unique Values In The Range In Excel

Summarize, Count, Average, Maximum, Minimum, Median, Count Unique, Subtotal, Pivot Table

Summarize / Count / Average / Maximum / Minimum / Subtotal

Summarize / Count / Average / Maximum / Minimum / Subtotal

Join Several Rows Into One Cell With Separator Comma, Space...

 

 

 

 

Join Several Rows Into One Cell With Separator Comma, Space...

Crosstab / Pivot Table -- Convert Flat Table to Pivot Table

Crosstab / Pivot Table -- Convert Flat Table to Pivot Table

Convert Crosstab / Pivot Table to Flat Table (List)

 

Convert Crosstab / Pivot Table to Flat Table (List)

Count of Unique Values in Subtotal (Pivot table)

Count of Unique Values in Subtotal (Pivot table)

Enhanced Summary: To Provide More Functions, Functions of Species More Than MS Pivot Table and Subtotal

To Provide More Functions, Functions of Species More Than MS Pivot Table and Subtotal

SQL Query And Summarize, Crosstab / Pivot Table (Excel, Accessl)
1. Create Two Dimensional Table / Crosstab / Pivot Table . 2. Summarize / Count / Average / Maximum / Minimum Data By Fields.
3. Merge Multiple Excel files or Sheets. 4. Split Excel Sheet by Fields.
5. SQL INNER JOIN, LEFT JOIN, RIGHT JOIN, UNION ALL . 6. Filter the Access/Excel Data In Excel.

Example1:

Matched Rows from Table1, Matched Rows from Table2

 

Matched Rows from Table1, Matched Rows from Table2

Example2 (SQL Left Join):

All Rows from Table1, Matched Rows from Table2

All Rows from Table1, Matched Rows from Table2

Example3 (SQL Right Join):

Matched Rows from Table1, All Rows from Table2

Matched Rows from Table1, All Rows from Table2

Example4:

Create Two Dimensional Table / Crosstab / Pivot Table 

Create Two Dimensional Table / Crosstab / Pivot Table


Current Version:14.11.12
File Size: 1.82(MB)
Platform: Windows2000/XP/Vista/Windows7/Windows8/Windows8.1.
Software requirements: Microsoft Excel 2007/2010/2013.
Purchase Price: $49.95

21

The tools is an Excel macro add-ins.

or

Download the Macro Add-In File: ExcelToolBox.xlam


How to install ?

Click the upper-left on the File menu → OptionsAdd-Ins → Select 'Excel Add-ins' from Manage list: Click the Go... button → Browse...

then find and select your ExcelToolBox.xlam file, make sure ExcelToolBox checkbox is checked, finally click on the OK button.

 

1. Click the upper-left on the File menu:

2. Click the Options button:

3. Click the Add-Ins button:

4. Select 'Excel Add-ins' from Manage list and Click the Go... button:

5. Click the Browse... button:

6. Find and select your ExcelToolBox.xlam file.

7. make sure ' ExcelToolBox' checkbox is checked, then click on the OK button.

If you do not see the software in Ribbon Add-ins TAB:

Close all Excel, and then Reopen Excel.

 

If you do not see Ribbon Add-ins TAB:

1.Click the upper-left on the File menu → OptionsCustomize Ribbon

2. make sure ' Add-Ins ' checkbox is checked, then click on the OK button.


How to uninstall ?

Click the upper-left on the File menu → OptionsAdd-Ins → Select 'Excel Add-Ins' from Manage list: Click the Go... button.

then find and Uncheck 'ExcelToolBox ' , finally click the OK button.

Copyright © 2001-2014 Excel-Tool All Rights Reserved.

Copyright Excel-Tool All rights reserved