You can’t make document alterations more convenient than editing your excel files online. With DocHub, you can access tools to edit documents in fillable PDF, excel, or other formats: highlight, blackout, or erase document elements. Add text and images where you need them, rewrite your copy completely, and more. You can download your edited record to your device or submit it by email or direct link. You can also turn your documents into fillable forms and invite others to complete them. DocHub even has an eSignature that allows you to sign and send out documents for signing with just a couple of clicks.
Your documents are safely kept in our DocHub cloud, so you can access them at any time from your PC, laptop, mobile, or tablet. If you prefer to apply your mobile phone for file editing, you can easily do it with DocHub’s mobile app for iOS or Android.
Hello everyone, my name is Vikal Jain and today I am going to nullify debit and credit entries in Excel. So, even you can say it as we are going to nullify positive and negative entries. So, here we have 1,000 entries. As you can see on the screen, it is one thousand. Now, we are going to nullify all the entries and we are going to find out the remaining entries which are not nullifying. So, what we are going to do? We are going to do some steps, so that we can extract that data. So letamp;#39;s begin. So for nullifying the entry we are going to use ABS first. So, what ABS do? ABS convert all the number into positive. It will also convert the negative number into positive and positive number into positive. So, letamp;#39;s try ABS. So, drop in down. Now, I am going to sort this data ing to ABS. Abs. Now you can see here is one positive, one negative, one negative, one negative. So, two is nullifying. So, letamp;#39;s try to find out the list. We are going to make a pivot table here.
