Denodo VS Excel Dashboard School

Text Tools and Smart Utilities! Text processing and string manipulations in Excel are not an easy tasks but we’ll help you to simplify string related functions using our add-in.

Feature list:

• Convert text to uppercase, apply Excel lowercase to your data or convert your text values to proper / title case
• Delete first or last character from a selected string
• Delete x characters starting at the nth position
• Remove spaces, non-printable characters, all line breaks, initial apostrophes
• Insert text before first, after last character
• Insert text starting at nth position and much more….
• Calendar. Quick dates entry to save your time.
• Drop-down list creator: Create drop-down list in selected cells in seconds
• Spreadsheet Tools – Effective management for Ranges
• Data Collector: Consolidate Multiple Worksheets into one Workbook
• Split Ranges: Split one data table into several different sheets based on the values of the specified column or other criteria.
• Compare Ranges: Compare two columns or ranges and the output or highlighting of coincidences / differences between them.
• Clean Ranges: Delete text, formats, notes, hyperlinks, conditional formatting, etc. in selected cells.
• Screenshot Manager: Create screenshot of selected range and export it into various formats.
• WorkSheet Manager
• Perform vary operations (adding, sorting, protecting, etc.) on sheets in current workbook.