Summarize, Count, Average, Maximum, Minimum, Median, Count Unique, Subtotal, Pivot Table
Join Several Rows Into One Cell With Separator Commaįilter or Count of Unique Values In The Range In Excel Visual Lookup In Excel (Dictionary Queries) Save or Split Each Worksheet Of One Workbook As Separate Excel Workbookįilter Data, Match Table, Filter or Count of Unique Values, Lookup Tableįilter Data That Based on the Multiple Criteria Range Split or Save Each Sub Sheet as Separate Excel File Split Table Into Sub Sheets Based On Multiple number of rows Split Table Into Sub Sheets Based On Multiple Selected Columns Split Sheet Into Sub Sheets Based On One Selected Column Merge all same name sheets from other workbooks into one sheet Merge multiple sheets from other workbooks into one new workbook Merge multiple sheets from other workbooks into one new sheet
#CREATE EXCEL ADD INS FREE#
Over 50 powerful features are included in this easy-to-use package.ĭownload the Free Excel macro add-in file: Excel Tool Box.xlam Function List: Merge Excel Data From Multiple Sources Summarize, count, average, maximum, minimum, median, subtotal, count blank and SQL Query your data. With the tools you can merge, split, match, filter, remove duplicates, query, create Crosstab / Pivot Table,
#CREATE EXCEL ADD INS SOFTWARE#
The software add advanced data analysis capabilities to Microsoft Excel and are guaranteed to save you time and speed up your work. Useful Resources Excel Merge, Split, Match Table, Complex Filter, Pivot Table, Summarize, Count, Remove Duplicates, SQL Excel add-ins, Excel Merge, Split ,Match Table, Complex Filter, Pivot Table, Summarize, Count, Remove Duplicates, SQL