We use auto filters to filter subsets of data in Excel, but this filtering is limited to actual data. We can use Advanced Filter feature to filter multiple columns with different criteria. Understanding with an example will be easy. Open a workbook in Excel and copy below data into the sheet. You can also use […]
We require calculating the difference between two dates for many purposes in our daily life. Excel consist of many functions that easily calculate the difference between two dates. Mostly this difference is required for Payroll purpose for calculating the number of days worked in a month for preparing salaries. In Accounting, it is required for […]
In Excel, it is possible to insert rows in multiple sheets all at once. You don’t need to edit or insert the rows individually to every sheet. If there are multiple sheets, this becomes a tedious job. Thus, we need to find an easy way to do this action. You can insert rows in multiple […]
Personal Accounts: Receiver = Debit and Giver = Credit. Real Accounts: What comes in = Debit and What Goes out = Credit. Nominal Accounts: Expenses/Losses = Debit and Incomes/Gain = Credit.
Straight Line Depreciation is a is a method uniformly depreciating an asset over the period of its usability.