Hi Keyran Very useful Gist. Can you pl. further guide as to how to write syntax for various functions eg VLOOKUP, HLOOKUP etc. Is there any logical order ? Pl advise . CVH
From India, Mumbai
5From India, Mumbai
thanks for the share..could any one bring out the excel 07 e-book itself.it would be helpful for us and for the knowledge/learning sharing guys also..
From India, Bangalore
From India, Bangalore
Hi Keyran, its indeed a very good file...very helpful...PFA another one on the same lines... Nisha
From India, Mumbai
From India, Mumbai
[QUOTE=cvh;956617]Hi Keyran
Very useful Gist.
Can you pl. further guide as to how to write syntax for various functions eg VLOOKUP, HLOOKUP etc.
Is there any logical order ?
Pl advise .
Hey,
I have attached the syntax for Lookup (Lookup,Vlookup and Hlookup)
I use this extensively.
Cheers,
Keyran
From India
Very useful Gist.
Can you pl. further guide as to how to write syntax for various functions eg VLOOKUP, HLOOKUP etc.
Is there any logical order ?
Pl advise .
Hey,
I have attached the syntax for Lookup (Lookup,Vlookup and Hlookup)
I use this extensively.
Cheers,
Keyran
From India
Many Many Thanks Keyran for share this.
Can you give us a useful formula to calculate the days. I mean how many days passed from 10.02.2008 to 20.11.2009. I just want to know that how can we calculate the days eaisely for counting any period.
Hope you can this. Awaiting.
With best regards,
Aazad
From India, Vijayawada
Can you give us a useful formula to calculate the days. I mean how many days passed from 10.02.2008 to 20.11.2009. I just want to know that how can we calculate the days eaisely for counting any period.
Hope you can this. Awaiting.
With best regards,
Aazad
From India, Vijayawada
thanks dear for shareing this type of valuable concept with us.Its realy very helpful to adopt the same.I have a request for you and that is If you have any concept of excel VLOOK UP & HLOOK UP THE N PLEASE SEND IT TO MAY MAIL ID .amitbanerjee52@yahoo.com/amit.banerjee@tmscl.com
Thanks
Amit
From India, Calcutta
Thanks
Amit
From India, Calcutta
Iam a Buss Analyst and work on excel for most of my calculations. so I keep on exploring. Cheers, Keyran
From India
From India
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls