Excel Functions

Use of PERMUTATIONA Function in Excel (4 Simple Examples)

In this article, we will explore how to use the PERMUTATIONA function in Excel to generate phone numbers, pin codes, license plate numbers, and even ...

How to Use EVEN Function in Excel (5 Examples)

The EVEN function in Excel is a tool that can round up a number to the nearest even integer. It takes one argument, which is the number you want to ...

Advanced VLOOKUP in Excel

Advanced VLOOKUP in Excel: Knowledge Hub Use VLOOKUP for Multiple Columns VLOOKUP from Multiple Columns with Only One Return Use VLOOKUP ...

How to Sum If Cell Contains Number and Text in Excel

It is an informative article that provides solutions to a common problem encountered by Microsoft Excel users. This article discusses the challenge ...

How to Use Excel SUMIF with Blank Cells (3 Easy Methods)

This article illustrates how to use the SUMIF function to sum up values corresponding to blank or empty cells in Excel. Even though blank cells are ...

[Fixed!] Excel SUMIF with Wildcard Not Working (4 Solutions)

This article will discuss 4 possible solutions for Excel SUMIF not working with a wildcard. The SUMIF function often fails to recognize wildcard ...

Excel SUMIFS with Not Equal to Text Criteria (4 Examples)

In this article, we are going to discuss how to use the Excel SUMIFS function with Not Equal to Text criteria. Excel users often need to sum specific ...

Excel SUMIF Not Working (9 Possible Cases with Solutions)

With the help of Excel's SUMIF function, users can sum a range of numbers in accordance with specific criteria. However, there are times when the ...

How to Use SUMIF Function to Sum Not Blank Cells in Excel

Summing is one of the most performed operations in Excel. In Excel, there are multiple functions that you can use to sum values. Among these, the ...

Excel VBA to Find Cell Address Based on Value (3 Examples)

If you frequently use Excel, you may have encountered scenarios where you needed the address of a cell that contained a specific value. For instance, ...

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

Are you looking for an Excel function that will return the standard deviation of the entire population and also match the given criteria? In this ...

How to Use Excel SUMIF to Sum Values Greater Than 0

When working with large datasets in Excel, it is often necessary to sum values that meet a certain condition. One useful function for this purpose is ...

How to Use VLOOKUP Function with Exact Match in Excel

While working on big datasets of big companies, educational institutions, and financial organizations like banks, it is required to find particular ...

How to Use Excel DMAX Function (2 Easy Examples)

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more ...

How to Use LARGE Function with VLOOKUP Function in Excel

Today we will discuss how we can use the LARGE function with the VLOOKUP function in Excel. The LARGE function returns the n-th largest value of a ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo