Home > Articles > Info Technology

Please Wait ..

to your account


Remember Me

Forgot your password?

Sign-up now

Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.

Browse Articles Info Technology Articles

Displaying 1 - 10 of 36 in 4 pages

Automated Prepaid Expenses JV in Excel

By Ramkrishna Mokashi On 18 September 2014 at 12:24

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...

Continue Reading

1 comments | 3545 hits

Reverse/Backward VLOOKUP - Advance Excel function

By @VaibhavJ On 15 September 2014 at 10:50

Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab...

Continue Reading

4 comments | 5060 hits

How to make VLookup Foolproof

By Ramkrishna Mokashi On 12 September 2014 at 10:44

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...

Continue Reading

27 comments | 9225 hits

Excel function VLOOKUP

By @VaibhavJ On 11 September 2014 at 10:36

1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of...

Continue Reading

15 comments | 10565 hits

Advance Excel function - Indirect()

By @VaibhavJ On 04 September 2014 at 11:23

To understand benefit of indirect function do as I say. Put 100 in cell A1, now in Cell D1 put formula =INDIRECT("A1") & in cell D2 put formula =A1. Result is same in both case then why to put confusing formula in cell D2? Now select ...

Continue Reading

17 comments | 7329 hits

5 advantages of using cloud accounting software

By guru On 08 July 2014 at 12:23

Any business can be managed efficiently by using business automation software. There are 2 types of software which a business owner can utilize namely Desktop software and Online software (Cloud software). Traditionally Indian companies have been use...

Continue Reading

0 comments | 2370 hits

Online Banking Payments Process: Bank Vs Merchant

By Bhargav Nathwani On 16 June 2014 at 12:29

Today online banking transactions are essential part of any business activity. Most of the people always feel bubbles in stomach ...

8 comments | 1706 hits

All about Cloud Computing

By smit shah On 02 May 2014 at 11:13

Cloud computingToday is the age of information technology. The facets of work and personal life are moving towards the concept of availability of everything online. Understanding this trend, the big and giant web based companies like Google, Amazon,...

Continue Reading

7 comments | 4063 hits

Bitcoin - Something New

By SATISH JAJANI On 22 August 2013 at 12:33

Introduction:Making payment is one of our routines and its mode has changed very drastically. Initially there was barter system then we moved from gold/silver coins for making payments, to paper currency, plastic money and finally electronic payment....

Continue Reading

11 comments | 1894 hits

Cheque Truncation System: Digitisation in Banks

By R. Sudarshan Bala On 28 December 2012 at 12:00

CHEQUE TRUNCATION SYSTEM: A TOOL REQUIRED FOR DIGITISATION IN BANKS As we all know the environment around us is highly dynamic and volatile which necessitates continuous updation and improvement in order to survive competitively. The ...

Continue Reading

60 comments | 7827 hits

Quick Links


Browse by Category

back to the top