Archive for September 2013

Excel Dashboard Training

Learn Microsoft Excel Dashboard with Advanced Formulas and Macros: Excel Dashboard Training is very useful program for those who want to learn or improve their knowledge on Excel Dashboard. Participants will learn how to present and analyze their data using… Read More ›

Case-Insensitive Match

Excel Exact Formula is Case-Sensitive. Learn how to do Case-Insensitive Match. Exact Function is one of the Case-Sensitive Formulas in Excel. In this Post we will see how we can do case-Insensitive match between two text strings. Case-Insensitive Match is… Read More ›

Excel Mid Formula

Learn How to use Excel Mid Formula: As name depicts, Mid Function is used to extract the characters from middle of the formula. Excel Mid Formula extracts the specified number of characters from specified position. Mid Function Syntax: Mid(text, start_num,… Read More ›

Excel Left Formula

Learn How to use Excel Left Formula: Excel Left Formula extracts the specified number of characters from the left hand side of a cell. It is used to remove unwanted characters from Right Side of a cell. Left Function Syntax:… Read More ›

Excel Right Formula

Learn How to use Excel Right Formula: Excel Right Formula extracts the specified number of characters from right hand side of a cell. In other words, it extract data from the the end of a text string. It is used… Read More ›

Excel Exact Formula

Learn How to use Excel Exact Formula: Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences. Exact Function works with Text… Read More ›