August 17, 2019

How to merge Excel workbooks with Git

Posted by Felix Zumstein

Git is generally known to have a bit of a learning curve. For many, using and merging branches may already be on the list of advanced topics. But even if you are fluent with using branches and merging them, the fun usually stops when Git gives you this message: Automatic merge failed; fix conflicts and then commit the result. If...

Read more...


May 27, 2019

The best free VBA developer tools in 2019

Posted by Felix Zumstein

Despite all the new possibilities to program Excel (like JavaScript add-ins, VSTO and others), VBA remains the most popular language when it comes to automate and enhance Excel. And just because Microsoft hasn’t invested in either the language itself nor the VBA editor during the last 20 years, it doesn’t mean that you can’t pimp your VBA coding experience with...

Read more...


May 16, 2019

A better way to track changes in Excel

Posted by Felix Zumstein

Track changes in Word is one of the hottest features, but Microsoft has been struggling with providing an equivalent feature for Excel. The track changes functionality of shared workbooks has so many limitations that it was officially stamped as “legacy” and replaced by the new co-authoring functionality. While co-authoring is great (especially if you are coming from Google sheets), it...

Read more...



January 28, 2019

How to find Formula Errors in Excel Spreadsheets

Posted by Felix Zumstein

Most Excel workbooks contain errors which in some cases lead to unpleasant “surprises”. Spreadsheet errors come in many different flavors: Some of them are easy to spot but others are much more subtle: When you forget to update an external data source for example or when you copy a formula from the cell above instead of from the cell to...

Read more...


January 15, 2019

Compare 2 Excel Workbooks with xltrail

Posted by Felix Zumstein

While xltrail is a version control system for Excel files at heart, it can also be used to compare two (or more) Excel files ad hoc. There are other tools available to do that (see my previous blog post) but xltrail is a great choice for comparing two files for the following reasons:

Read more...



Sign up to receive tips about how to write better Excel workbooks

© 2020 Zoomer Analytics LLC. All rights reserved.