Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In this post you will learn how Remove Duplicates in Excel works and when and why to use. See in the above picture I made…

We know about errors in excel. We face different types of errors when working in excel. Today I will discuss about different types of errors and why it shows. #DIV/0! It’s meaning is division by zero. When a value is…

Here I am having an example to show you the Paste Special with skip blanks. Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you have to…

Tagged with: PASTE

Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In the Formula ribbon you can get a group of features named Formula Auditing. It includes Trace Precedents Trace Dependents Remove Arrows Show Formulas Error…

Tagged with: FORMULAAUDITING

Top