Hasaan Fazal
What is Working Capital?
Putting mathematics in words, working capital is entity’s investment in current assets. Usually we use working capital as a measure to determine entity’s ability to coup efficiently with its liabilities. Most of the time this term is used to mean net working capital which is expressed as: current assets - current liabilities. But remember net working capital […]
30+ Copy & Paste Tricks You Must Know - Mouse Keyboard Autofill Paste Special and More!
Ctrl+C & Ctrl+V - The Saga continues! For sure Ctrl+C and Ctrl+V is one of the most famous keyboard shortcut in windows environment and one big reason for it become famous beyond limits is that it can be used in almost every Windows application software including Microsoft Excel. You might know how to do copy […]
Making Aging Analysis Reports Using Excel - How To
Aging analysis is helping accountants since ages and beyond doubt this is one the those reports that are prepared almost every period to track both receivables and payables. If you want to learn more about aging or ageing analysis do read my explanation: What is age, aged, ageing or aging analysis? If you are new to […]
Diploma in IFRS - Free Study Material Now Available
Free Resources for Diploma in International Financial Reporting Standards (DipIFR) Diploma in IFRS is offered by many institutes around the world. But the most sought after is the one offered by ACCA body. ACCA named this diploma as Diploma in International Financial Reporting (DipIFR). To aid best students and professionals preparing for DipIFR by ACCA, […]
9+ Ways to Fail Your Interview - Killer Mistakes You Must Avoid
Rejected once again? Then its time to sit down and think why you are not the one. Candidates often concentrate on putting more and more meat in their CV but forget about the bones. We looked at 9 killer interview mistakes that choke your chances to get hired! 1. Forgetting formidable formalities - resume, CV, cover […]
Select Entire Rows of Multiple Selected Cells - Calling VBA + Macros in Action
I never imagined that my first article involving VBA will be this short. And I kept myself from diving into VBA and Macros until now so that I stay basic and all my dear readers and followers get to know the basics first. But this time I had to call the real army in! So […]
Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature of facility so that it is kept in the range good for human life. Now we want to count the number […]
5 Ways to Transpose in Excel - Shifting Columns to Rows or Rows to Columns
One of our community member asked how to convert rows to columns or make columns as rows in Excel quickly without using pivot tables? Many already know how to do this. But for those who don’t this one minute Excel tutorial is for them. By the way, yes! you can use pivot tables to shift […]
Create Edgy To-Do or Check Lists with Check boxes in Excel + Shortfall calculator
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you. As I teach ACCA and other professional qualification students and at the same time teaching several subjects it is […]
Changing numbers Sign in Excel - From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive to negatives. Although this is hardly the case in many situations that you really want an additive inverse for each and […]
