How to change case in Excel

How to change case in Excel

In this article, we are going to show you how to change case in Excel using different methods. Download Workbook Unlike in Word, Excel doesn’t have any built-in features that can help modify the text case. However, some of the methods we will be looking at in...
Function: DEC2HEX

Function: DEC2HEX

The DEC2HEX is an Engineering function that converts a hexadecimal number into a decimal number. In this guide, we’re going to show you how to use the DEC2HEX function and also go over some tips and error handling methods. Supported versions All Excel versions DEC2HEX...
Function: HEX2DEC

Function: HEX2DEC

The HEX2DEC is an Engineering function that converts a hexadecimal number to decimal. In this guide, we’re going to show you how to use the HEX2DEC function and also go over some tips and error handling methods. Supported versions All Excel versions HEX2DEC Syntax...
How to use emojis in Excel

How to use emojis in Excel

Did you know that Emojis have been around since 1997? They essentially became an integral part of most written communication methods. In this article, we are going to show you how to use emojis in Excel. Download Workbook How to insert an emoji in Excel You can insert...
How to use symbols on charts in Excel

How to use symbols on charts in Excel

Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel. Adding symbols to Excel Note that you can always copy a symbol from...
How to find nth closest match in Excel

How to find nth closest match in Excel

In this article, we are going to show you how to find nth closest match in Excel. Download Workbook To find the closest match only, you can use a simpler version of this method here: How to find closest match in  Excel. To find the nth match of an exact matched value,...
How to create a Waterfall Chart in Excel

How to create a Waterfall Chart in Excel

A waterfall chart is a data visualization tool that shows how positive or negative values in a data series change in a sequential manner. A common scenario is to display the cumulative effect of income and expenses on net income. The values can be distributed either...
How to cut and paste transpose in Excel

How to cut and paste transpose in Excel

A common problem when transposing data in Excel is that data is populated in their relative cells. This means that you may occasionally see messed up references when using the Paste function with transpose. In this article, we are going to show you how to cut and...
How to find the first blank cell in a range in Excel

How to find the first blank cell in a range in Excel

Finding the first blank cell in your workbook can become a fairly repetitive task, especially in situations like adding new rows into a large data set. In this article, we are going to show you how to find the first blank cell in a range in Excel, and also show you...