skm
3

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
Attached Files (Download Requires Membership)
File Type: xls Excel_Functions.xls (1.12 MB, 11375 views)

sekar_n
2

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
vhemant7
2

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
anuj_121082
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
turlapati24
2

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
HKLRAO
2

Thank you execellent

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
jeniamendoza
1

Hi All, I too have a file from where you can learn more about Excel. Regards, Jeni
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls excel.xls (1.50 MB, 637 views)

ashabhi0210@gmail.com
pls some one help me to provide an idea about how to prapare my employee database.. Abhishek
From India, Lucknow
Sahidi
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


Anurag Jain
34

Hi, Can anybody send the useful tips to connect two or more Excel Files to manage the working and reports. Regards anurag
From India, Jaipur
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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.