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.
How To Easily Calculate Straight Line Depreciation in Excel
Straight Line Depreciation is a is a method uniformly depreciating an asset over the period of its usability.
How To SUM Filtered Data Using SUBTOTAL Function In Excel
Did you know that you can use the SUBTOTAL Function to SUM filtered data in Excel? We all know filtering of data using either by inserting tables or by using filter feature in Sort and filter group. For general adding operation, we use SUM Function. But when we filter the data the total displayed is […]
Create A Drop-down List in Excel In Just 3 Easy Steps
There is a myth related to creating a drop-down list in excel. It is often considered something hard and only for professionals. I myself had such silly conception when I started learning excel about a decade ago. No, it is not at all correct. You can create a Drop-down list in just 3 easy steps […]
Microsoft Excel 2011 Keyboard Shortcuts for MAC
Today in this article, we have compiled Excel 2011 Keyboard shortcuts for MAC for our readers. As we know today use of smartphones, tablets and smart PC has increased. Similarly, use of MAC based PC and laptops of Apple Inc. has also increased. Earlier, there were very few peoples using the products with MACINTOSH. Now […]