Select Page

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

## 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 calculate depreciation in Excel

Excel supports various methods and formulas to calculate depreciation. There 7 built-in functions dedicated to depreciation calculation. In this guide, we’re going to show you How to calculate depreciation in Excel in 7 ways. Depreciation types in this article:...

## How to calculate units of production depreciation in Excel

Units of production depreciation is a common and useful parameter for manufacturing firms to calculate the value of an asset based upon usage. In this guide, we’re going to show you How to calculate units of production depreciation in Excel. Download Workbook How to...

## 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. Download Workbook[/button Raw data The following...

## How to insert chess symbols in Excel

In this article will show you How to insert chess symbols in Excel. Download Workbook[/button Copy & Paste You can simply copy & paste the character from here: ♔♕♖♗♘♙♚♛♜♝♞♟ Enjoy. 🙂 Symbols Excel (Word too) has a feature named Symbol which is a dialog box that...

## How to generate random data in Excel

The importance and use cases of randomized data is increasing as the information technologies grows. You can lower the margin of error in analyzing methods and testing algorithms or eliminate the bias between subjects in the datasets. In this article will show you How...

## How to use Greek Letters in Excel

Greek letters are commonly used in various areas, like mathematics and science as symbols for constants or variables, or even in the game industry to define phases of a product. They are also commonly used nowadays with naming new COVID-19 variants. If you need them...

## How to create a progress chart in Excel

In this guide, we’re going to show you how to create a progress chart in Excel. Download Workbook Steps to create a progress chart 1.      Calculate remaining process Start by calculating the remaining process. If you are using a percentage value, the formula will...