Home > Excel Business Solutions > Excel Productivity > Time Saving > Automation Add-ins Share

Automation Add-ins

Excel automation add-ins for time saving


Excel Automation Add-ins

Rate this solution:
(4.5/5 from 2 votes)
Automation Add-ins screenshot
Excel automation add-ins (XLTools) facilitates productivity in Excel with a set of time saving add-ins that automate commonly used data management tasks. Routine operations can be performed much faster with reduced risk of errors through the flexible and high performance automation add-ins provide through the added menu tab.

Key features of the excel automation add-ins include:
  • Popup Calendar - automatic population of correct dates and formats by choosing from the calendar.
  • Data Cleansing - batch conversion of data type with cleaning tools including white space removal and case switching.
  • Unpivot Table - transforming multidimensional pivot tables to flat tables for analysis and external system importing.
  • Combine Cells Data - concatenation of adjacent cell content with optional delimiter specification.
  • Sheet Switcher - tools to quickly navigate and switch between worksheet tabs in large and complex workbooks.
  • Repeat Selection - remembers multiple cell selection addresses so that the same selections can be automatically made later.
  • Version Control - stores version information with commentaries with functionality to roll back to previous versions.
  • SQL Queries - utilize the power of SQL query language on Excel data to create complex data mining queries with joins.
  • Mail Merge - create highly dynamic emails from Excel data content and recipient data in Excel.
  • Custom Automation - record repetitive tasks or define within an Excel table for automated execution without requiring any VBA code.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2024-08-01)

Related Excel Solutions for Automation Add-ins

Data CleansingData Management  Workbook ToolsNavigation and Auditing  Cell CalendarTime Saving  Merge Data RangesTime Saving  Productivity Tools Add-insTime Saving

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.