# Articles by @VaibhavJ

#### Time Management for Student

##### @VaibhavJ    21 October 2016 at 12:51

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

Posted in Others  4 comments |   18936 Views

#### Sumproduct - Advance Excel Formula

##### @VaibhavJ    23 September 2014 at 13:24

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

Posted in Info Technology  1 comments |   13710 Views

#### Reverse/Backward VLOOKUP - Advance Excel function

##### @VaibhavJ    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

Posted in Info Technology  7 comments |   106665 Views

#### Excel function VLOOKUP

##### @VaibhavJ    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

Posted in Info Technology  17 comments |   46974 Views

#### Advance Excel function - Indirect()

##### @VaibhavJ    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

Posted in Info Technology  17 comments |   32229 Views

#### How to reset Income Tax Efiling Password Quickly

##### @VaibhavJ    22 October 2013 at 12:35

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

Posted in Income Tax  18 comments |   199188 Views

#### A Beginners Guide to Job Hunting

##### @VaibhavJ    15 October 2013 at 11:37

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

Posted in Career  14 comments |   10938 Views

#### Exam Tips for Quick Memorising

##### @VaibhavJ    09 October 2013 at 12:37

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

Posted in Students  88 comments |   126960 Views

#### Wake up Future CA

##### @VaibhavJ    30 September 2013 at 12:37

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

Posted in Students  127 comments |   15447 Views

#### FAQ - Deduction for Interest on education Loan

##### @VaibhavJ    03 March 2013 at 15:37

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

Posted in Income Tax  6 comments |   15528 Views

CCI Articles