For everyday professional work in Excel: prepare, analyze and save data, automate routines without programming.
XLTools Add-in contains 12 professional tools for faster and smarter work in Excel. By professional, we mean simple and reliable tools that deliver spot-on results fast, no matter how difficult your task is. And you can forget about mindless tedious routines or painstaking VBA coding.
Some of the most popular tools:
• Popup Calendar
Dates editing made easy. Highly addictive!
• Data Cleaning
Remove extra spaces, change text case, convert numbers to text, etc.
• Version Control sheets and VBA modules
Track who changed what and when, compare changes, roll back any time.
• SQL Queries
Run SELECT, JOIN, GROUP BY and other queries directly against tables in Excel.
• Automation without macros
Automate routine Excel tasks without complicated VBA, add custom buttons to Excel ribbon.