| |
Excel templates, add-ins and spreadsheet solutions for managing the input, update and structure of data. These Excel solutions are designed to increase the efficiency of data management within Excel and can be applied to common tasks such as updating, comparing and organizing data within a defined structure. Excel templates and solutions designed for the automation and assistance with data extraction, loading and transformation with Excel and via external data management systems.
| Featured Product: | |  | | Excel Database Reporting Tools allow connecting to multiple database sources and creating powerful and flexible reports that are updated automatically as source data changes. |
| |
|  | | Data Consolidation for Excel is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks quickly and easily. |
| | Views: 33,020 | Rating: 3 from 1 vote | Buy Now |
|
|  | | Excel Database Report Builder is a special tool that allows you to build reports in Microsoft Excel format from any database. You can build your report using several sources in different formats. |
| |
|  | | The Find and Remove Duplicates Add-in for Excel identifies duplicates within a list of records and offers solutions to filter, edit or remove the duplicate Excel records. |
| | Views: 11,915 | Rating: 3 from 1 vote | Buy Now |
|
|  | | Database Manager for Excel is a database management Excel add-in enabling to store, edit and retrieve data from Excel as a database application. |
| |
|  | | Categorizing Data for Excel is an Excel add-in that allows the categorization of records in an Excel table based on a defined categorization criteria. |
| | Views: 8,779 | Rating: 3 from 1 vote | Buy Now |
|
|  | | Consolidate Spreadsheets for Excel consolidates Excel sheets with a few clicks. It just needs the list of file names and optional consolidation rules may also be adapted to increase flexibility. |
| |
|  | | The Excel Data Management and Analysis add-in is designed for manipulating and analyzing data in Microsoft Excel 97 software onwards and is ideal for anyone who uses Excel to any significant extent. |
| |
|  | | Merge Files for Excel can merge excel sheets into one new sheet or merge excel workbooks into one new workbook with multiple worksheets. |
| |
|  | | Table Management for Excel is a suite of Excel add-ins to assist with managing tabulated data. Table management tools include conditional extraction, consolidation, splitting, merging and categorization. |
| |
|  | | The Data Sharing Add-in for Excel allows the transmission and reception of data between workstations directly from Excel sheets or cells over a network. |
| |
|  | | Prevent Duplicate Entries for Excel is a Microsoft Excel add-in that helps to prevent entering duplicate data while working in Excel. |
| |
|  | | The Data Copying add-in for Excel adds functionality for automating the copying of data from multiple ranges to specified destinations within Excel. |
| |
|  | | Data Manipulation for Excel is a powerful Excel add-in designed to add advanced data manipulation functionality to tabular data in Excel. |
| |
|  | | Reorganize Data for Excel automates the logical organization of data into tables suitable for analysis and pivot table reports. |
| |
|  | | Editable Pivot Tables for Excel allows cells within an Excel pivot table to be edited directly making them a useful tool for data entry. |
| |
|  | | Data Merge for Excel merges data from multiple worksheets into one worksheet based on key columns resulting in a fusion of data from two sources. |
| |
|  | | Hierarchical Data Analysis for Excel is an Excel add-in that enables the creation of hierarchical structures within data in order to automatically analyze totals subtotals of defined data groups. |
| |
|  | | Data Cleansing for Excel is an Excel add-in with multiple functions to interrogate, clean, modify and transform data automatically to save time and resources. |
| |
|  | | SQL Functions for Excel allows SQL data queries to be executed within the Excel application on spreadsheet and external data. |
| |
|  | | Integrate Data for Excel is a client application that integrates Excel data for analysis, process automation, manipulation and reporting. |
| |
|  | | Text Management for Excel is a Microsoft Excel add-in that gives you the power to quickly manipulate large amounts of text. |
| |
|  | | The Excel Relational Database is a database system integrated into Excel so that Excel can be used as the user interface for analyzing and sharing data. |
| |
|  | | Remove Cell Text for Excel is an Excel add-in to automate the removal of certain text content from cells based on specific criteria. |
| |
|  | | Rotate or Flip Data for Excel is an Excel add-in that provides advanced functionality for data table transposing, rotation and reversing order in any direction. |
| |
|  | | Compare Files for Excel can compare and merge Microsoft Excel workbooks. This is a quick and easy-to use tool with its own smart algorithm, used to find differences. |
| |
|  | | Separate Data for Excel analyzes data within an Excel worksheet and creates separate worksheets for data meeting specified criteria |
| |
|  | | Fuzzy Matching for Excel is a powerful solution for finding data in Excel based on exact or partial fuzzy (one or more different characters) criteria and optionally removing found duplicates. |
| |
|  | | Convert Values for Excel is an Excel add-in to convert data values between a wide range of different formats and data types in order to facilitate data analysis and save time. |
| |
|  | | SQL Statements for Excel allows to query Excel files or Access databases using SQL query statements to return filtered data back into Excel for analysis. |
| |
|  | | Import Scanned Document for Excel uses optical character recognition (OCR) to import data from scanned PDF documents into Excel with batch mode support. |
| |
|  | | Excel Complex Data Analysis is a standalone spreadsheet application that facilitates the stepwise analysis of complex data by treating data as multidimensional tables and with intelligent grouping and relationship building. |
| |
|  | | Excel Multiple Workbook Control allows updating, merging, consolidating and slicing of data across multiple Excel workbooks for accurate and fast data management and reporting. |
| |
|
|
| Download Data Management Reference |
|
| For iTunes & iOS Device |
|