Introduction: We often came across the requirement of joining texts or concatenation in spreadsheets. This requirement might arise due to need to creating a key for lookup operations or might be to create full name, with first, second and third name present in various column of the sheets. The procedure of joining text is help in creating custom messages where information is … [Read more...]
The Most Useful MS Excel Formulas for Accountants
Introduction: Just like other spreadsheet users, accountants do use a lot of formulas. It is not necessary that all the formulas that are used by accountant relate to their accounting functions. In order to make their sheets works and analyze data intelligently they use formula from across the categories provided in MS Excel: Lookup Function, Statistical Functions, Text … [Read more...]