Calculating Depreciation of assets in Excel - How to
In accounting world depreciation is one key calculation to be done for every period to make the reports and is also an important part of financial management decision making process in some cases. However, depreciation calculations can sometimes be tedious and long if we have to do it for multiple classes of assets for multiple […]
Running totals and Running balance in Excel - How to
On daily basis accountants prepare day books and ledgers as regular part of accounting cycle. Usually students in the beginning learn to prepare accounts in T format. However, professional accountants maintain accounting books in dedicated accounting software in which bookkeeping is a little different. If accounts are maintained using T format then user can know […]
Microsoft Excel Keyboard Shortcuts - Mega Collection
Microsoft Excel’s best side is its shortcuts. These are pure productivity enhancement toppings that everyone craves to learn and know as many as they can as they not only speeds up things but also gives you freedom of multiple input devices at one time. The following collection of shortcuts is still a work in progress. […]
Multi level or Multi column sort in Excel - How To
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our own criteria of cities that was not alphabetical. That helped us having data of cities first that are more important to […]
Custom Autofill series and Custom sorting with Custom lists in Excel
If you are already using some of Excel’s custom features then you probably are already in love with them. Few days back we discussed custom views option and how it can help us. Today we have another custom feature of Excel - Custom Lists. Custom lists helps us notably in two ways: by having our […]
Absolute or Static structured references in Excel table - How to
Just a quick note on how to do absolute referencing if you are using structured references in Excel tables. For the ones who are not familiar with structured references and tables, your tutorial is baking and you will surely be able to catch up afterward. Referencing - A quick review Those who know structured references […]
Understanding Custom Views in Excel
Excel is all about flexibility. With all the built in features there is just endless possibilities the way you can use this marvelous application software. But Excel extends the flexibility even further through custom features. And I recommend every Excel user to know all such features that come with word “Custom” because it put you […]
Calculate number of Work Days in Excel using formula
Few days back I scribbled about calculating days between two dates and there I discussed DAYS360 formula method and one other common sense method to find out the number of days between two dates. But what if we want to find out working days between two dates and not just any days i.e. excluding weekends […]
How to sort Rows horizontally left to right instead of Columns vertically top to bottom in Excel
Sorting is one of the many good things excel offers. And it does make our job a lot easier once the data is arranged in particular order. However there is one limitation to the usual use of sorting i.e. it sorts in vertical fashion that is columns are sorted top to bottom in the order […]
How to convert numbers into words in Excel - VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words. Well I wasn’t paying attention to that part in the beginning. It don’t even cross my mind that there is no […]
