Excel & Accounting

If the financial data of the company is being maintained in Excel spreadsheet, there may be circumstances where the accountant wants to summarize the data in such a way that he or she could come to know how many times that particular data appeared in the spreadsheet between two set of dates. In Exce...
last updated on 28-Nov-2017
Accounting is a vast field and as such has a lot of data available which you can use to generate various types of report as per your requirement. In this regard, if you can take support from Excel, it would be beneficial for you in many aspects. It will save your time, effort and reduces the chances...
last updated on 28-Nov-2017
The time attendance machine is desgned in such a way that it records in and out from the office so many times. In this case, it becomes difficult to know that what is the first time and last time and he or she entered the office. This calculation is necessary for payroll processing and valuation of ...
last updated on 28-Nov-2017
In large organizations, the office staff and labour are found in huge quantity. In order to keep track of their attendance up to date is not an easy task. If the number of employees touches thousand, then it become the headache of the human resource staff to process the salaries and print the slips....
last updated on 28-Nov-2017
Net Present Value (NPV) is a useful investment analysis technique which helps the management greatly in making informed decisions. Manual exercise of calculating NPV takes a time but thanks to Microsoft Excel that it can be done within a minutes. Things to require In order to calculate NPV using Exc...
last updated on 28-Nov-2017
The maximum amount of revenue which the Government earns from direct taxes comes from salaried individuals. In order to calculate the amount of tax liability, we need to memorize the slab rates which is not an easy task. Most of the time, we have to open up the books and manuals to check which rates...
last updated on 29-Nov-2017
In oder to better perform your work in accounting and finance, this is the dire need to grip your hands over Microsoft Excel Functions. The person who holds a strong grip over the formulas are given more chances of growth in any type of organization. The task which you do in plenty of hours, can be ...
last updated on 29-Nov-2017
We have covered Pay Back Period in great detail. The process is not difficult and usually takes hardly 05 minutes. But, there are friends who want to know the exact years with decimal values. For them, we are sharing the Excel formula which you can use to find out PBP. You just need to enter initial...
last updated on 29-Nov-2017
We have discussed Declining balance methodof depreciating the fixed asset in the past. But in this tutorial, we will focus on how we can do it with easy to use Microsoft Excel formula. Excel FormulaDeclining Balance DB( cost, salvage, life, period, [month] ) Where: cost = cost of the asset salvage =...
last updated on 30-Nov-2017
There are numerous method of depreciating the fixed assets. One of them is Double declining balance. In our earlier post regarding double declining,we learnt how to do it using manual work. But, now our focus is to use Microsoft Excel to work out all the calculation for DDB depreciation. We use the ...
last updated on 02-Dec-2017
Microsoft Excel plays a key role in our daily finance and accounting task. That is why; it is true to say that it is the best supporting tool for an accountant and finance professional. People often takes loan from banks and financial institutions, over which they have to pay certain amount of inter...
last updated on 06-Dec-2017
Counting data in MS Excel is not a difficult task. Whatever the data is and whatever your report requirement is, you can simpoly do it via COUNTIFS functions. There is no need to do this via Excel macros. Lets suppose you have many data available in Excel sheet with dates like this: Formula =COUNTIF...
last updated on 17-Dec-2017
There are circumstances under which you have to represent data in range form. In this case, you can take support from COUNTIFS formula to represent any set of data in a range format. Most of the common situation of this arises when for example, Excel sheet contains marks obtained by students in the ...
last updated on 17-Dec-2017
3D sum functionality in Excel is quite awesome feature which simplifies the lengthy process. If used wisely, you can ease your task in spreadsheet. In order to understand the use of 3D Sum, first you need to look at the formula below: =SUM(English:SST!E7) Actually, there are several wordsheet on dif...
last updated on 19-Dec-2017
To count specific text in Excel is not a difficult task. It can be done via the famous COUNTIF formula. Previously, we have used COUNTIF formula under two cases as follows: How to Count Cells between Two Numbers in Excel Count the Number of Excel Records That Fall Between Two Dates How to Count Spec...
last updated on 19-Dec-2017
Excel conditional formatting is an invaluable tool that allows the clear identification of various types of data. In fact, it saves a lot of time in making your raw data into information for easy decision making. If you are able to harness the power of conditional formatting, then chances are damn s...
last updated on 11-Aug-2018
There are so many occassion where you have to obtain data from databases. When you copy paste these types of data, your Excel work sheet looks ugly as there are numerous spaces found in the cells. Removing the trailing spaces between numbers and text looks daunting task. However, thanks to Microsoft...
last updated on 18-Aug-2018