Wrap text is a feature in Excel which allows adjusting long text data into a single cell. What is Wrap Text in Excel? Suppose that we are entering our data into a cell and this data cross more than one cell. See the image below:- Here you can see that the text is crossing more …
Copy and paste are one of the most used activities in Excel.In this video, I will share the 3 easiest methods to copy and paste in Excel VBA. Please feel free to put your comments or suggestion in the comment box below. If are a beginner in Excel VBA, please feel free to share the …
Copy and Paste in VBA – 3 Easiest Way (Beginners Level) Read More »
Excel SUM function is a very basic and built-in function in Microsoft Office. Basically, this function sums the values in a cell or range of cells. Which includes numbers, cell references, ranges, arrays, and always skip text values or blank cells. Syntax of Excel SUM Function =SUM (number1, [number2]… Number_n]) or =SUM (Range1, [Range2], [Range3], …
This tutorial describes the formula syntax and usage of the Excel COUNTIFS Function and its usages. Excel COUNTIFS Function – Definition Excel COUNTIFS function is a member of the COUNT family and advance version of Excel COUNTIF Function. This function is a combination of two functions, “COUNT” and “IFS” two functions. Separately both of them …
How to Use Excel COUNTIFS Function with Multiple Criteria Read More »
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 …
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 …
How to Use Excel COUNTIF Function – with Multiple Condition Read More »
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 …
Excel COUNTBLANK Function – An Introduction Guide Read More »
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. …
How to Create a Custom AutoFill List in Excel 2013 Read More »
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 COUNTA Function – How to Use (with example) Read More »
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 …
Excel COUNT Function – How to Use (with example) Read More »