Excel Functions and Description

FUNCTIONS DESCRIPTION SYNTAX AND Checks all the logic arguments and returns True if all are True =AND(logical1,logical2,…) ...

Show Output With Matching Criteria Using Conditional Formatting In Microsoft Excel 2010

In this article, you will learn how to show output with matching criteria using conditional formatting. Q: I have a record set from column A to C (...

How to Create an Invoice Template in Excel

In this article we will show you how to create an Invoice template using MS Excel by using simple functions. An invoice is a little piece of paper th...

How to Extract First, Middle and Last Name from One Cell Into Separate Cells In Excel

In this article we will show you how to extract First, Middle & Last Name from a given text string using multiple methods in Microsoft Excel. Man...

Comparison between Currency and Accountancy

In this article, we’ll learn the difference between currency and accounting in Microsoft Excel. Though both are very similar to each other but still...

Compare Text in Microsoft Excel

In this article, we will illuminate you about how we can compare strings of two cells in Microsoft Excel. We will use EXACT function to compare the te...

Link references with another workbook

How to link with external references In this article, we will learn how we can link one workbook to another workbook in Microsoft Excel. We will use ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube