资源描述：
《excel在人力资源管理中的高效运用（the efficient application of excel in human resource management）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、Excel在人力资源管理中的高效运用（TheefficientapplicationofExcelinhumanresourcemanagement）[trainingnumber]:[trainingprogram]:Curriculumbackground?manypeoplehaveExcelintheuseofhumanresourcesmanagement,butdidnotreallygraspthedataanalysisandprocessingfunctionsofExcel,th
2、eworkingefficiencyislow,theothersafewminutestocompleteawagesummary,youneedhalfadayoreven1days.:howtodynamicallyunderstandtheinflowandoutflowofemployeesinordertograspthechangesinthecostofhumanresources;howtoanalyzechangesinemployeepaythisy
3、earsoastoprovideabasisforsalarycontrolnextyear;?everydayindealingwithemployeeattendance,everymonthtocalculatestaffattendance,tocalculatethestaffsalariesandbonuses,topay,topaytheaccuratepaymenttoeachemployeeaccounts,andpromptlynotifyeachemployee;?everyy
4、earthewholecompanyhundredsoreventhousandsofpeoplepaytogether,makingasummaryofJinhui,makingtaxwithholdingtables;?employeebirthday,contract,retirementdateiscoming,howtoadvancereminder,soasnottorush;newemployeesprobationperiodiscoming,howtotimelyremindemp
5、loyerssignedaformallaborcontract;:howtoevaluatethesalesperformanceofeachbusinesspersonandcalculatethesalaryaccordingtotheperformance;?suchquestions,andsoforth,arecomplexandtedioustoanyhumanresourcemanager.Youmustbetiredandbored!Doyouwanttoimprov
6、etheefficiencyofhumanresourcemanagement?Wanttomanagethehumanresourcesscientificallyinsteadofjustthinkingabouttheproblem?Trainingtarget:?mastertheuseofExceldatamanagement,processingandanalysisfunctions,includingcommonfunction,dataanalysismethodsandtechn
7、iquesfortheuseofmethods,PivotTableandchart,enhancetheExcelactualuselevelandtheabilitytorapidlyimproveworkefficiency.?masterthepracticalmethodsandskillsofregulatingandarrangingExcelforms.?concept,methodsandskillstomasterthedesignofscientificandstandardi
8、zedExcelmanagementaccountform,suchasdesign,structureform,datavalidity,useconditionalformatting,thefunctionanditsapplication,worktabledataregion,templateproductionoperationauthority.?throughtheanalysisofactualcase,thehumanresourcesmanage
