How to Merge Two Columns Without Losing Data in Excel

Since you’re here, you’ve must tried to merge and center two cells to get them combined, but to your surprise, you only got the data in the left c...

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

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.