Dear all, I am attaching a excel file which is very useful for both finance & hr depts. It has all the set of functions which are used in excel. :) thanking you skm
From India, Bangalore
3From India, Bangalore
I have a specific need to convert the rs. value in to words. Does any has any formulae for it. It is ok even if it is in access or excel. Thanks sekar
From India, Madras
From India, Madras
Hi SKM,
This is really fantastic one ..
I always wanted a consolidated means to learn all excel formulas &
Wow I think I got it now. Pls keep helping like this.
Thanks a bunch, Can't Thank you enough :)
Cheers.
From India, Madras
This is really fantastic one ..
I always wanted a consolidated means to learn all excel formulas &
Wow I think I got it now. Pls keep helping like this.
Thanks a bunch, Can't Thank you enough :)
Cheers.
From India, Madras
Hi Team,
Please let me know the way , how can I will be updated with all notification releted to the Human Resource:idea: like ESI,PF, Minimum Wage and labour law ammendement etc
Thanks & Regards
Anuj Chaurasia
From India, Gurgaon
Please let me know the way , how can I will be updated with all notification releted to the Human Resource:idea: like ESI,PF, Minimum Wage and labour law ammendement etc
Thanks & Regards
Anuj Chaurasia
From India, Gurgaon
Excellent work boss. Really superb and good education to all who’d like to excell in excel. Fantastic post and thanks for a yeoman service. Kudos. Regards Hanumantha Rao
From India, Hyderabad
From India, Hyderabad
Thank you execellent
Dr. H.K.LakshmanRao
A. Educational
v Ph.D. (Management)
v M.Phil(Statistics)
v M.Sc(Psychology)*
v Master’ Degree in Statistics ( MysoreUniversity)
v Master’s Degree in Public Administration( MadrasUniversity
v Master’s Degree (Distance Education-IGNOU)
v Master’s Degree ( Rural Development)
v DDE(IGNOU)
v PGD in Operation Research & SQC (ISI)
B Participated in M.D.P. of:
v Indian Institute of Management, Ahmedabad
v Indian Institute of Management, Bangalore
v Indian Institute of Management, Calcutta
v Administrative StaffCollege, Hyderabad
v XLRI, Jamshedur/Indian Institute for Public Administration, New Delhi
v School of BusinessManagementUniversity of Hawaii, Honolulu (USA)
C Professional Training / Research
v Marketing Management
v Management Information Systems (MIS)
v Distribution Management / Logistics Systems
v Rural Marketing / Agricultural Marketing
v Quantitative Techniques / Operations Research
v Human Resources Development / Management
v Business Policy / Corporate Management / Strategic Management/Soft- Skills
D Major Assignments
v Research Fellow (Sr. Professor of International Study at WestCenter, Honolulu, Hawaii (USA) on four the and half year study on “Fertilizer Marketing Systems” in South East Asian Countries.
v Associated with the “Study on Urban Employment Generation” Sponsored by World Bank.
v FAO / Bay of Bengal project “Development of Micro Enterprises” *Australia India International Education Foundation. Australia- India Higher Education programs
E Visiting Faculty / Member Board of Studies / Examiner / Project Guide
v University of Hawaii (School of Business Management), USA/ University of Hyderabad
v University De Paris- Department of Management/ Switzerland school of Hotel Management/ LondonBusinessSchool
v London School of Business Administration, University de Paris, Swiss School of ManagementSwitzerland
v IIM.Birla Institute of Technology & Science (BITS), Pilani (Rajasthan)
v Ashok Leyland, Management Development Centre
v Ambedkar Institute of Management Studies (AIMS), Vishakapatnam
v Indian Bank Staff Training College, Chennai/Doddaappa Appa Institute for M.B.A , Gulbarga
v Spic – ManagementDevelopmentCenter, Chennai / Kodaikanal
v All India Management Association (AIMA), Delhi & Madras Management Association(MMA)
v Anna Institute of Management (Tamilnadu Govt.), Chennai
v Institute for Financial Research and Management (IFMR), Chennai
v National Institute of Agricultural Extension Management( MANAGE), Hyderabad
v MadrasSchool of Management Science (University of Lincon of Lincon Shire, London)
v Vizag Steel Plant, Visakhapatnam
Modular programs offered: Statistical methods in Management, OR/SQC, Marketing Research, Project Management, SOFT- SKILLS, Rural Marketing, Corporate Social Responsibility(CSR),Time Management ,SCM,CRM,FTMP, TQM
F Corporate Clients include: ITC, HCL-T, VIZAG STEEL LTD, TATA –Chem. NTPC, MANAGE, TNPL IFFCO, APSRTC, EID, , BHEL.,
G Guide / Examiner : Ph.D. of MadrasUniversity, Pondicherry , BITS & other Several Universities
H Alumnus of:
v Indian Institute of ManagementAhmedabadEastWestCenter, Honolulu, Hawaii (USA)
v Fulbright Scholar (USA)
I Publications:
One hundred and seventy Seven papers(seminar/Workshop, conferences/Journals/magazines) and four books, Development of sides and Modules for M.B.A on Management Statistics for Managers. Presented papers on Management Education & Operations Research at several National, International seminars. Speaker/ interviewer-CVC Radio Australia, ALL India Radio
J Countries Visited:
v USA, UK, Malaysia, Singapore, Japan, Thailand, Nepal, Pakistan , Srilanka., Rome, Paris, Switzerland,,Netherlands
v Modular Programs offered: QM for Management, Research Methodology, Marketing Research, Rural Marketing, Soft- Skills, SQC Techniques, CSR, SCM, CRM, Time Management, Placements for MBA,
K Contact : “Anugraha”, 33, Krishapuri, R.A.Puram, Chennai – 600 028
Ph: 044-43060656 . Mobile:9381036989/ email:hklrao@gmail.com, * in prorgress
From United States
Dr. H.K.LakshmanRao
Dr.H.K.Lakshman Rao Ph.D. (Mgmt.),M.Phil (Statistics)
M.Sc(Stat), M.A(D.Edn.),M.A(Pub.Admn),M.A(R.D) M.Sc(Psy), OR & SQC (ISI.),AMP (IIM-A), DDE.
(Former Gen. Manager MFL & Professor & Head Dept. of Management CEC)
Management, Corporate & Statistical Consultant - World Bank Aided Projects
“ANUGRAHA”, 33, Krishnapuri, R.A.Puram, Chennai – 600 028
Ph: 044-43060656, M: 09381036989, e-mail: hklrao@gmail.com
A. Educational
v Ph.D. (Management)
v M.Phil(Statistics)
v M.Sc(Psychology)*
v Master’ Degree in Statistics ( MysoreUniversity)
v Master’s Degree in Public Administration( MadrasUniversity
v Master’s Degree (Distance Education-IGNOU)
v Master’s Degree ( Rural Development)
v DDE(IGNOU)
v PGD in Operation Research & SQC (ISI)
B Participated in M.D.P. of:
v Indian Institute of Management, Ahmedabad
v Indian Institute of Management, Bangalore
v Indian Institute of Management, Calcutta
v Administrative StaffCollege, Hyderabad
v XLRI, Jamshedur/Indian Institute for Public Administration, New Delhi
v School of BusinessManagementUniversity of Hawaii, Honolulu (USA)
C Professional Training / Research
v Marketing Management
v Management Information Systems (MIS)
v Distribution Management / Logistics Systems
v Rural Marketing / Agricultural Marketing
v Quantitative Techniques / Operations Research
v Human Resources Development / Management
v Business Policy / Corporate Management / Strategic Management/Soft- Skills
D Major Assignments
v Research Fellow (Sr. Professor of International Study at WestCenter, Honolulu, Hawaii (USA) on four the and half year study on “Fertilizer Marketing Systems” in South East Asian Countries.
v Associated with the “Study on Urban Employment Generation” Sponsored by World Bank.
v FAO / Bay of Bengal project “Development of Micro Enterprises” *Australia India International Education Foundation. Australia- India Higher Education programs
E Visiting Faculty / Member Board of Studies / Examiner / Project Guide
v University of Hawaii (School of Business Management), USA/ University of Hyderabad
v University De Paris- Department of Management/ Switzerland school of Hotel Management/ LondonBusinessSchool
v London School of Business Administration, University de Paris, Swiss School of ManagementSwitzerland
v IIM.Birla Institute of Technology & Science (BITS), Pilani (Rajasthan)
v Ashok Leyland, Management Development Centre
v Ambedkar Institute of Management Studies (AIMS), Vishakapatnam
v Indian Bank Staff Training College, Chennai/Doddaappa Appa Institute for M.B.A , Gulbarga
v Spic – ManagementDevelopmentCenter, Chennai / Kodaikanal
v All India Management Association (AIMA), Delhi & Madras Management Association(MMA)
v Anna Institute of Management (Tamilnadu Govt.), Chennai
v Institute for Financial Research and Management (IFMR), Chennai
v National Institute of Agricultural Extension Management( MANAGE), Hyderabad
v MadrasSchool of Management Science (University of Lincon of Lincon Shire, London)
v Vizag Steel Plant, Visakhapatnam
Modular programs offered: Statistical methods in Management, OR/SQC, Marketing Research, Project Management, SOFT- SKILLS, Rural Marketing, Corporate Social Responsibility(CSR),Time Management ,SCM,CRM,FTMP, TQM
F Corporate Clients include: ITC, HCL-T, VIZAG STEEL LTD, TATA –Chem. NTPC, MANAGE, TNPL IFFCO, APSRTC, EID, , BHEL.,
G Guide / Examiner : Ph.D. of MadrasUniversity, Pondicherry , BITS & other Several Universities
H Alumnus of:
v Indian Institute of ManagementAhmedabadEastWestCenter, Honolulu, Hawaii (USA)
v Fulbright Scholar (USA)
I Publications:
One hundred and seventy Seven papers(seminar/Workshop, conferences/Journals/magazines) and four books, Development of sides and Modules for M.B.A on Management Statistics for Managers. Presented papers on Management Education & Operations Research at several National, International seminars. Speaker/ interviewer-CVC Radio Australia, ALL India Radio
J Countries Visited:
v USA, UK, Malaysia, Singapore, Japan, Thailand, Nepal, Pakistan , Srilanka., Rome, Paris, Switzerland,,Netherlands
v Modular Programs offered: QM for Management, Research Methodology, Marketing Research, Rural Marketing, Soft- Skills, SQC Techniques, CSR, SCM, CRM, Time Management, Placements for MBA,
K Contact : “Anugraha”, 33, Krishapuri, R.A.Puram, Chennai – 600 028
Ph: 044-43060656 . Mobile:9381036989/ email:hklrao@gmail.com, * in prorgress
From United States
Hi All, I too have a file from where you can learn more about Excel. Regards, Jeni
From India, Bangalore
From India, Bangalore
pls some one help me to provide an idea about how to prapare my employee database.. Abhishek
From India, Lucknow
From India, Lucknow
Hi SKM,
I got the same problem as some others, cannot access the file coz of some error. Not sure becoz of what. I would really appreciate it if u could email to me to
. It seems from the response that the 'formula' is very useful. I dont wanna miss it.. Thanks a lot
I got the same problem as some others, cannot access the file coz of some error. Not sure becoz of what. I would really appreciate it if u could email to me to
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.
Jadu File - Excel Help.xls
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