How to insert a check mark in Excel

How to insert a check mark in Excel

A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it’s used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use...
How to format numbers in Excel with millions separators

How to format numbers in Excel with millions separators

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...
How to format numbers in thousands in Excel

How to format numbers in thousands in Excel

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...
Function: SEARCH

Function: SEARCH

Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling methods.Supported...
Function: FIND

Function: FIND

Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods. Supported versions...

Multi-Level Header Support for Designer Applications

This tutorial shows how to create multi-level columns in designer applications, effectively ‘categorizing’ columns into multiple levels. A typical example is a monthly data table grouped into quarterly sections. We’re going to be using a monthly...
Function: MID

Function: MID

The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods. Supported versions All Excel versions Excel MID...
Excel Function: RIGHT

Excel Function: RIGHT

The RIGHT function in Excel is a powerful tool for extracting a substring from a given string, beginning from the right-most character. This function is particularly useful when you need to retrieve specific characters from the end of a text string. In this...