Excel Tricks with Tejraj

Have you ever thought that you can calculate your age with the help of Excel?? Well.. It is absolutely possible and Excel can calculate your age… but how?? Let’s learn through this blog post. To calculate age, we can use DATEDIF function in excel. (We have already posted separate blog on this topic and if you want to learn in detail about DATEDIF function in excel, you can click here .) For this we have to provide two inputs: 1. Date of Birth and 2. Today’s Date In below image, we have entered first input i.e. Date of Birth in cells “A2” and second input i.e.  Today’s Date in cell “B2”. With the help of these two dates, we can: 1. Calculate the age in Years, 2. Calculate age in Years & Months 3. Calculate age in Years, Months & Days Calculate Age in Years: 1. We want to calculate age in years in cells “C2”, so we have to select cell “C2”. 2. Enter below formula in cell “C2”      =DATEDIF(A2,B2,"Y") 3. After entering the formula, we have to just press “Enter...

In our previous blog post we have seen few options from "GoTo Special" dialog box in Excel (Click here to read about GoTo Special in Excel Part 1 ). In this blog post we will see remaining options. Column differences: This option will help us to select the cell values which are different that selected  cell  value in respective column. 1. We have listed few numbers in a column as shown in below image. Now we have selected entire range and the  cell  value which is selected in this cell range is from cell address “B2” (We can see the cell address in Name Box and value from this cell address in Formula Bar ). 2. Select option “Column differences” in “GoTo Special” dialog box and click on “OK” button. 3. As a result we can see that all the cell values which are different that cell value in cell “B2” will get selected. Precedents (Direct only, All levels): This option will help us to select the all the cells which are involved in the formula applied in currentl...

Previously we have learned about “ Find & Select Commands ” in excel ( Click here to read more on this). In that post we have already seen various methods to get “GoTo Special” dialog box. This “GoTo Special” dialog box will look like as shown in below image. We will learn how to use all the options which are available in this "Go To Special" dialog box. These options are: 1. Comments 2. Constants (Numbers, Text, Logicals, Errors) 3. Formulas (Numbers, Text, Logicals, Errors) 4. Blanks 5. Current region 6. Current Array 7. Objects 8. Row difference 9. Column differences 10. Precedents (Direct only, All levels) 11. Dependents (Direct only, All levels) 12. Last Cell 13. Visible cells only 14. Conditional Formats (All, Same) 15. Data Validation (All, Same) Comments: This option will help us to select all the comments from selected sheet. 1. Let’s say we have inserted few comments in our excel sheet as shown in below image. 2. Select option “Comments” in “GoTo Special” dialo...