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. Download Workbook[/button Raw data The following...
How to insert chess symbols in Excel

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

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

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

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...
How to calculate area under curve in Excel

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. Download Workbook Unfortunately, there isn't a single function or feature that can calculate area under curve in Excel. You can still rely on integrals to calculate area. On the other...
How to round date values 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. Download Workbook...
How to round time values in Excel

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. Download Workbook Date and time...
How to save each sheet as CSV in Excel

How to save each sheet as CSV in Excel

In this guide, we’re going to show you how to save each sheet as CSV in Excel. Download Workbook Excel to CSV Saving an Excel worksheet as a CSV file is an easy task. All you need to do is to use Save As section in File menu and select the CSV as the file type. This...