Microsoft Excel – How to generate Random numbers?
Microsoft Excel provides RAND and RANDBETWEEN functions to generate Random numbers. Through this Article we are going to discuss about these two functions. Excel random...
Microsoft Excel – Rounding Numbers to the Specified number of digits
We have discussed rounding the numbers using CEILING and FLOOR functions through my previous Article “Microsoft Excel – CEILING and FLOOR functions“. Excel provides another...
Microsoft Excel – CEILING and FLOOR functions
As part of Excel functions discussions, we are going to discuss about two functions through this Article; which are CEILING and FLOOR functions. The CEILING...
Microsoft Excel – Text Functions – MID and MIDB formulas
We have discussed in our Previous Article on how to extract partial text in Excel using LEFT, LEFTB and RIGHT, RIGHTB functions. In this Article,...
Microsoft Excel – Text Functions – T and TEXT formulas
Microsoft Excel provides T and TEXT functions to display the text and format the numeric value, respectively. We will discuss about these functions in this...
Microsoft Excel – Text Functions – EXACT, FIND and FINDB formulas
In this Article, we will discuss about another set of useful Text Functions Microsoft Excel provides to search the text in the given text. The...
Microsoft Excel – Text Functions – SEARCH and SEARCHB formulas
Another set of Text functions SEARCH and SEARCHB in Microsoft Excel are useful to find the text within the given text. These functions returns the...
Microsoft Excel – Text Functions – TRIM and REPT formulas
When dealing with data Microsoft Excel provides lot of useful Text functions. We will discuss about another set of Text functions; TRIM and REPT in...
Microsoft Excel – Text Functions – REPLACE, REPLACEB and SUBSTITUTE formulas
The set of text functions in Microsoft Excel are used to replace the text with the new text. These functions are widely used when deal...
Microsoft Excel – Text Functions – LEFT, LEFTB and RIGHT, RIGHTB formulas
Another set of Text Functions in Microsoft Excel are useful to extract the partial text from the given text. These functions have two variations; one...
Microsoft Excel – Text Functions – LOWER, PROPER and UPPER formulas
Microsoft Excel provides set of Text Functions to alter the given text to lowercase, uppercase and capitalize of each word. In this Article, we will...
Microsoft Excel – Text Functions – BAHTTEXT, DOLLAR and DBCS formulas
Continuation to our series of Articles of Text Functions; in this Article, we will discuss few more Text Functions from Microsoft Excel. BAHTTEXT function This...
Microsoft Excel – Text Functions – CONCAT, CONCATENATE and TEXTJOIN formulas
Through the series of Articles, we are discussing about different types of functions in Microsoft Excel. In this Article, we will discuss few more Text...
Microsoft Excel – Text Functions – CLEAN, CODE, VALUE and NUMBERVALUE formulas
In our previous Article, we have discussed few Text Functions in Microsoft Excel. In this Article, we will discuss few more Text Functions. CLEAN Function...
Microsoft Excel – Text Functions – ASC, CHAR, UNICHAR and UNICODE formulas
Microsoft Excel Text Functions are useful to deal with the text data. In this Article we will discuss few of the Text functions. ASC function...
Microsoft Excel – Logical Functions – TRUE, FALSE and NOT formulas
Set of Logical Functions Microsoft Excel provides to return the logical value, either TRUE or FALSE are going to be discussed through this Article. The...
Microsoft Excel – Logical Functions – AND, OR and XOR formulas
I have explained few logical functions in the Article “Microsoft Excel – Logical Functions – IF, IFERROR and IFNA formulas“. In this Article, we will...
Microsoft Excel – Logical Functions – IF, IFERROR and IFNA formulas
Microsoft Excel provides logical formulas to enable to select the data depending on the given criteria. For example, select the data; if some condition(s) satisfies....
Microsoft Excel – Concatenation and Reference Operators
Microsoft Excel provides another set of operators to deal with concatenation of text and combine ranges of Cells for calculations. Concatenation Operator This operator ONLY...
Microsoft Excel – Comparison Operators
Microsoft Excel provides Comparison Operators to compare the values of two operands. You can give the values directly or you can give the Cell references...