CONCAT Function
The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016 as a replacement/alternative to the CONCATENATE Function. Most […]
September 2019
CONCATENATE Function
The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together. Syntax: =CONCATENATE (text1, text2, [text3], …) Arguments: text1
CONCATENATE Function Read More »
Average Annual Growth Rate (AAGR)
Learn how to calculate the Average Annual Growth Rate (AAGR) in Excel.
Average Annual Growth Rate (AAGR) Read More »
INDIRECT Function with Named Ranges
In this tutorial, we are going to cover how to use the INDIRECT Function with named ranges in Excel. Before we begin, please make sure you have a
INDIRECT Function with Named Ranges Read More »
VBA ColorIndex
Colors Colors could be very important and useful in excel application. There are two ways in which you can get or set the colors in VBA Excel. They
Use a Letter to Represent a Value in Excel
This tutorial will show you how to use a letter to represent a specific value. Using this process, you can perform mathematical calculations, such as multiplying X time
Use a Letter to Represent a Value in Excel Read More »