Microsoft Excel – How to convert one date format to another date format?
Microsoft Excel provides flexibility to convert the date(s) into different formats. These dates are either automatically convert based on the system settings or based on...
Microsoft Excel – DATE functions
DATE function and related functions are important functions to deal with date related data in Excel. DATE function This function returns the date by taking...
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....