Excel楂樻晥璨″嫏(w霉)鎳�(y墨ng)鐢�50鍊嬪渚嬭瑳瑙�

瑾茬▼楂旂郴

涓昏鍏�(n猫i)瀹�

瑾茬▼鏀剁泭

涓€銆侀噸鏂拌獚璀楨xcel

1銆佽獚璀樺伐浣滅獥鍙�

2銆佸揩閫熻í鍟忓伐鍏锋瑒鐨勮ō(sh猫)缃�

3銆丒xcel鐨勫堡娆＄祼(ji茅)妲�(g貌u)

4銆佸伐浣滅翱鎿村睍鍚嶄粙绱�锛孍xcel鐗堟湰鍟忛

5銆佸伐浣滆〃鐨勬柊澧�銆佸埅闄�銆侀噸鍛藉悕銆佹娉�銆侀毐钘忔搷浣�

6銆佹暩(sh霉)鎿�(j霉)鎿嶄綔灏嶈薄

7銆佸浣曞苟鎺掓煡鐪�2鍊嬪伐浣滆〃

8銆丒xcel閬搁爡瑷�(sh猫)缃�

9銆佸伐浣滆〃淇濊

浣垮(xu茅)鍝″揩閫熶簡瑙xcel鐨勫父鐢ㄥ姛鑳藉拰杌熶欢鎿嶄綔锛岀悊瑙xcel鎿嶄綔灏嶈薄锛屾帉鎻xcel鎳�(y墨ng)鐢ㄧ殑榛炵窔闈紝鐐哄悗闈㈣绋嬪(xu茅)缈�(x铆)鎵撲笅鑹ソ鍩虹(ch菙)銆�

浜�銆丒xcel楂樻晥鏁�(sh霉)鎿�(j霉)鏁寸悊锛氳〃鍠紡銆佽〃鏍煎紡

1銆佷笉瑕�(gu墨)鑼冩暩(sh霉)鎿�(j霉)鐨勪笁瀹楃姜

2銆佷娇鐢‥xcel鏀堕泦鏁�(sh霉)鎿�(j霉)鐨勭洰鐨�锛熶綘閭勫湪鐐轰笉瑕�(gu墨)鑼冭〃鏍艰€屽姞鐝紵

3銆佽〃鍠紡鍜岃〃鏍煎紡濡備綍閬告搰锛�

4銆佽銆佸垪鏍煎紡瑷�(sh猫)缃�

5銆佸鐢ㄨ〃鏍兼牸寮�

6銆佹牸寮忓埛鎳�(y墨ng)鐢�

7銆佹暩(sh霉)鎿�(j霉)鍒嗗垪锛屼笉瑕佹妸涓嶇浉闂�(gu膩n)淇℃伅鏀句竴璧�

8銆佹暩(sh霉)鎿�(j霉)蹇€熷～鍏�

浣垮(xu茅)鍝℃帉鎻″浣曡(gu墨)鑼冩暩(sh霉)鎿�(j霉)绠＄悊锛屾寜宸ヤ綔闇€姹傞伕鎿�銆佽ō(sh猫)瑷堝悎閬╃殑琛ㄦ牸妯ｅ紡锛屾敼鍠勫伐浣滄晥鐜�銆�

涓�銆佽不鐢ㄥ牨閵峰柈鍒朵綔

1銆佽ō(sh猫)缃柈鍏冩牸寮忓拰灏嶉綂鏂瑰紡

2銆佸柈鍏冩牸鍚堝苟

3銆佹绶氳ō(sh猫)缃�

4銆佸柈鍏冩牸鏂囧瓧鏂瑰悜銆佸柈鍏冩牸鏂滅窔

5銆佹暩(sh霉)鎿�(j霉)鏈夋晥鎬х鐞�锛岃畵Excel鎻愰啋浣犳噳(y墨ng)閷勫叆浠€涔堟暩(sh霉)鎿�(j霉)锛�

6銆佸埗浣滀笅鎷夎彍鍠紝瑕�(gu墨)鑼冩暩(sh霉)鎿�(j霉)閷勫叆

7銆侀噾椤嶅ぇ瀵嚜鍕曡綁(zhu菐n)鎻�

8銆佹壒娉�銆佹櫤鑳藉柈鍏冩牸

9銆佽〃鏍间腑鏂囪嚜鍕曠炕璀紝鍒朵綔鑻辨枃琛ㄩ牠

10銆佽〃鏍兼牸寮忛帠瀹氾紝鏈€绲傜敤鎴朵笉寰椾慨鏀�

11銆佽〃鏍兼墦鍗�,绱欏嫉鑷畾缇�

閫氶亷璨荤敤鍫遍姺鍠殑鍒朵綔锛屼娇瀛�(xu茅)鍝″揩閫熸帉鎻″浣曞埗浣滃皥妤�(y猫)鐨勮〃鏍�锛岀啛绶存噳(y墨ng)鐢ㄥ悇绋瓻xcel鍔熻兘锛屾簴纰�銆佽(gu墨)鑼�銆侀珮鏁堥€茶鏁�(sh霉)鎿�(j霉)绠＄悊锛屽苟涓旇畵鏁�(sh霉)鎿�(j霉)濉牨浜哄摗鍙兘鎸夎(gu墨)瀹氳几鍏ユ纰虹殑鏁�(sh霉)鎿�(j霉)锛屾敼鍠勫伐浣滄晥鐜囷紝娓涘皯宸ヤ綔澶辫銆�

鍥涖€侀姺鍞当(t菕ng)瑷堣〃瑷�(sh猫)瑷�

1銆佺当(t菕ng)瑷堥琛ㄦ牸鍒朵綔鐨勫師鍓�锛岀偤浠€涔堥€欐ǎ瑷�(sh猫)瑷�锛�

2銆佹暩(sh霉)鎿�(j霉)鎺掑簭

3銆佹暩(sh霉)鎿�(j霉)绡╅伕

4銆佺啊鍠垎椤炲尟绺�銆侀洐閲嶅垎椤炲尟绺�

5銆佺獥楂旀媶鍒�

6銆佸伐浣滆〃鍑嶇祼(ji茅)

7銆佽鍒楅毐钘�

8銆佹煡鎵炬浛鎻�

9銆侀伕鎿囨€х矘璨硷細鐩稿皪寮曠敤銆佺禃灏嶅紩鐢�

10銆佸埄鐢ㄨ閷勫柈鍔熻兘蹇€熼寗鍏ュ拰鏍稿皪鏁�(sh霉)鎿�(j霉)

11銆佽嚜鍕曞鐢ㄨ〃鏍兼牸寮�

閫氶亷鍒朵綔閵峰敭绲�(t菕ng)瑷堣〃锛屼娇瀛�(xu茅)鍝＄悊瑙ｅ苟鎺屾彙濡備綍鍒朵綔鏁�(sh霉)鎿�(j霉)鏀堕泦銆佺当(t菕ng)瑷堟ā鏉�锛屽(xu茅)鏈冨緸鏇撮珮鐨勮搴︾鐞嗗拰鍒嗘瀽浼佹キ(y猫)璨″嫏(w霉)鏁�(sh霉)鎿�(j霉)锛屾彁鍗囪伔鍫寸鐖姏銆�

浜�銆佸埗浣滃伐浣滆〃鐩寗锛屽揩閫熷畾浣嶅伐浣滆〃

1銆佸埗浣滃伐浣滆〃鐩寗

2銆佽ō(sh猫)缃伐浣滆〃闁撹烦杞�(zhu菐n)閺堟帴

3銆佸柈鍏冩牸閺堟帴鍒版枃浠舵垨缍�(w菐ng)闋�

4銆佸畯琛ㄥ嚱鏁�(sh霉)銆両NDEX銆丩EN銆丩EFT銆丷IGHT銆丼UBSTITUTE鍑芥暩(sh霉)

鍦ㄥ伐浣滆〃杓冨鐨勬儏娉佷笅锛屽浣曡嚜鍕曞埗浣滃伐浣滆〃鐩寗锛屽弽鏄犲伐浣滆〃涓昏鎯呮硜锛屽苟瀵︾従(xi脿n)蹇€熷畾浣嶈烦杞�(zhu菐n)锛屾敼鍠勫伐浣滄晥鐜�銆�

鍏€佸摗宸ュ€嬩汉淇℃伅琛ㄥ埗浣�

1銆佸摗宸ユ暩(sh霉)鎿�(j霉)閲囬泦鐨勮(gu墨)鑼冩€�锛屾牸寮忚ō(sh猫)缃�銆佹暩(sh霉)鎿�(j霉)椹楄瓑鎳�(y墨ng)鐢�

2銆佽超铏熼寗鍏�锛屾暩(sh霉)瀛椾笉鍐嶈畩E+

3銆佸緸韬唤璀変腑鎻愬彇骞撮健銆佸垎杈ㄦ€у垾锛孴EXT銆丮ID銆両F銆丮OD鍑芥暩(sh霉)銆�

4銆佺姝㈣几鍏ラ噸寰�(f霉)浜哄摗

5銆佸鍚嶈嚜鍕曠敓鎴愭嫾闊�锛岃嚜瀹氱京GETPY鍑芥暩(sh霉)

6銆佽嚜鍕曠敓鎴愰兊绠辫超鎴�锛孲UBSTITUTE銆丆ONCATENATE銆乀RIM鍑芥暩(sh霉)

涓冦€佷互琛ㄥ柈鐨勫舰寮忔煡瑭�銆佹墦鍗板摗宸ョ啊姝疯〃

1銆佸摗宸ョ啊姝疯〃鍠殑瑷�(sh猫)瑷�

2銆佸鐝�(xi脿n)鑷嫊鏌ヨ锛孖NDEX銆丮ATCH銆乂LOOKUP鍑芥暩(sh霉)浣跨敤

鍏�銆佷汉鍝″揩閫熸牳灏�

1銆佷娇鐢╒lookup鍑芥暩(sh霉)閫茶琛ㄦ牸姣斿皪锛屽揩閫熸壘鍑哄樊鐣�

2銆佷娇鐢ㄥ埅闄ら噸寰�(f霉)琛屽姛鑳�

涔濄€佽€冨嫟琛ㄥ埗浣滆垏鑰冨嫟绠＄悊

1銆佽€冨嫟琛ㄥ埗浣�

2銆佽€冨嫟绠＄悊锛堝悓鏅傚浜哄湪绶氱法杓�銆佹牸寮忛帠瀹氾級

3銆佽€冨嫟鏁�(sh霉)鎿�(j霉)鐨勭当(t菕ng)瑷�, COUNT銆丆OUNTIF銆丆OUNTBLANK銆丏AY鍑芥暩(sh霉)

4銆佽€冨嫟鏁�(sh霉)鎿�(j霉)鑸囧摗宸ヤ俊鎭〃鐨勬瘮灏嶅拰鍖归厤

鍗�銆佸摗宸ュ伐榻¤▓绠椼€佺敓鏃ユ彁閱�

1銆佸摗宸ュ伐榻¤▓绠�锛孌ATEDIF銆丯OW鍑芥暩(sh霉)浣跨敤

2銆佸摗宸ョ敓鏃ヨ嚜鍕曟彁閱�锛屾浠舵牸寮忎娇鐢�

3銆佸姊濅欢绡╅伕鐨勪娇鐢�

鍗佷竴銆佸摗宸ュ伐璩囪▓绠�

1銆佸熀鏈伐璩�銆佽€冨嫟宸ヨ硣銆佽▓浠跺伐璩囪▓绠�

2銆佸摗宸ヤ笁闅竴閲戣▓绠�

3銆丒xcel琛ㄦ牸姹傚拰锛岀偤浠€涔堢附宸咕鍒嗛將锛�

4銆佹暩(sh霉)瀛楅亱绠楁妧宸э紝鍩烘湰鍑芥暩(sh霉)鐨勬噳(y墨ng)鐢�

5銆佹暩(sh霉)瀛楀彇鏁村嚱鏁�(sh霉)鐨勬噳(y墨ng)鐢�,ROUND銆丷OUNDDOWN銆丷OUNDUP

6銆佸埄鐢ㄥ嚱鏁�(sh霉)鑷嫊瑷堢畻鍊嬩汉鎵€寰楃▍

7銆佸揩閫熷鐝�(xi脿n)宸ヨ硣鏅疾10%

8銆佸揩閫熷鐝�(xi脿n)宸ヨ硣鏅疾500鍏�

鍗佷簩銆佸伐璩囨暩(sh霉)鎿�(j霉)鍒嗘瀽

1銆佸伐璩囨暩(sh霉)鎿�(j霉)鐨勫垎鏋愯榛�

2銆佹寜閮ㄩ杸閫茶鍦栬〃鍒嗘瀽

3銆佹寜宸ヨ硣闋呯洰鍦栬〃鍒嗘瀽

鍗佷笁銆侀妧琛屼唬鐧�(f膩)宸ヨ硣銆佸伐璩囨鎵撳嵃

1銆佸揩閫熷埗浣滈妧琛屼唬鐧�(f膩)宸ヨ硣琛�

2銆佸伐璩囨鎵撳嵃

3銆佹墍鏈夊摗宸ョ殑宸ヨ硣琛�锛岃ō(sh猫)缃儏鑳芥煡鐪嬫湰浜轰俊鎭�

閫氶亷鍏稿瀷浼佹キ(y猫)鐨勫摗宸ョ鐞嗐€佸伐璩囪▓绠楅亷绋嬭瑳瑙�锛屼娇瀛�(xu茅)鍝℃帉鎻xcel鍦ㄥ伐璩囪▓绠楅亷绋嬩腑鐨勫姛鑳藉拰鍑芥暩(sh霉)鎳�(y墨ng)鐢�锛屽苟鎺屾彙宸ヨ硣鏁�(sh霉)鎿�(j霉)鐨勫父鐢ㄥ垎鏋愭柟娉曘€�

鍗佸洓銆佸埗浣滅従(xi脿n)閲�銆侀妧琛屾棩瑷樿超锛岀敓鎴愯硣閲戞棩鍫�

1銆佺従(xi脿n)閲�銆侀妧琛屾棩瑷樿超琛ㄦ牸瑷�(sh猫)瑷�

2銆侀枊鏀爡鐩伕鎿囪彍鍠殑鍒朵綔

3銆佹敹鍏�銆佹敮鍑烘寜闋呯洰鍖附锛孲UMPRODUCT鍑芥暩(sh霉)澶氭浠跺尟绺�

4銆佽▓绠椾綑椤�

5銆佽硣閲戞棩鍫辫〃鐨勫埗浣�

6銆佸牨琛ㄦ牸寮忛帠瀹�锛岃〃鏍煎叕寮忛毐钘�锛屼繚璀疯嚜宸茬殑鍕炲嫊鎴愭灉

7銆佽几鍏ユ棩鏈�锛屾煡鐪嬬暥鏃ュ牨琛�

鍗佷簲銆佽硣閲戞儏娉佸垎鏋�

1銆佽硣閲戝崰鐢ㄥ湒琛ㄥ垎鏋�

2銆佷娇鐢ㄦ棩鏈熷垎鏋�

閫氶亷鏃ヨ璩拰璩囬噾鏃ュ牨琛ㄨō(sh猫)瑷堥亷绋嬭瑳瑙�锛屼娇瀛�(xu茅)鍝℃帉鎻xcel鍦ㄤ紒妤�(y猫)璩囬噾绠＄悊閬庣▼涓殑鍔熻兘鍜屽嚱鏁�(sh霉)鎳�(y墨ng)鐢�锛屽苟鎺屾彙璩囬噾鐨勫父鐢ㄥ垎鏋愭柟娉�銆�

鍗佸叚銆佸浐瀹氳硣鐢�(ch菐n)鑷鸿超瑷�(sh猫)瑷�

1銆佸浐瀹氳硣鐢�(ch菐n)鑷鸿超鏁�(sh霉)鎿�(j霉)鏀堕泦瑕侀粸

2銆佽〃鏍艰ō(sh猫)瑷�

3銆佽嚭璩牸寮忕殑閹栧畾

鍗佷竷銆佸浐瀹氳硣鐢�(ch菐n)浣跨敤鍒嗘瀽

1銆侀儴闁€鍗犵敤鍦栬〃鍒嗘瀽

2銆佹寜骞撮檺鍦栬〃鍒嗘瀽

3銆佹寜璩囩敘(ch菐n)椤炲垾鍦栬〃鍒嗘瀽

鍗佸叓銆佸浐瀹氳硣鐢�(ch菐n)妯欑敖鎵撳嵃銆佷簩缍⒓鍒朵綔

1銆佸浐瀹氳硣鐢�(ch菐n)妯欑敖瑷�(sh猫)瑷�锛�

2銆佽嚜鍕曠敓鎴愭绨�锛孖NDEX銆丮ATCH鍑芥暩(sh霉)浣跨敤

3銆佹牴鎿�(j霉)鍥哄畾璩囩敘(ch菐n)鍩虹(ch菙)淇℃伅鐢熸垚浜岀董纰�

4銆佹绨戒笂鎵撳嵃浜岀董纰�

鍗佷節銆佸浐瀹氳硣鐢�(ch菐n)鎶樿垔瑷堟彁

1銆佺暥鏈堟姌鑸婅▓绠�

2銆佺疮瑷堟姌鑸婅▓绠�

3銆佸凡浣跨敤鏈熼枔瑷堢畻锛孌ATEIF銆両F銆丷OUND鍑芥暩(sh霉)浣跨敤

浜屽崄銆佸浐瀹氳硣鐢�(ch菐n)鎶樿垔璨荤敤鍒嗘瀽

鐢ㄦ暩(sh霉)鎿�(j霉)閫忚琛�銆佸湒琛ㄥ拰鍒囩墖鍣ㄥ瑙掑害鍒嗘瀽鍥哄畾璩囩敘(ch菐n)鎶樿垔鏁�(sh霉)鎿�(j霉)銆�

閫氶亷鍥哄畾璩囩敘(ch菐n)绠＄悊鍙婃姌鑸婅▓绠楄〃鏍艰ō(sh猫)瑷堢殑璎涜В锛屼娇瀛�(xu茅)鍝℃帉鎻xcel鍦ㄤ紒妤�(y猫)鍥哄畾璩囩敘(ch菐n)绠＄悊閬庣▼涓殑鍔熻兘鎳�(y墨ng)鐢ㄥ拰鍑芥暩(sh霉)瑷�(sh猫)缃紝骞舵帉鎻′紒妤�(y猫)鍥哄畾璩囩敘(ch菐n)鐨勫父鐢ㄥ湒琛ㄥ垎鏋愭柟娉�锛屼娇瀛�(xu茅)鍝¤兘澶�?q奴)W浠ヨ嚧鐢ㄣ€�

浜屽崄涓€銆佸晢鍝佷唬纰艰〃鍒朵綔

1銆佸垎椤炪€佸搧绋伅(li谩n)鍕曠殑浜岀礆涓嬫媺閬告搰妗�?q奴)宕縁(xi脿n)

2銆佹暩(sh霉)鎿�(j霉)鏈夋晥鎬ц嚜瀹氱京搴忓垪鐨勪娇鐢紝INDIRECT鍑芥暩(sh霉)

3銆佽ō(sh猫)缃波鍝佷唬纰�

浜屽崄浜屻€侀噰璩煎叆搴当(t菕ng)瑷堣〃瑷�(sh猫)瑷�

1銆佽ō(sh猫)瑷堝叆搴当(t菕ng)瑷堣〃

2銆佷緵鎳�(y墨ng)鍟嗕笅鎷夋

3銆佽波鍝佷笅鎷夋

4銆佽〃鏍兼牸寮忚ō(sh猫)缃�

浜屽崄涓夈€侀噰璩兼垚鏈垎鏋�

1銆佽波鍝侀噰璩兼渶楂樺児銆佹渶浣庡児鍒嗘瀽

2銆佷緵鎳�(y墨ng)鍟嗕締婧愬垎鏋�

3銆佸搧绋噰璩煎垎鏋�

浜屽崄鍥�銆侀姺鍞儏娉佸垎鏋�

1銆佸畬鍠勯姺鍞当(t菕ng)瑷堣〃锛屽鎴躲€侀姺鍞摗涓嬫媺妗嗚ō(sh猫)缃�

2銆佸埄鐢ㄥ垏鐗囧櫒灏嶉姺鍞敹鍏ョ当(t菕ng)瑷堣〃閵峰敭鍝°€佸勾搴�銆佹湀浠介姺鍞儏娉侀€茶鍒嗘瀽

3銆佹寜閵峰敭鍦板崁(q奴)鍦栬〃鍒嗘瀽

4銆佹寜閵峰敭浜哄摗鍦栬〃鍒嗘瀽

5銆佹寜閵峰敭鍝佺ó鍦栬〃鍒嗘瀽

6銆佹暩(sh霉)鎿�(j霉)閫忚琛ㄥ嫊鎱�(t脿i)鍒嗘瀽

浜屽崄浜�銆侀姺鍞爯(y霉)娓�

1銆佹湀搴﹀垎鏋�

2銆佸勾搴﹀垎鏋�

3銆佽定鍕㈠垎鏋�锛屾姌绶氬湒瑷�(sh猫)瑷�

4銆佷娇鐢═REND銆丗ORECAST鍑芥暩(sh霉)闋�(y霉)娓姺鍞噺

浜屽崄鍏�銆佸嚭搴垚鏈▓绠椼€侀姺鍞瘺鍒╁垎鏋�

1銆侀姺鍞瘺鍒╄▓绠�锛孷LOOKUP鍑芥暩(sh霉)鑸嘗OOKUP鍑芥暩(sh霉)鐣板悓

2銆佸柈浣嶆瘺鍒╁墠鍗佸ぇ璨ㄥ搧鍒嗘瀽

浜屽崄涓� 銆侀€查姺瀛樼鐞嗚〃瑷�(sh猫)瑷�

1銆佽〃鏍奸爡鐩ō(sh猫)瑷�,闆欒〃闋ō(sh猫)瑷堢殑寮婄

2銆佹湰鏈堥噰璩�銆侀姺鍞暩(sh霉)鎿�(j霉)鐨勫尮閰�

3銆丼UM鍑芥暩(sh霉)鍐嶈獚璀�銆丼UMIF鍑芥暩(sh霉)

4銆佹洿鍔犱究鍒╃殑SUMPRODUCT鍑芥暩(sh霉)鐨勪娇鐢�

浜屽崄鍏€佸韩瀛樺垎鏋�

1銆佸韩瀛樺搧椤炲崰鐢ㄥ垎鏋�

2銆佸韩瀛�10澶ц波鍝佸垎鏋�

3銆佸韩瀛樺懆杞�(zhu菐n)澶╂暩(sh霉)鍒嗘瀽

浜屽崄涔�銆佹敹娆剧当(t菕ng)瑷堣〃銆佹噳(y墨ng)鏀惰超娆句綑椤嶈▓绠�

1銆佹敹娆剧当(t菕ng)瑷堣〃鐨勮ō(sh猫)瑷�

2銆佹噳(y墨ng)鏀惰超娆句綑椤嶇殑瑷堢畻锛氬姊濅欢鎺掑簭銆丩OOKUP鍑芥暩(sh霉)

涓夊崄銆佹噳(y墨ng)鏀惰超榻¤〃鍒朵綔

1銆佽超榻″垎鏋愯〃鐨勮ō(sh猫)瑷�

2銆佹湯绛嗕氦鏄撴棩鏈熺殑鍖归厤

3銆佽超榻″叕寮忚ō(sh猫)瑷�锛孖F銆丄ND鍑芥暩(sh霉)

涓夊崄涓€銆侀妧琛屾壙鍏屽尟绁ㄥ埌鏈熸彁閱�

1銆佷俊鐢ㄦ湡闄愮殑瑷堢畻锛孴ODAY銆両F銆丄ND鍑芥暩(sh霉)

2銆佸埄鐢ㄦ浠舵牸寮忔彁閱�

涓夊崄浜�銆佸揩閫熺敓鎴愩€佹墦鍗板線渚嗚璀夊嚱

1銆佸線渚嗗柈浣嶅緢澶�锛屽姞鐝墦鍗板線渚嗚璀夊嚱锛�

2銆侀厤鍚堜娇鐢╓ord銆丒xcel蹇€熺敓鎴愬悇鍠綅瑭㈣瓑鍑�

涓夊崄涓�銆佽不鐢ㄧ当(t菕ng)瑷堝垎鏋愯〃

1銆佽不鐢ㄦ敹闆嗚〃鐨勮ō(sh猫)瑷�

2銆佽不鐢ㄧ殑澶氳搴︾当(t菕ng)瑷堝垎鏋�

涓夊崄鍥�銆佽不鐢ㄧ殑鍦栬〃鍒嗘瀽

1銆佽不鐢ㄩ儴闁€浣跨敤鍒嗘瀽

2銆侀鍦栭€茶璨荤敤绲�(ji茅)妲�(g貌u)鍒嗘瀽

3銆佹煴鐙€鍦栭€茶璨荤敤灏嶆瘮鍒嗘瀽

涓夊崄浜�銆佽睛鍏敤鍝侀牁(l菒ng)鐢ㄨ閷勮〃

1銆佽睛鍏敤鍝侀牁(l菒ng)鐢ㄨ閷勮〃鐨勮ō(sh猫)瑷�

2銆佸鐝�(xi脿n)涓嬫媺妗嗛伕鎿囷細闋�(l菒ng)鐢ㄥ師鍥�銆侀儴闁€

3銆佽睛鍏敤鍝佸韩瀛樿▓绠楋細SUMIF鍑芥暩(sh霉)

4銆佽睛鍏敤鍝侀牁(l菒ng)鐢ㄥ垎鏋�

涓夊崄鍏€佽粖杓涗娇鐢ㄧ鐞嗚〃

1銆佽粖杓涗娇鐢ㄧ鐞嗚〃瑷�(sh猫)瑷�

2銆侀椐涘摗瑁滃姪鐨勮▓绠�

3銆佷娇鐢ㄦ儏娉佸垎鏋愶紝IFNA銆両F銆丮AX銆丼UBTOTAL鍑芥暩(sh霉)

涓夊崄涓�銆佹湰閲忓埄鍒嗘瀽

1銆佹湰閲忓埄鍒嗘瀽鏁�(sh霉)鎿�(j霉)婧栧倷

2銆佺泩铏у钩琛＄窔鏁�(sh霉)鎿�(j霉)瑷堢畻

3銆佺泩铏у钩琛￠噺鐨勮畩鍕曞垎鏋�

浣垮(xu茅)鍝℃帉鎻″浣曞湪瀵﹂殯宸ヤ綔涓亱鐢‥xcel灏嶉噰璩�銆侀姺鍞�銆佽不鐢�銆佽鏀跨鐞嗘暩(sh霉)鎿�(j霉)閫茶瑕�(gu墨)鑼冨寲姝搁泦鍜屾暣鐞�锛岀稖鍚堝埄鐢ㄥ嚱鏁�(sh霉)銆佸湒琛ㄣ€佹暩(sh霉)鎿�(j霉)閫忚琛ㄧ瓑鍚勭óExcel宸ュ叿灏嶆暩(sh霉)鎿�(j霉)閫茶鍒嗘瀽锛屾帉鎻＄稉(j墨ng)鐕熺鐞嗗瘑纰�銆�

涓夊崄鍏�銆佽硣鐢�(ch菐n)璨犲偟琛�銆佸埄娼よ〃鍙婃垚鏈不鐢ㄦ槑绱拌〃绶ㄥ埗

1銆佽〃鏍煎簭铏熺殑鑷嫊绶ㄥ埗

2銆佸柈鍏冩牸鐨勫紩鐢�

3銆佸牨琛ㄩ棞(gu膩n)绯荤殑鏍￠锛屽牨琛ㄦ槸鍚︾鍚堟渻瑷堟亽绛夊紡锛�

4銆佸姞鍏ュ湒绀�锛屽牨琛ㄦ洿缇庤

鍫辫〃鑷嫊鎸囩ず鏄惁骞宠　銆�

涓夊崄涔�銆佽硣鐢�(ch菐n)璨犲偟琛ㄦ墦鍗颁笉涓�锛�

1銆丒xcel涓嶅悓瑕栧湒鐨勪粙绱�

2銆佸垎闋侀爯(y霉)瑕界殑浣跨敤

3銆侀爜闈㈣ō(sh猫)缃殑浣跨敤

4銆佸湪姣忛爜涓婃墦鍗拌〃闋�

5銆侀爜鐪夐爜鑵崇殑鎳�(y墨ng)鐢�

鎺у埗璩囩敘(ch菐n)鍜岃矤鍌垫墍鏈夎€呮瑠(qu谩n)鐩婂湪涓嶅悓绱欎笂鎵撳嵃锛屽苟鍦ㄦ瘡寮电礄涓婃墦鍗拌〃闋€�

鍥涘崄銆佸張绐勫張闀风殑琛ㄦ牸锛屽浣曟墦鍗板埌涓€闋佷笂

浣跨敤鍒嗘瑒鍦ㄤ竴寮电礄涓婃墦鍗拌〃鏍�銆�

鍥涘崄涓€銆佹枃浠跺湪璨″嫏(w霉)閮ㄥ叡浜�

濡備綍瑷�(sh猫)缃浕鑵﹀叡浜�锛屾寜鐢ㄦ埗鍚嶅瘑纰煎叡浜枃浠�銆�

璨″嫏(w霉)閮ㄦ枃浠跺叡浜倓鍦ㄤ娇鐢ㄩ浕瀛愰兊浠跺拰U鐩�锛�

鍥涘崄浜�銆�1鍒嗛悩鍖附1鍊嬫湀鐨勬棩鍫辫〃

鏈堟湯濡備綍鍦�1鍒嗛悩鍏�(n猫i)鍖附1鍊嬫湀鐨勬棩鍫辫〃銆�

鍥涘崄涓�銆佸瓙鍏徃鍫辫〃鑷嫊鍖附骞跺垎绱氭煡鐪�

1銆佸悕绋辩鐞嗗櫒鐨勪娇鐢�

2銆佸悎骞惰▓绠�

3銆佹寜鍒嗛銆佹寜闋呯洰鍚堝苟瑷堢畻

4銆佸壍(chu脿ng)寤烘寚鍚戞簮琛ㄧ殑閺堟帴锛屽鐝�(xi脿n)鍒嗙礆椤ず

5銆佹暩(sh霉)鎿�(j霉)鍗€(q奴)鍩熷懡鍚�

6銆佺矘璨奸張鎺ョ殑浣跨敤

绁炲鐨勫悎骞惰▓绠楀姛鑳姐€佸堡娆″垎鏄庣殑鍒嗙礆椤ず鍔熻兘銆佽秴涔庢兂璞＄殑鑷嫊鍒锋柊鍔熻兘绛�銆�

鍥涘崄鍥涖€佸埄鐢∕icrosoft Query鍒朵綔鑷嫊鍫辫〃

1銆丮icrosoft Query鍔熻兘浠嬬垂

2銆佷娇鐢∕icrosoft Query鍚�?q奴)?/span>

3銆佹煡瑭㈤棞(gu膩n)閸靛瓧鐨勮ō(sh猫)缃�

4銆佹煡瑭㈤伕闋呯殑瑷�(sh猫)缃�

5銆佽嚜鍕曞牨琛ㄧ殑瀵︾従(xi脿n)

6銆丼UMIF鍑芥暩(sh霉)瀵︾従(xi脿n)鑷嫊鍖附

浠ラ姺鍞当(t菕ng)瑷堣〃鐐轰緥锛屼粙绱硅嚜鍕曞寲鏌ヨ鍫辫〃鐨勫埗浣滈亷绋�锛岃嚜鍕曞寲鍒嗘瀽銆佸尟琛ㄦ暩(sh霉)鎿�(j霉)锛屾垚鍊嶅寮峰伐浣滄晥鐜�銆�

鍥涘崄浜斻€丒xcel VBA鎳�(y墨ng)鐢�

浣垮(xu茅)鍝′簡瑙ｆ帶浠�銆佸畯鍜孷BA绛塃xcel鐨勯珮绱氭噳(y墨ng)鐢紝骞跺埄鐢ㄩ€欎簺宸ヤ綔瀹屾垚杓冪偤寰�(f霉)闆滅殑閲嶅京(f霉)鎬у伐浣�銆�

鍥涘崄鍏�銆佽垏閲戣澏銆佺敤鍙嬭病鍕�(w霉)杌熶欢鍙栨暩(sh霉)鍒嗘瀽

閲戣澏銆佺敤鍙嬫暩(sh霉)鎿�(j霉)灏�(d菐o)鍑哄埌Excel閫茶鍒嗘瀽銆�

璨″嫏(w霉)杌熶欢鍒嗘瀽鍔熻兘寮�锛烢xcel渚嗗公蹇�銆�

鍥涘崄涓�銆佽病鍕�(w霉)鍒嗘瀽鍫卞憡涓彃鍏xcel琛ㄦ牸

1銆佽〃鏍肩矘鍒癢ord涓叏浜備簡锛�

2銆佸湪Word涓彃鍏ヨ〃鏍�锛屽苟瀵︾従(xi脿n)琛ㄦ牸瑷堢畻

3銆乄ord涓〃鏍兼帓鐗�

4銆侀張鎺xcel鏂囦欢

Word涓〃鏍间篃鍙嚜鍕曡▓绠�銆�

鍥涘崄鍏€丳owerPoint

1銆佸湪PPT涓彃鍏ヨ〃鏍�锛屽苟瀵︾従(xi脿n)琛ㄦ牸瑷堢畻

2銆丳PT涓〃鏍兼帓鐗�

3銆侀張鎺xcel鏂囦欢

PPT婕旂ず鏅傛墦闁婨xcel琛ㄦ牸銆�

鍥涘崄涔�銆佸鎴舵豢鎰忓害瑾�(di脿o)鏌�

浣跨敤浼佹キ(y猫)寰俊鍓�(chu脿ng)寤鸿(di脿o)鏌ヨ〃銆�

浜斿崄銆丒xcel鎶撳彇缍�(w菐ng)闋佹暩(sh霉)鎿�(j霉)锛岄€茶浼佹キ(y猫)瀹忚鐠�(hu谩n)澧冨垎鏋�

1銆佸ぇ鏁�(sh霉)鎿�(j霉)鏅備唬锛岄倓鍦ㄥ京(f霉)鍒剁矘璨�锛�

2銆丒xcel鑷嫊鎶撳彇缍�(w菐ng)闋佹暩(sh霉)鎿�(j霉)銆�

鑷嫊鎶撳彇缍�(w菐ng)闋佹暩(sh霉)鎿�(j霉)锛岃病鍕�(w霉)鍒嗘瀽鏇村嚭褰�銆�