Watch how XLTools simplifies routine operations in Excel

XLTools is a powerful toolkit for professional work in Excel. No matter how complicated your task is, or how large your spreadsheet is – these add-ins make the difficult operations easier.

These video overviews briefly cover key functionality and possible application cases of XLTools features. If any requests for more videos, please leave a comment below.


Popup Calendar

  • Insert dates from a datepicker
  • Insert dates in cells and ranges
  • Change default format as necessary

Learn more

Unpivot Table

  • Convert a crosstab table to a flat list
  • Flatten complex 2D tables
  • Unpivot large tables

Learn more

Data Cleaning

  • Trim unwanted spaces and line breaks in cells
  • Change text case in cells and ranges
  • Convert text to numbers, or numbers to text

Learn more

Combine Cells Data

  • Combine cells contents by rows or columns
  • Merge cells without losing data
  • Set any separator between combined values

Learn more

Export to CSV

  • Export a selected range from Excel to CSV
  • Select a delimiter: comma, semicolon, tab, pipe
  • Save Excel as CSV repeatedly without closing the original Excel file

Learn more

Columns Match

  • Compare and match columns with each other
  • Match data sets against benchmarks
  • Calculate match percentage

Learn more

Repeat Selection

  • Select alternate rows or columns
  • Select cells in a checkerboard pattern
  • Select and shade cells in any repeating pattern

Learn more

Sheet Switcher

  • Alt+Arrows for Excel (works similar to Alt+Tab combination in Windows)
  • Navigate large workbooks quickly
  • Switch between the most recent sheets fast

Learn more

 

More videos are coming soon! Any suggestions? Please leave your comment below.

 

Any questions or suggestions? Please leave your comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *