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?

 

Any questions or suggestions? Please leave your comment below.

Leave a Reply

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