A While loop is used when we have to repeat a set of statements as long as the condition is false. It could be the …
Continue ReadingThe FOR Loop
PHP for loop can be used to traverse set of code for the specified number of times. For example if you want to repeat something …
Continue ReadingPHP- DATE/TIME FUNCTIONS
When working in any programming language, dealing with dates and time is a simple task. That is, until time zones have to be supported. PHP’s …
Continue ReadingExcel CONCATENATE Function
Excel CONCATENATE function is one of the best time saving Excel function. You must have seen people copying the value from one cell and then …
Continue ReadingExcel Right Left and Mid Functions
Excel Right, Left and Mid functions return number of characters from selected text. These formulas can be used to get a pattern of characters from …
Continue ReadingExcel Trim Function
Excel Trim function is very useful function that removes extra spaces from data. This formula removes all spaces from data except for single space between …
Continue ReadingExcel Length Formula
Excel LEN formula is used to get number of characters in a cell. The formula counts the number of characters in a cell including spaces …
Continue ReadingExcel Count Function
Excel COUNT function counts the cells which has numeric values. For instance if we want count total cells that has only and only numeric values …
Continue ReadingExcel Sum Function
SUM function is one of the most used function in MS Excel. This formula not only adds user defined values in a cell but also …
Continue ReadingExcel Macro Training Details
VBA is an object-oriented programming language and well suited to beginners. It provides many of the Visual Basic programming facilities through the Excel application. Thus, …
Continue Reading
