Skip to content

Tag Archives: Excel-functions

Decile is a statistical method to split data into 10 equal parts.  Each represents 1/10 of the Population or Sample data. It is denoted D1,… Read More
“Pivot Table calculated field” is an option to include more data or calculations in the pivot table.  Often, we need to add our own custom… Read More
In this article, we explain how to extract the last word from a text in a cell using the Excel function.  Extracting words from a… Read More
Microsoft Excel is a powerful tool and is widely useful too. It has various features to ease our work. One such feature is Data Validation.… Read More
Excel is powerful data visualization and analysis program we use to create reports or data summaries. So, sometimes happen that we have to create a… Read More
The Excel CHOOSE function returns a value/reference from an array using a given position. Syntax:Attention reader! Don’t stop learning now. If you are an Excel… Read More
In Excel, we can approach the problem in two ways. [SUMIF Formula and Excel Pivot] Sample data: Sales Report TemplateAttention reader! Don’t stop learning now.… Read More
In Microsoft Excel, in order to find Nth Largest value (with duplicates), an array formula based on MAX and IF functions is used. First, we… Read More
In this article, we will see how we can combine multiple values, and use them as lookup criteria for searching specific value(s) in the excel… Read More
If you use programming languages, like python, you must have used a function called string slicing, which extracts a part of the string and can… Read More
The calculation of matrices is one of the most difficult numerical computation tasks. You may need to add values diagonally in a table when performing… Read More
Every day in business or any other field lots of information are there that are required to store for future use. For anyone, it is… Read More
In Excel, sometimes we want to sum up the values based on some specific text values. Such as the cells which have text written as… Read More
Excel is providing various types of sorting formats e.g. “sort A to Z”, “Sort Z to A”, “Sort by color” and “Sort by date” etc.… Read More
Excel is mostly about numerical, however, we often have data of text data type. Here are a few functions we should know to handle text… Read More

Start Your Coding Journey Now!