Select Page

# Excel Tips and Tricks

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

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

## 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. Steps to create a...

## How to calculate area under curve in Excel

In this guide, we’re going to show you how to calculate area under curve in Excel. ...

## How to round date values in Excel

Excel has extensive array of rounding functions as expected from a spreadsheet software. However, rounding date values is not as straightforward as rounding numeric values. In this guide, we’re going to show you how to round date values in Excel. [button...

## How to round time values in Excel

Excel has numerous rounding functions as expected from a spreadsheet software. However, rounding time values may not be as straightforward as rounding numbers. In this guide, we’re going to show you how to round time values in Excel. [button...