Articles by @VaibhavJ

View Full Profile

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

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

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

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

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

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

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

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

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

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