Excel Productivity Blog | XLTools Add-in for Excel

Transitioning from VSTO and VBA to Web Add-Ins and JavaScript

Transitioning from VSTO and VBA to Web Add-Ins and JavaScript

How-to

Transitioning from VSTO and VBA to Web Add-Ins and JavaScript

December 11, 2024

10 min read

Discover the transition from VSTO and VBA to web-based Office Add-Ins using JavaScript, and how to adapt to modern Office automation.

Use this guide to learn how to remove leading spaces in Excel in less than 60 seconds.

Use this guide to learn how to remove leading spaces in Excel in less than 60 seconds.

How-to

How to remove leading spaces in Excel [Step-by-Step Guide]

April 26, 2022

6 min read

How to forecast future dividends on shares of Russian companies on multiple brokerage accounts? Here is the easy-to-use free template.

How to forecast future dividends on shares of Russian companies on multiple brokerage accounts? Here is the easy-to-use free template.

Template

Forecast future dividends on shares of Russian companies

December 22, 2020

10 min read

News

Meet the new XLTools website – fast and helpful!

July 17, 2023

3 min read

Companies rely on Excel to transfer data from one system to another, when Excel is a common denominator of online ordering, accounting and manufacturing systems. However, data transfer is always a potentially weak spot.

Companies rely on Excel to transfer data from one system to another, when Excel is a common denominator of online ordering, accounting and manufacturing systems. However, data transfer is always a potentially weak spot.

Case

Excel automation for a printing company: processing orders

December 20, 2017

15 min read

Carlo was working on a challenging, yet quite common task. He had to create a system, which would process Excel data from 10-20 product-testing laboratories, export data to MySQL and then generate management reports.

Carlo was working on a challenging, yet quite common task. He had to create a system, which would process Excel data from 10-20 product-testing laboratories, export data to MySQL and then generate management reports.

Case

Automate data manipulation in Excel and transfer data to MySQL

October 31, 2017

10 min read

Companies that use Excel for business analytics and reporting, often face the challenge of organizing group work on shared documents. In these cases issues like data safety and versioning are on top of the list.

Companies that use Excel for business analytics and reporting, often face the challenge of organizing group work on shared documents. In these cases issues like data safety and versioning are on top of the list.

How-to

Ways to track changes in a shared Excel workbook

March 30, 2016

3 min read

While working in Excel, we often do not question habitual actions that turned into a routine. 10-15 habitual clicks seem inevitable. It’s time to practice useful habits with the help of free Office Store apps.

While working in Excel, we often do not question habitual actions that turned into a routine. 10-15 habitual clicks seem inevitable. It’s time to practice useful habits with the help of free Office Store apps.

How-to

Useful habits in Excel: three online Office apps

March 18, 2016

7 min read

The first webinar with the overview of XLTools features (aired January 2014, presents early version of XLTools Add-in). We will point out all the features you can use to speed up your daily routine work.

The first webinar with the overview of XLTools features (aired January 2014, presents early version of XLTools Add-in). We will point out all the features you can use to speed up your daily routine work.

Webinar

Webinar: XLTools features overview

January 12, 2014

20 min read