Save BIG on 2-Yr Ad-Free CAclubindia Pro Membership. Subscribe Now!

Articles by Ramkrishna Mokashi

Automated Prepaid Expenses JV in Excel

Posted by Ramkrishna Mokashi 18 September 2014 35095 Views

Hello All,Attached is a file which contains the automated prepaid calculation. No Hassles of working out how much is accrued, how much is pending, etc. Just Update the table in the first sheet. And rest will happen automatically. Of course, you are f

How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 41968 Views

In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get

Value Added by Finance

Posted by Ramkrishna Mokashi 10 December 2013 17658 Views

CAs are Cost Centers and MBAs are Profit Center.This is a discussion which has been going on for long. I am not going to share statistics on the values added by CAs and MBAs and compare with. Instead, I will share insights into what values a Finance