涓�銆佽鏁版嵁鏄剧ず涓嶅悓棰滆壊
鍦ㄥ鐢熸垚缁╁垎鏋愯〃涓紝濡傛灉鎯宠鎬诲垎澶т簬绛変簬
500
鍒嗙殑鍒嗘暟浠ヨ摑鑹叉樉绀猴紝灏忎簬
500
鍒?/p>
鐨勫垎鏁颁互绾㈣壊鏄剧ず銆傛搷浣滅殑姝ラ濡備笅锛氶鍏堬紝閫変腑鎬诲垎鎵�鍦ㄥ垪锛屾墽琛?/p>
鈥?/p>
鏍煎紡
鈫?/p>
鏉′欢鏍煎紡
鈥?/p>
锛?/p>
鍦ㄥ脊鍑虹殑
鈥?/p>
鏉′欢鏍煎紡
鈥?/p>
瀵硅瘽妗嗕腑锛屽皢绗竴涓涓涓?/p>
鈥?/p>
鍗曞厓鏍兼暟鍊?/p>
鈥?/p>
銆佺浜屼釜妗嗕腑璁句负
鈥?/p>
澶т簬鎴?/p>
绛変簬
鈥?/p>
锛?/p>
鐒跺悗鍦ㄧ涓変釜妗嗕腑杈撳叆
500
锛?/p>
鍗曞嚮
[
鏍煎紡
]
鎸夐挳锛?/p>
鍦?/p>
鈥?/p>
鍗曞厓鏍兼牸寮?/p>
鈥?/p>
瀵硅瘽妗嗕腑锛?/p>
灏?/p>
鈥?/p>
瀛椾綋
鈥?/p>
鐨勯鑹茶缃负钃濊壊锛?/p>
鐒跺悗鍐嶅崟鍑?/p>
[
娣诲姞
]
鎸夐挳锛?/p>
骞朵互鍚屾牱鏂规硶璁剧疆灏忎簬
500
锛?/p>
瀛椾綋璁剧疆涓虹孩鑹诧紝
鏈�鍚庡崟鍑?/p>
[
纭畾
]
鎸夐挳銆?/p>
杩欐椂鍊欙紝鍙浣犵殑鎬诲垎澶т簬鎴栫瓑浜?/p>
500
鍒嗭紝灏变細浠ヨ摑鑹叉暟瀛楁樉绀猴紝鍚﹀垯浠ョ孩鑹叉樉绀猴紙濡傚浘
1
鎵�绀猴級
銆?/p>
浜屻�佸皢鎴愮哗鍚堢悊鎺掑簭
濡傛灉闇�瑕佸皢瀛︾敓鎴愮哗鎸夌潃瀛︾敓鐨勬�诲垎杩涜浠庨珮鍒颁綆鎺掑簭锛屽綋閬囧埌鎬诲垎涓�鏍风殑鍒欐寜濮撴皬
鎺掑簭銆傛搷浣滄楠ゅ涓嬶細鍏堥�変腑鎵�鏈夌殑鏁版嵁鍒楋紝閫夋嫨
鈥?/p>
鏁版嵁
鈫?/p>
鎺掑簭
鈥?/p>
锛岀劧鍚庡湪寮瑰嚭
鈥?/p>
鎺掑簭
鈥?/p>
绐楀彛
鐨?/p>
鈥?/p>
涓昏鍏抽敭瀛?/p>
鈥?/p>
涓嬫媺鍒楄〃涓�夋嫨
鈥?/p>
鎬诲垎
鈥?/p>
锛屽苟閫変腑
鈥?/p>
閫掑噺
鈥?/p>
鍗曢�夋锛屽湪
鈥?/p>
娆¤鍏抽敭瀛?/p>
鈥?nbsp;
涓嬫媺鍒楄〃
涓�夋嫨
鈥?/p>
濮撳悕
鈥?/p>
锛屾渶鍚庡崟鍑?/p>
[
纭畾
]
鎸夐挳
涓夈�佹帶鍒舵暟鎹被鍨?/p>
鍦ㄨ緭鍏ュ伐浣滆〃鐨勬椂鍊欙紝闇�瑕佸湪鍗曞厓鏍间腑鍙緭鍏ユ暣鏁拌�屼笉鑳借緭鍏ュ皬鏁帮紝鎴栬�呭彧鑳借緭鍏ユ棩鏈?/p>
鍨嬬殑鏁版嵁銆傚垢濂?/p>
Excel
2003
鍏锋湁鑷姩鍒ゆ柇銆佸嵆鏃跺垎鏋愬苟寮瑰嚭璀﹀憡鐨勫姛鑳姐�傚厛閫夋嫨鏌愪簺鐗瑰畾
鍗曞厓鏍硷紝鐒跺悗閫夋嫨
鈥?/p>
鏁版嵁
鈫?/p>
鏈夋晥鎬?/p>
鈥?/p>
锛屽湪
鈥?/p>
鏁版嵁鏈夋晥鎬?/p>
鈥?/p>
瀵硅瘽妗嗕腑锛岄�夋嫨
鈥?/p>
璁剧疆
鈥?/p>
閫夐」鍗★紝鐒跺悗
鍦?/p>
鈥?/p>
鍏佽
鈥?/p>
妗嗕腑閫夋嫨鐗瑰畾鐨勬暟鎹被鍨嬶紝褰撶劧杩樿缁欒繖涓被鍨嬪姞涓婁竴浜涚壒瀹氱殑瑕佹眰锛屽鏁存暟蹇?/p>
椤绘槸浠嬩簬鏌愪竴鏁颁箣闂寸瓑绛夛紙濡傚浘
3
鎵�绀猴級
銆傚彟澶栦綘鍙互閫夋嫨
鈥?/p>
鍑洪敊璀﹀憡
鈥?/p>
閫夐」鍗★紝璁剧疆杈撳叆绫?/p>
鍨嬪嚭閿欏悗浠ヤ粈涔堟柟寮忓嚭鐜拌鍛婃彁绀轰俊鎭紙濡傚浘
4
鎵�绀猴級
銆傚鏋滀笉璁剧疆灏变細浠ラ粯璁ょ殑鏂瑰紡鎵撳紑
璀﹀憡绐楀彛銆傚綋浣犺緭鍏ヤ俊鎭被鍨嬮敊璇垨鑰呬笉绗﹀悎鏌愪簺瑕佹眰鏃跺氨浼氳鍛婁簡銆?/p>
1
銆佸浣曞湪宸叉湁鐨勫崟鍏冩牸涓壒閲忓姞鍏ヤ竴娈靛浐瀹氬瓧绗︼紵
渚嬪锛氬湪鍗曚綅鐨勪汉浜嬭祫鏂欙紝鍦?/p>
excel
涓緭鍏ュ悗锛岀敱浜庝笂绾ц姹傚湪鍘熸潵鐨勮亴绉拌瘉涔︾殑鍙风爜鍏?/p>
閮ㄥ啀鍔犱袱浣嶏紝鍗宠鍦ㄦ瘡涓汉鐨勮瘉涔﹀彿鐮佸墠鍐嶆坊涓婁袱浣嶆暟
13
锛屽鏋滀竴涓竴涓敼鐨勮瘽瀹炲湪澶夯
鐑︿簡锛岄偅涔堟垜浠彲浠ョ敤涓嬮潰鐨勫姙娉曪紝鐪佹椂鍙堢渷鍔涳細
1
锛夊亣璁捐瘉涔﹀彿鍦?/p>
A
鍒楋紝鍦?/p>
A
鍒楀悗鐐瑰嚮榧犳爣鍙抽敭锛屾彃鍏ヤ竴鍒楋紝涓?/p>
B
鍒?/p>
锛?/p>
2
锛夊湪
B2
鍗曞厓鏍煎啓鍏ワ細
="13"
&
A2
锛堝紩鍙峰繀椤绘槸鑻辨枃杈撳叆鐘舵�佷笅锛夊悗鍥炶溅锛?/p>
3
锛夌湅鍒扮粨
鏋滀负
13xxxxxxxxxxxxx
浜嗗悧锛熼紶鏍囨斁鍒?/p>
B2
浣嶇疆锛屽崟鍏冩牸鐨勪笅鏂逛笉鏄湁涓�涓皬鏂圭偣鍚楋紝鎸?/p>
鐫�榧犳爣宸﹂敭寰�涓嬫嫋鍔ㄧ洿鍒扮粨鏉熴�傚綋浣犳斁寮�榧犳爣宸﹂敭鏃跺氨鍏ㄩ儴閮芥敼濂戒簡銆?/p>
鑻ユ槸鍦ㄥ師璇佷功鍙峰悗闈㈠姞
13
鍒欏湪
B2
鍗曞厓鏍间腑鍐欏叆锛?/p>
=A2 & 鈥?3鈥?nbsp;
鍚庡洖杞︺�?/p>
2
銆佸浣曡缃枃浠朵笅鎷夌獥鍙ｇ殑鏈�涓嬮潰鐨勬渶杩戣繍琛岀殑鏂囦欢鍚嶄釜鏁帮紵
鎵撳紑
鈥?/p>
宸ュ叿
鈥?/p>
锛岄�?/p>
鈥?/p>
閫夐」
鈥?/p>
锛屽啀閫?/p>
鈥?/p>
甯歌
鈥?/p>
锛屽湪
鈥?/p>
鏈�杩戜娇鐢ㄧ殑鏂囦欢娓呭崟
鈥?/p>
涓嬮潰鐨勬枃浠朵釜鏁拌緭鍏ユ
涓敼鍙樻枃浠舵暟鐩嵆鍙�傝嫢涓嶅湪鑿滃崟涓樉绀烘渶杩戜娇鐢ㄧ殑鏂囦欢鍚嶏紝鍒欏皢
鈥?/p>
鏈�杩戜娇鐢ㄧ殑鏂囦欢娓呭崟
鈥?/p>
鍓嶇殑澶嶉�夋鍘绘帀鍗冲彲銆?/p>
3
銆佸湪
EXCEL
涓緭鍏ュ
鈥?/p>
锛?/p>
-
锛?/p>
鈥?/p>
銆?/p>
鈥?/p>
锛?/p>
-
锛?/p>
鈥?/p>
涔嬬被鐨勬牸寮忓悗瀹冨嵆鍙樻垚锛戞湀锛戞棩锛岋紤鏈堬紥鏃ョ瓑鏃?/p>
鏈熷舰寮忥紝鎬庝箞鍔烇紵
杩欐槸鐢变簬
EXCEL
鑷姩璇嗗埆涓烘棩鏈熸牸寮忔墍閫犳垚锛屼綘鍙鐐瑰嚮涓昏彍鍗曠殑
鈥?/p>
鏍煎紡
鈥?/p>
鑿滃崟锛岄�?/p>
鈥?/p>
鍗曞厓
鏍?/p>
鈥?/p>
锛屽啀鍦?/p>
鈥?/p>
鏁板瓧
鈥?/p>
鑿滃崟鏍囩涓嬫妸璇ュ崟鍏冩牸鐨勬牸寮忚鎴愭枃鏈牸寮忓氨琛屼簡
4
銆佸湪
EXCEL
涓浣曚娇瀹冭薄
WORD
涓�鏍风殑鑷姩瀹氭椂淇濆瓨鏂囦欢锛?/p>
鐐瑰嚮
鈥?/p>
宸ュ叿
鈥?/p>
鑿滃崟
鈥?/p>
鑷姩淇濆瓨
鈥?/p>
椤癸紝璁剧疆鑷姩淇濆瓨鏂囦欢澶圭殑闂撮殧鏃堕棿銆傚鏋滃湪
鈥?/p>
宸ュ叿
鈥?/p>
鑿滃崟
涓嬫病鏈?/p>
鈥?/p>
鑷姩淇濆瓨
鈥?/p>
鑿滃崟椤癸紝閭ｄ箞鎵ц
鈥?/p>
宸ュ叿
鈥?/p>
鑿滃崟涓?/p>
鈥?/p>
鍔犺浇瀹?/p>
...鈥?/p>
閫変笂
鈥?/p>
鑷姩淇濆瓨
鈥?/p>
锛?/p>
鈥?/p>
纭畾
鈥?/p>
銆傜劧
鍚庤繘琛岃缃嵆鍙�?/p>