|Home > Excel Business Solutions > Excel Productivity > Data Management > Data Management and Analysis||Share|
Excel Data Management and Analysis
Rate this solution:(3/5 from 2 votes)
The Data Management and Analysis Excel add-in is designed for manipulating and analyzing data in Microsoft Excel 97 software and above and is ideal for anyone who uses Excel to any significant extent . |
Excel Data Management and Analysis finds almost any selection of cells on a sheet (by their appearance, contents or location) and can carry out some selected function on them, (such as change the appearance, the contents, or the location) automatically and in the way specified.
Key Features of the Excel Data Management and Analysis add-in include:
A Statistics module is included free and fully integrated, allowing you to see instantly the sum, average, sum of positives and negatives separately (useful for accountants to see Debits & Credits), maximum and minimum values of your selected area even if it contains error cells. It also allows you to see instantly an analysis of your selected cells in terms of the number of cells, and the number that contain formulae, values, positive values, negative values, zeros, errors, text, blank and non-blank cells.
The Excel Data Management and Analysis statistics module screen pops up quickly, even if the whole page (16,777,216 cells) is selected. The reason why this is so useful is that, unlike the normal status bar at the bottom of the screen, it shows you all the figures in one go, and it copes with error cells.
Related Excel Solutions for Data Management and AnalysisData ManipulationData Management Database ManagerData Management Editable Pivot TablesData Management Spreadsheet AuditingNavigation and Auditing Workbook ToolsNavigation and Auditing Conditional Formatting FunctionsTime Saving Productivity Tools Add-insTime Saving Model NavigationModel Building
|Share your thoughts and opinion with other users: Create Review|
Browse Main Excel Solution CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity