Reporting Tools for Excel (ExtendExc) provides a range of Excel add-ins for analyzing and reporting Excel data. Common tasks are made quick and easy with automation for page setup, data navigation, cell formatting, transforming and moving data. The reporting tools accelerate the creation of professional and rich Excel reports by access to time saving tasks from the add-in's drop down menu.
Key features of Reporting Tools for Excel include:
- Convert numeric values to text words.
- Convert currency symbols to text words.
- Distribute data proportionately on defined dates.
- Generate random numbers between any two values.
- Convert dates to month and year text based on any end date.
- Advanced SUMIF and COUNTIF functions based on cell or font colors.
- Password generation of specified length and type
- Calculation and countdown listing to target dates from any date.
- Arithmetic calculations on selected cells.
- Export snap shots of selected range or entire worksheet to new workbook.
- Categorize data from minimum to maximum values using colors.
- Return sum, minimum, maximum, count, average and number of occurrences of specified value for selected cells in a single operation.
- Select or navigate to cells based on minimum, maximum, next lower/higher, less than or grater than in selected cells.
- Merge cells vertically
- Apply current page settings to all sheets.
- Insert multiple rows between each row in selection at regular intervals.
- Insert multiple columns between each column in selection at regular intervals.
- Display a calendar to quickly select dates to entry.
- Toggle between capital, proper and lower case for selected range
- Toggle between wrapped text and vertical alignment of selected cells.
- Return the current workbook file and directory folder path.
- Concatenate selected cells and obtain the result as either a value or formula.
- Apply rows to be repeated on top of each page in a single action.
|