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?
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 .
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
DATEDIF in Excel is a date function which is used to obtain the difference between two given dates. These differences in given dates can be in years, months or days. It requires two dates as an arguments and a keyword to specify which type of difference is desired for the output. In short, DATEDIF function… Continue reading What is DATEDIF 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.
What exactly is HLOOKUP in excel? HLOOKUP in Excel stands for ‘Horizontal Lookup’. The HLOOKUP function in excel makes the excel search for a certain value in a row also called as ‘table array, in order to return a value from a different row in the same column. HLOOKUP always searches for a value in the… Continue reading HLOOKUP Function 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
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 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
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