Uncategorized

Excel Format Painter – An Introductory Guide

In this blog post, you will learn about one of the most useful and underused features of Microsoft Excel which is known as Format Painter. See the image below:- What is Excel Format Painter? Excel Format Painter is used to copy a multi-formatted dataset and apply that formatting into a different dataset. Suppose that a …

How to Use Excel COUNTIF Function – with Multiple Condition

Excel COUNTIF Function is a member of COUNT Family and is a combination of two functions, COUNT and IF function. In this blog post, you will learn about many examples or uses of Excel COUNTIF function, such as find any particular number within a given range or date or text and so on. We can …

Excel COUNTBLANK Function – An Introduction Guide

In this tutorial, we will learn about Excel COUNTBLANK Function. This function is a member of the Excel COUNT Family but for different use. Definition of Excel COUNTBLANK Function Excel COUNTBLANK function counts only blank cells in the data set. If there is any space within the cell, this function will not consider this as …

How to Create a Custom AutoFill List in Excel 2013

In this blog post, we will learn about “how to create a custom auto fill list in Excel 2013”. What is a Custom AutoFill List? Suppose that we want to write a month’s names from January to December. So, for that, we type “January” only and drag down till December. All the names drag automatically. …

Excel COUNTA Function – How to Use (with example)

In this blog post, we will learn about Excel COUNTA function. This function is a member of COUNT family of Microsoft Excel. Explanation In simple words, Excel COUNTA function counts every cell value which is not blank. This function counts each non-blank cell value as “1” and skips blanks. In the previous blog post, we …

Excel COUNT Function – How to Use (with example)

Excel COUNT function is a very basic and built-in function of excel COUNT family. This function counts only numeric values and skips the text ones. Suppose that we want to make a count of a range (B2: B6) i.e. (1, 5, 7, a, b) and apply COUNT function =COUNT (B2: B6) and our result is …

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!