Articles by @VaibhavJ

View Full Profile

Time Management for Student

Posted by @VaibhavJ 21 October 2016 30606 Views

All that you don't know about time management & never ever thought of this about time management

Sumproduct - Advance Excel Formula

Posted by @VaibhavJ 23 September 2014 14355 Views

SUMPRODUCT –an advance excel formula The SUMPRODUCT function multiplies the corresponding items in the arrays and returns the sum of the results. SYNTAX The syntax for the Microsoft Excel SUMPRODUCT function is: SUMPRODUCT( array1, array2, ...

Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108119 Views

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

Excel function VLOOKUP

Posted by @VaibhavJ 11 September 2014 50206 Views

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

Advance Excel function - Indirect()

Posted by @VaibhavJ 04 September 2014 32995 Views

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

How to reset Income Tax Efiling Password Quickly

Posted by @VaibhavJ 22 October 2013 200295 Views

Since we are not required to access E-Filing website as human we tend to forget its Login Information & Password. So let see how you can retrieve login details step by step. First you need to

A Beginners Guide to Job Hunting

Posted by @VaibhavJ 15 October 2013 11227 Views

After applying for hundreds of jobs that you was qualified for, receiving no responses & two rejection letters you feel unemployable. How does one deal with the: Feeling of disappointment? The lack of support? The ag

Exam Tips for Quick Memorising

Posted by @VaibhavJ 09 October 2013 128095 Views

Exams are nearing day by day & tension is rising eventually causing bad memory & loss of concentration. Here goes quick Tips for memorizing the material as quickly as possible. (Please note if you are appearing in Nov13 exams & if thi

Wake up Future CA

Posted by @VaibhavJ 30 September 2013 15800 Views

Are you still procrastinating? Yeay.. Its common phenomena for any student. Book in one hand and Smart phone in second to check updates on Social Websites. Parents pushing for studying hard but we are not bothered about them. We jump to study tabl

FAQ - Deduction for Interest on education Loan

Posted by @VaibhavJ 03 March 2013 15803 Views

Q. Who is eligible for deduction us/ 80E? A. Education loan should be taken by Individual (not to HUF or other type of Assessee ) Q. Is loan taken in name of any family member is eligible fo