ExcelSuite is an application that can process data across numerous Excel workbooks.



1.Add up the same cell across worksheets

Is there a way to add the same cell (ie.A1) from multiple worksheets without manually having to input sum (Sheet1:A1, Sheet2:A1, Sheet3:A1?)? Yes it is! With it you can merge multiple worksheets of the same format across multiple workbooks.



2.Collect worksheets from multiple workbooks

Sometimes you may need to copy the worksheets of multiple workbooks into one workbook. If there are too many workbooks, it will be time-consuming to do it manually. By this feature, you can do it quickly.



3.Collect rows from multiple workbooks

ExcelSuite allows you to copy a pre-defined number of rows from multiple workbooks into a single file.



4.SUM based on categories

Total up categorical data; Add up all data that have the same category. This operation can be implemented across workbooks.



5.Merge 2 worksheets by matching values

With this feature, you can merge 2 worksheets by matching values. The program matches rows automatically based on the key column, and connect the rows from the two worksheets into one row.



6.Get common rows between two worksheets

With this feature, you can get common rows between worksheets.



7.Remove row if common value in another worksheet

It searches duplicated rows by specified key column of two worksheets, and removes rows from worksheet1 if the rows also appear in another worksheet2.



8.Check worksheets of the same format

By this feature, you can check worksheets based on a template worksheet. These worksheets can exist in single workbook, or across multiple workbooks. What to check: 1) whether the data match the formulas; 2) whether the data type of cells is the same with those in the template worksheet.

• FindReplaceExcel 1.0
  FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks .

• Workbook TOC 1.1
  Workbook TOC is a table of contents generator for a Microsoft Excel workbook

• Ability Spreadsheet Upgrade 200
  

  Ability Spreadsheet has incorporated all the essential features users would expect from their spreadsheet, as well as a range of advanced features ¬ some of them unique to Ability ¬ to make working with numerical data as easy and clear as it...

• Ability Spreadsheet 200
  

  Ability Spreadsheet has incorporated all the essential features users would expect from their spreadsheet, as well as a range of advanced features ¬ some of them unique to Ability ¬ to make working with numerical data as easy and clear as it gets:

  • industry-standard interface and operation;
  • Microsoft Excel compatibility;
  • multi-sheet workbooks, which can be connected by cross-sheet formulas to help you organise and relate your the data for your calculations;
  • each workbook can contain up to 255 worksheets;
  • each worksheet consists of 256 columns by 65,536 rows;
  • labour-saving tools such as AutoSum, AutoStats, AutoSpell, and AutoList; over 240 predefined functions, grouped into useful categories: mathematical, financial, trigonometric, logical, statistical, date and time, text, and document information;
  • Recent Folders and Recent Files sidecar menus to make finding files and folders quick and easy;
  • a PDF Creator to create PDF copies of your spreadsheets (these
  • Ability Spreadsheet Education 200
    

    Ability Spreadsheet has incorporated all the essential features users would expect from their spreadsheet, as well as a range of advanced features ¬ some of them unique to Ability ¬ to make working with numerical data as easy and clear as it gets:

    • industry-standard interface and operation;
    • multi-sheet...
    • ConnectCode Deluxe Add-In for Excel 1.0
      ConnectCode Deluxe Add-In for Microsoft Excel is a collection of commonly used add ins for improving the productivity of a Excel user
    • Worksheet Sort 3.0
      Worksheet Sort will sort the worksheets in an Excel workbook in either ascending (A-Z) or descending (Z-A) order. The trial version is limited to sorting only 10 worksheets in a workbook.
    • PATools Balance Forward (1 year license) for Excel
      The PATools Data Copier allows you to copy data quickly and easily within Microsoft Excel between different workbooks and worksheets, including closed workbooks
    • PATools Data Copier (1 year license) for Excel 97 R1.1
      The PATools Data Copier allows you to copy data quickly and easily within Microsoft Excel between different workbooks and worksheets, including closed workbooks. This is...
    • FindReplaceExcel 2.15
      FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks