Excel Productivity Blog

Case

How a Hospitality Consulting Firm Saves 3-4 Hours a Day with Excel Automation

March 15, 2026

8 min read

Swauger Consulting Services, LLC supports over 20 hospitality clients with revenue forecasting and reporting. As their client base grew, daily Excel data preparation turned into hours of copy-paste work and a higher risk of errors. With XLTools Automation, they standardized their workflow, reduced manual prep, and freed up 3-4 hours a day.

How-to

Automating Questionnaire Generation with AI and Google Forms

February 13, 2025

5 min read

Discover how to use AI and Google Apps Script to automate the creation of structured questionnaires, saving time and effort.

Transitioning Office Add-Ins to Modern Platforms

How-to

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

December 11, 2024

7 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.

Learn 10 Excel formulas that are essential for any advanced user for complex calculations or large data sets.Learn 10 Excel formulas that are essential for any advanced user for complex calculations or large data sets.

How-to

10 Excel formulas for advanced users

July 15, 2022

5 min read

Learn 10 Excel formulas that are essential for any advanced user for complex calculations or large data sets.

How-to

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

April 26, 2022

4 min read

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

Template

Forecast future dividends on shares of Russian companies

December 22, 2020

4 min read

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

News

Meet the new XLTools website – fast and helpful!

July 8, 2020

2 min read

We have refreshed XLTools brand and we are excited to present you the new website. Every element is focused on helping you find the information you need quickly and easily. Go ahead and explore!

Case

Excel automation for a printing company: processing orders

December 20, 2017

12 min read

Many companies rely on Excel to transfer data from one system to another. For ID Line, a printing company, Excel is a common denominator of online ordering, accounting and manufacturing systems. However, data transfer is always a potentially weak spot.