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

Contents

Financial Ratios
Accounting Cycle
Accounting Principles
Financial Accounting Basics
Financial Statements Reporting
Bad Debts
Current Assets
Long-term Assets
Voucher System
Partnership
Depreciation
Work Sheet - 10 Column Work Sheet
Difference Between Reserve and Fund
Accounting for Leases
Capital reduction and reconstruction
Absorption of Company
Amalgamation
Accounting for Installment Sales
Basis of Recording Profit and Loss
Branch Accounting
Construction Contracts
Revenue Recognition
Accounting for Groups
Financial Analysis
Events After the Balance Sheet Date
Deferred Tax
Cost Accounting
Activity Based Costing (ABC)
Throughput Accounting
Relevant Cost
Break Even Analysis
Standard Costing
Inventory Management
Payroll Accounting
Royalty Accounting
Statistics
Master Budget
Salary Income
Microsoft Excel Tutorial
Other Topics
Share or Stock Valuation Model
Financial Management Topics
Kinds of Endorsement
Letter of Credit, Kinds and Its Advantages/ Utilities
Modern Functions of a Commercial Banks
Difference Between Secured And Unsecured Loan
Excel conditional formatting red if negative green if positive
How to Remove Extra Spaces in Excel