The Blog
Check out Interesting Blogs with a detailed analysis on different Excel topics.
Protect Excel Files with Password
To protect your workbook, sheet or part of the sheet after ignoring range, cells, formula, etc so that no user will be able to open or made changes.
Count Based on Condition with Eight Examples
Understand how to count in Excel if two or more criteria are given and return If matches with the given text or value with Excel COUNTIF and COUNTIFS examples.
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.
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.
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.