Salary, Investments, Taxable Income & Income tax calculator for the FY 2015-16 , i.e. AY 2016-17

Hii Friends,
Sharing an excel file prepared in a rush, but hope it will ease your income tax & salary calculation...

Please post your comments and inform for any errors found as it has not yet been tested for errors.

Download the excel utility from here https://drive.google.com/file/d/0Bw1qNoQ8YzHZbEpjMDJXVXZ6VTA/view?usp=sharing

Comments

Password Protect your USB Flash Drive without any software....

I was trying to protect my USB flash drive from a long time but didn’t find anything nice. Almost all the software were either not giving full features or were asking for money to do so and give full benefits. One software called Truecrypt was nice but not giving me simple password protection feature. Anyways, now I submit one good info with all who want to simply password protect their USB flash drive / pen drive without all unnecessary softwares. Steps to protect your USB flash drive 1. Insert your pendrive. 2. Open the drive 3. Create a folder (lets name is ABCD) and keep all your data in it. (You can partially protect this disk too by moving your important / secure data only into this folder) 4. Remember a password. Lets name is 12345 5. Now open a note pad and copy and paste the following text into it: -...

List out the details of files in a specified folder - automatically through excel without vba.

Hiii. I was preparing a list of files (govt. forms) but it was difficult to manually copy the file name and paste into the excel sheet as there are more than 300 files in that folder. After 8-10 copy paste I thought to do it automatically and the time saved is now used for writing this blog. LOL Well, You can actually automatically list out the names of files in a specified folder into excel, assume that in a school there are 1000 students and their admit card is in one folder.. and for some reasons you need to list out it into an excel sheet.. So how you will do it........... Here is a simple and superb way to do that........ These are the steps assuming your folder name is "Admit Card" and it is stored in D Drive... 1. Open a new excel file 2. Click on "Formulas" and then "Define Naem" 3. In the name field type AdmitCardList (You can put any other name also) 4. In refers to Column type: - =FILES("D:\Admit Card\*.*")&T(NOW...

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing

Bajrang Sharma

Search This Blog