Excel Tips and Tricks

Versioning Excel Files

Versioning Excel Files

Versioning is the best way to prevent data loss in case of software crashing or faulty updates. If you are a  Microsoft 365 subscriber, the AutoSave feature handles getting copies frequently and allows you to access previous autosaved versions. If you are not a...

How to change CSV delimiter in Excel

How to change CSV delimiter in Excel

Although CSV stands for comma-separated values, it has become a common file type to define simple text files including delimiter-separated data. Thus, a CSV file can use a semicolon or tab character as a delimiter as well. In this guide, we’re going to show you how to...

How to create waffle charts in Excel

How to create waffle charts in Excel

A waffle chart is basically a square display that shows progress towards a target or a completion percentage. They can be a fancy alternative to pie charts. In this guide, we’re going to show you How to create waffle charts in Excel. [button...

How to close all workbooks in Excel with VBA

How to close all workbooks in Excel with VBA

If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...

How to create pill charts in Excel

How to create pill charts in Excel

A pill chart is a fancier way of drawing bar or column charts. Rounded corners and space after axis are enough to make your dashboards catchier. In this guide, we’re going to show you How to create pill charts in Excel. [button...