# Advance Excel

## How to Use Multiple Freeze Panes in Excel

In this tutorial, we will learn about “Freeze Panes in Excel”. This feature of Excel allows us to make some part of the dataset visible or lock and rest part movable. Suppose that we have a huge file in Excel and we want to scroll the data up-down or left to right frequently. If the …

## How to Use Excel SUMIFS Function for Multiple Conditions

Excel SUMIFS Function sums the values of a column in a dataset, where result meets or fulfils with multiples of condition or criteria. Microsoft has introduced this Function in 2007 and available after all the versions. What is the difference between Excel SUMIF and SUMIFS function?   Excel SUMIF Function make a sum of values …

## How to use Excel SUMIF Function in Multiple Condition (with examples)

Excel SUMIF Function – An introduction   Excel SUMIF Function sums the values in a range with one criteria or condition. In this blog post, we are going to learn more about Excel SUMIF Function. SUMIF is a combined function of Excel SUM and IF function. SUM function sums the values in a range and IF …

## Excel SUM Function – Five Methods To Use

Excel SUM Function – Definition   Excel SUM Function makes the sum of numeric values in a cell or range of the cells. Which including numbers, cell references, ranges, arrays and skip text values or blank cells.   The Syntax of Excel SUM Function   =SUM (number1, [number2], ….] Argument Explanation   number1 = this …

## Excel COUNTIFS Function – How to Use (with example)

This tutorial describes the formula syntax and usage of the Excel COUNTIFS Function and its usages. Definition – Excel COUNTIFS Function   Excel COUNTIFS function is a member of COUNT family in Microsoft Excel and advanced version of Excel COUNTIF Function. Excel COUNTIFS function count the number of cells in a data-set or range with a …

## Excel COUNTIF Function With Multiple Criteria

Excel COUNTIF function Excel COUNTIF function is the combination of COUNT and IF function.   Excel COUNTIF function – How to define “Excel COUNTIF  function helps us to find a result in a range of cells or dataset if there is any condition or criteria is provided.” Syntax of Excel COUNTIF function =COUNTIF (range, criteria) range …

## Excel COUNT Function – How to Use (with example)

In this post, we will learn about Excel COUNT Function with examples. Excel COUNT Function – Definition     Excel COUNT function is a built-in function of Microsoft Excel and its feature are as follows:-   This function counts only numeric values in a cell or a range of cells. And skips the text values …

## How to use Excel SEARCH function with example

In this post, we will learn about Excel SEARCH function. Excel SEARCH function seeks the location of a character in a string.  And returns its position number in the string from the starting character.   Excel SEARCH function is very similar function to the Excel FIND function. The only difference between both of the …

## How to use Excel FIND function with example

In this tutorial, we will learn about Excel FIND function. Excel FIND function seeks the location of a character in a string.  And returns its position in the string from the starting character.   How to define Excel FIND function   “Excel FIND function seeks the position of a character or sub-string within a …

## How to use Excel MID function (with example)

In this blog, we are going to learn about Excel MID Function. In earlier two blogs we have learned about Excel LEFT Function and Excel RIGHT function. Excel MID Function is very similar to these function but a little bit different. Excel MID Function has three parameters and all are required to retrieve the …