The Blog

Check out Interesting Blogs with a detailed analysis on different Excel topics.

How to use Find and Replace certain values, cells reference, characters etc in Excel.

Find and Replace Multiple Values at Once

When you observe that there are some mistakes or user wishes to change all values at once. To do this we use Find and Replace.

Ignore Cells/Object from being Printed Image Cells

Ignore Cells/Object from being Printed

In this post, you are going to learn how to avoid and remove certain ranges, errors, Worksheets, cells, images, etc from being printed.

Print in Excel Learn the Basics

Print Excel Sheet – Step by Step Guide

Understand Printing an Excel Spreadsheet with presentable format of entire workbook, worksheet and area with data avoiding mistakes following steps and tips.

Average With Criteria Six Must Know Examples

Average Based on Condition with 6 Examples

In this article, you are going to learn how to calculate AVERAGEIF and AVERAGEIFS with the help of three examples of AVERAGEIF and similarly three examples of AVERAGEIFS.

Add Number with Criterion in Excel (Basic to Advance)

Add Number with Criterion in Excel (Basic to Advance)

In this article, you will understand adding numbers with a criterion by following six examples from simple to complex. For resolving our queries, we will use SUMIF functions.

A 5 × 4 array entered into a range of cells

How to use Array Formulas of Excel?

An Array is a collection of Items. Learn to Create, Edit and Delete Excel array along with the aptitude to perform Array formulas in the spreadsheet.

Drop Down list of products and return their respective price (INDEX and MATCH functions)

Find data using Excel INDEX & MATCH function (Dependent List)

Understand using the Excel INDEX and MATCH functions for locating data and returning its value together with dynamic multiple Drop-Down lists (Advance users).

Excel Drop Down

Learn Excel Drop-Down list

An Excel drop-down list gives a user the ability to select only one option from given predefined possibilities. A drop-down list can simplify the process for an end user and make sure the data is accurate simultaneously.

Forgot Password

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Please Login

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Forgot Password

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Please Login

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Forgot Password

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Please Login

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Forgot Password

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Please Login

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Forgot Password

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit

Please Login

Register

*

First Name

* First Name

First Name can not be left blank.

Please enter valid name.

Please enter valid name.

This first name is invalid. Please enter a valid first name.

*

Last Name

* Last Name

Last Name can not be left blank.

Please enter valid name.

Please enter valid name.

This last name is invalid. Please enter a valid last name.

*

Email Address

* Email Address

Email Address can not be left blank.

Please enter valid email address.

Please enter valid email address.

This email is already registered, please choose another one.

*

Password

* Password

Password can not be left blank.

Please enter valid data.

Please enter at least 6 characters.

Strength: Very Weak

Subscribe to Our Newsletter (No Spam)

Please check atleast one option.

Please enter valid data.

By Signing Up, you agree to the Privacy Policy

Submit