Whenever a firm is done with its sales target, the next thing in the queue is how long it will take to get the receivables from the customers. Accounts Receivable and hence Accounts Receivable Aging is important because they form an important part of the Cash Conversion Cycle for a company and is critical to maintain the liquidity of the company as well as to avoid cost of … [Read more...]
7 Things CPA Should know about VBA Macros
VBA stands for visual basic for application. It is the default programming language for MS Office. If you want to program MS Excel you should know how to work with VBA Macros. VBA is at the same time is fun and a source of improving productivity. Actually it provides an opportunity to do things what canot be done in usual way or to have features that are not available by … [Read more...]
Managing attendance with Excel zoom’s Attendance Template
Managing attendance of staff is a very critical issue, be it a manufacturing firm or a service firm. There are several tools out in the market to manage this function. This ranges from the simple spreadsheets to ERP system that is very complicated and are extremely reliable. We at Excel zoom have produced a simple template to monitor the attendance of employees. This is a MS … [Read more...]
Remove All Rows Containing Certain Data
Recently I had some data from a website that was poorly formatted, but I needed to get it into a spreadsheet to work with. When I copied the data into the spreadsheet, I needed to remove all of the rows that contained certain irrelevant data, such as repeated header fields. Other use cases might require you to delete any rows containing someone's name, a location, or some … [Read more...]
Using Userform and VBA to get Dynamic Data Validation
Lists are one the commonly used features of Excel. We use them to choose amongst the already selected choices and to avoid repetitive typing. One of the methods to do this is to use Dropdown menu from the Data Validation Option under Data Tab. Though this is realistic and practical option it lacks one feature that I really need – auto completion. If it has been present to … [Read more...]