Advanced Excel Xls Download

Learn Advanced Excel,
Advanced pivot, chart, macros
Lookup, vlookup,
lookups with if,
lookupss with match their usage,
lookup a value in multiple tables, lookup with array,
and many more advanced topic.....
feel free to call for further clarification :9371235712

good dout
dear roopa garu
vlookup is used lot of excel sheet deta calculating purpose
for example
emp pls calculation based on total year attendance purpose and total monthelay attendance calculation for year persentage etc

Hi Mahesh,
I am Pune based free lancer, usually i do corporate workshops(at client's place) in mumbai/ hyderabad, banglore also......

Hi Vijayojili,
see the current attachment,
IN this file if you entered the salary, the tax deduction is to be calculated with the help of vlookup,
For tax deduction depends on salary limits, i will say ranges, we have given 4 ranges
Income
greater
Than <= Tax Rate
$0 $2,650 15.00%
$2,651 $27,300 28.00%
$27,301 $58,500 31.00%
$58,501 $131,800 36.00%
$131,801 $284,700 39.60%
In such cases we have to find the result in range, not the exact value,
suppose my income is 25000, which is not mentioned in table, but is betn 2651 to 27300 so tax rate should be 28%,
In such cases,
vlookup(lookupvalue, table array, column index no, [is it range lookup])
consider last arument that is : [is it range lookup], if yes then put their 1 or true, otherwisw it is a exact lookup, then it will be 0 or false,
plz reply if u persist any prblm,
Roopalee

make your table like this
$2,650 15.00%
$27,300 28.00%
$58,500 31.00%
$131,800 36.00%
$284,700 39.60%
$284,701 45.25%
and use vlookup on and use 1 instead of 0 for approximate match please try this

My partner and I have begun offering full time business and training services to organizations and individuals. In case our services match with any of your current or future requirements, we would appreciate the opportunity to demonstrate our capabilities and commence a working relationship.
Areas:
• Excel
• Word
• PowerPoint
• Outlook
Features:
• Professional trainer
• Customized programs
• Multiple software versions
• Beginner, intermediate and advanced
• Individual and group sessions
• Flexible timings and venue
We endeavor to become your knowledge sharing partner and firmly believe in providing quality services at reasonable rates. We look forward to creating and fostering a win-win association for all stakeholders.
in.linkedin.com/in/jshridhar2011/