How to use the wildcards in Excel

In this article, we will learn How to use the wildcards in Excel. Partial match up in Excel In Excel, sometimes you find yourself with probl...

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 learn How to Extract First, Middle and Last Name from One Cell Into Separate Cells In Excel. Scenario: Splitt...

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...

How to Compare Text in Microsoft Excel

Let’s learn how to compare two strings in Excel. To compare two strings we can use comparison operator “=”. It will work fine until you want to ...

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.