The Blog
Check out Interesting Blogs with a detailed analysis on different Excel topics.
Using the INDEX and MATCH Together in Formula
Learn creating formulas using the INDEX and MATCH function to find value in Excel. Avoiding errors thrown using the VLOOUP function. I hope you will enjoy it; please download the workbook from the below link. In the first worksheet, we will
Finding and Managing Formula Errors in Excel
We will try to understand how to resolve and change formula errors like #DIV/0!, #N/A, #REF!, #VALUE! including other errors in the Excel with a detailed tutorial.
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.