What is an array in Excel?

Basically, an array is a set of items. The items can be text or numbers and they can occupy in a single row or column, or in multiple rows and columns. An array is only a list or range of values. What is an array formula in Excel? Array formulas in Excel are a very powerful tool and difficult… Continue reading What is an array in Excel?

Understanding conditional formatting .

Conditional formatting is a feature in various spreadsheet applications that permits you to apply specific formatting to cells that meet certain criteria or specified condition. It is mostly used as a color-based formatting to highlight, emphasize or differentiate among statistics and information stored in a spreadsheet. Conditional formatting makes it easy to highlight interesting cells (ranges of… Continue reading Understanding conditional formatting .

Excel XLOOKUP Function

What Is XLOOKUP Office 365 now boasts a powerful and more useful successor to the VLOOKUP function which is “ XLOOKUP function”. XLOOKUP is the latest addition in the Excel lookup function family which includes VLOOKUP, HLOOKUP, INDEX+MATCH, LOOKUP and so on. XLOOKUP permits us to search for an item in a given range or table and… Continue reading Excel XLOOKUP Function

Paste Special in Excel.

What is Paste Special in Excel ? Excel’s Paste Special offers a vast range of options to paste only particular elements of the copied cells or to perform a mathematical operation with the copied data in situations where the standard copy / paste in not suitable. Paste special is a common function in productivity software programs… Continue reading Paste Special in Excel.

How to use CONCATENATE In Excel

The word concatenates simply means “to combine” or “to join together”. The CONCATENATE function in excel permits you to combine text from different cells into one cell. As a financial analyst, we frequently deal with varied data when doing financial analysis. The data is not always organize for analysis and we often need to combine data from… Continue reading How to use CONCATENATE In Excel

VLOOKUP Function in Excel– Introduction

What exactly is VLOOKUP in excel? VLOOKUP in excel stands for ‘Vertical Lookup’. The VLOOKUP function in Excel is a tool to scan a certain piece of information in a table or data set and extracting some corresponding data/information. For example, suppose you have a list of products with their prices, you can search for the… Continue reading VLOOKUP Function in Excel– Introduction

Pivot table in excel tutorial: 5 Key Steps

Pivot tables are a technique in data processing. They arrange and rearrange data in order to highlight the useful information. This leads to finding figures and facts quickly making them essential to data analysis. This ultimately leads to helping businesses or individuals make wise decisions. It  is a summary of a outsized dataset that generally includes the overall figures,… Continue reading Pivot table in excel tutorial: 5 Key Steps

How to Transpose Excel Data

Transpose in Excel How to Transpose Excel Data with the TRANSPOSE Function. Transpose is returns a vertical range of cells as a horizontal range, or horizontal range of cells as a vertical range. The Transpose function is entered as an array formula in a selected range that has the same number of rows and columns as… Continue reading How to Transpose Excel Data