How to Create Tornado Charts in Excel

How to Create Tornado Charts in Excel

A Tornado Chart is a fancy form of a bar chart. They shine when the goal is to compare two variables. Although Excel doesn't support tornado charts natively, they are a few simple steps far away from you. In this guide, we’re going to show you How to Create Tornado...
How to make words plural in Excel

How to make words plural in Excel

Neither words nor grammar is where Excel shines. On the other hand, texts may be handful to inform users what a numeric value means, such as units. Making this type of information changed between singular and plural forms dynamically may increase the end-user...
How to seasonal forecast with formulas in Excel

How to seasonal forecast with formulas in Excel

Big or small, all business operations need forecasting. Forecasting can be either qualitative or quantitative. In the end, you should estimate future incomes and expenses to draw up a budget. Since each business sector and the company have their own dynamics, there is...
FORECAST.ETS.SEASONALITY

FORECAST.ETS.SEASONALITY

The FORECAST.ETS.SEASONALITY function is a Statistical function that predicts the length of the season in a repetitive pattern, for a given specified time series. The function returns the same season length which is calculated by the FORECAST.ETS function...
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. Download Workbook Creating a...
How to visualize percentage progress in Excel

How to visualize percentage progress in Excel

Nothing beats visuals when you need a simple way to track progress. Visual indicators can tell you which project is leading immediately without delving into numbers. In this guide, we’re going to show you How to visualize percentage progress in Excel. Download...