How to change case in Excel

How to change case in Excel

Being full of columns and headers, spreadsheets can often pose some challenge in matching the character case across the workbook. In this article, we are going to show you how to change case in Excel in several ways. Download Workbook Unlike in Word, unfortunately,...
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 written communication methods everywhere. 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...
How to use symbols on charts in Excel

How to use symbols on charts in Excel

Adding symbols or icons into charts can help add to 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. Download Workbook Adding symbols to Excel Let’s see how you can...
How to find nth closest match in Excel

How to find nth closest match in Excel

Excel’s data lookup functions are, and have been saving us countless hours on our desks. Microsoft has also recently introduced some new functions like the XLOOKUP and XMATCH to further help with data analysis, and overcome some of the limitations of the older...
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...