hr人士要掌握的excel漢字轉(zhuǎn)拼音方法及步驟

《hr人士要掌握的excel漢字轉(zhuǎn)拼音方法及步驟》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。

1、HR人士要掌握的EXCEL漢字轉(zhuǎn)拼音方法及步驟HR人士在工作中管理員工的數(shù)據(jù)，如果是在歐美外企，因?yàn)閲饪偛客ǔ枰獙h字員工的信息轉(zhuǎn)換成拼音，將這些信息錄入存儲在人事系統(tǒng)中，或者以人事報(bào)表形式將拼音信息匯報(bào)給總部。因?yàn)閱T工數(shù)據(jù)通常會用EXCEL統(tǒng)計(jì)，掌握EXCEL漢字轉(zhuǎn)拼音，會大大提高辦公效率。最常用的操作是員工姓名，家屬姓名漢字轉(zhuǎn)拼音等。下面以名字的轉(zhuǎn)換為例子，介紹EXCEL中漢字轉(zhuǎn)拼音方法的兩個(gè)主要步驟：*在EXCEL中設(shè)定漢字轉(zhuǎn)拼音的自定義函數(shù)=Pinyin().*通過EXCEL中自帶函數(shù)與自己設(shè)定的漢字轉(zhuǎn)拼音自定義函數(shù)組合，將目標(biāo)漢字轉(zhuǎn)換成拼音，再復(fù)制粘貼保

2、存到合適位置。Excel中設(shè)定自定義函數(shù)=Pinyin().的步驟：1.新建一個(gè)新的Excel文件，打開顯示出工作表；2.按“Alt+F11”組合鍵，進(jìn)入VisualBasic編輯狀態(tài)；3.再按“F7”鍵，進(jìn)入模塊代碼編輯狀態(tài)；4.將下面的代碼，復(fù)制粘貼到模塊代碼編輯中；FunctionPinYin(HzAsString)DimPinMaAsStringDimMyPinMaAsVariantDimTempAsInteger,iAsInteger,jAsIntegerPinMa="a,20319,ai,20317,an,20304,ang,20295,ao,20292,"

3、PinMa=PinMa&"ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,"PinMa=PinMa&"ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,1972

4、5,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,"PinMa=PinMa&"da,19218,dai,19212,dan,

5、19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,"PinMa=PinMa&"e,18710,en,18697,er,18696,"PinMa=PinMa&"fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng

6、,18463,fo,18448,fou,18447,fu,18446,"4PinMa=PinMa&"ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,"PinMa=PinMa&"ha,17922,hai,17759,han,17752,h

7、ang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,"PinMa=PinMa&"ji,17417,jia,17202,jian,17185,jiang,16983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,1670