# The Blog

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

### 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

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

### 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 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.

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.

### 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.