銆€銆€>>>2012鏈�(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼鐏啽鍫�(b脿o)鍚嶄腑<<<

銆€銆€1銆佸揩閫熷暉鍕�(d貌ng)Excel

銆€銆€鑻ユ偍鏃ュ父宸ヤ綔涓缍�(j墨ng)甯镐娇鐢‥xcel锛屽彲浠ュ湪鍟熷嫊(d貌ng)Windows鏅�(sh铆)鍟熷嫊(d貌ng)瀹冿紝瑷�(sh猫)缃柟娉曪細

銆€銆€(1)鍟熷嫊(d貌ng)鈥滄垜鐨勯浕鑵︹€濋€�(j矛n)鍏indows鐩寗锛屼緷鐓ц矾寰戔€淪tart Menu\Programs\鍟熷嫊(d貌ng)鈥濅締(l谩i)鎵撻枊(k膩i)鈥滃暉鍕�(d貌ng)鈥濇枃浠跺ぞ銆�

銆€銆€(2)鎵撻枊(k膩i)Excel 鎵€鍦ㄧ殑鏂囦欢澶�锛岀敤榧犳(bi膩o)灏嘐xcel鍦栨(bi膩o)鎷栧埌鈥滃暉鍕�(d貌ng)鈥濇枃浠跺ぞ锛岄€欐檪(sh铆)Excel鐨勫揩鎹锋柟寮忓氨琚京(f霉)鍒跺埌鈥滃暉鍕�(d貌ng)鈥濇枃浠跺ぞ涓�锛屼笅娆″暉鍕�(d貌ng)Windows灏卞彲蹇€熷暉鍕�(d貌ng)Excel浜�銆�

銆€銆€鑻indows宸插暉鍕�(d貌ng)锛屾偍鍙敤浠ヤ笅鏂规硶蹇€熷暉鍕�(d貌ng)Excel.

銆€銆€鏂规硶涓€锛氶洐鎿娾€滈枊(k膩i)濮嬧€濊彍鍠腑鐨勨€滄枃妾斺€濆懡浠ら噷鐨勪换涓€Excel宸ヤ綔绨垮嵆鍙€�

銆€銆€鏂规硶浜岋細鐢ㄩ紶妯�(bi膩o)寰炩€滄垜鐨勯浕鑵︹€濅腑灏嘐xcel鎳�(y墨ng)鐢ㄧ▼搴忔嫋鍒版闈笂锛岀劧鍚庡緸蹇嵎鑿滃柈涓伕鎿団€滃湪鐣�(d膩ng)鍓嶄綅缃壍(chu脿ng)寤哄揩鎹锋柟寮忊€濅互鍓�(chu脿ng)寤哄畠鐨勫揩鎹锋柟寮�锛屽暉鍕�(d貌ng)鏅�(sh铆)鍙渶闆欐搳鍏跺揩鎹锋柟寮忓嵆鍙�銆�

銆€銆€2銆佸揩閫熺嵅鍙栧公鍔�

銆€銆€灏�(du矛)浜庡伐鍏锋瑒鎴栧睆骞曞崁(q奴)锛屾偍鍙渶鎸夌祫鍚堥嵉Shift+F1锛岀劧鍚庣敤榧犳(bi膩o)鍠搳宸ュ叿娆勬寜閳曟垨灞忓箷鍗€(q奴)锛屽畠灏辨渻(hu矛)褰堝嚭涓€鍊�(g猫)骞姪绐楀彛锛屼笂闈㈡渻(hu矛)鍛婅ù瑭插厓绱犵殑瑭崇窗(x矛)骞姪淇℃伅銆�

銆€銆€3銆佸揩閫熺Щ鍕�(d貌ng)鎴栧京(f霉)鍒跺柈鍏冩牸

銆€銆€鍏堥伕瀹氬柈鍏冩牸锛岀劧鍚庣Щ鍕�(d貌ng)榧犳(bi膩o)鎸囬嚌鍒板柈鍏冩牸閭婃涓�锛屾寜涓嬮紶妯�(bi膩o)宸﹂嵉骞舵嫋鍕�(d貌ng)鍒版柊浣嶇疆锛岀劧鍚庨噵鏀炬寜閸靛嵆鍙Щ鍕�(d貌ng)銆傝嫢瑕佸京(f霉)鍒跺柈鍏冩牸锛屽墖鍦ㄩ噵鏀鹃紶妯�(bi膩o)涔嬪墠鎸変笅Ctrl鍗冲彲銆�

銆€銆€4銆佸揩閫熸煡鎵惧伐浣滅翱

銆€銆€鎮ㄥ彲浠ュ埄鐢ㄥ湪宸ヤ綔琛ㄤ腑鐨勪换浣曟枃瀛楅€�(j矛n)琛屾悳灏�锛屾柟娉曠偤锛�

銆€銆€(1)鍠搳宸ュ叿娆勪腑鐨勨€滄墦闁�(k膩i)鈥濇寜閳曪紝鍦ㄢ€滄墦闁�(k膩i)鈥濆皪(du矛)瑭辨閲�锛岃几鍏ユ枃浠剁殑鍏ㄥ悕鎴栭儴鍒嗗悕锛屽彲浠ョ敤閫氶厤绗︿唬鏇�銆�

銆€銆€(2)鍦ㄢ€滄枃鏈爆鎬р€濈法杓涓�锛岃几鍏ユ兂瑕佹悳灏嬬殑鏂囧瓧锛屾渶濂芥槸鎮ㄨ獚(r猫n)鐐烘槸鍞竴鐨勫柈瑭炴垨鐭獮(y菙)锛屼互渚挎悳灏嬫洿瀹规槗鎴愬姛銆�

銆€銆€(3)閬告搰鈥滈枊(k膩i)濮嬫煡鎵锯€濆嵆鍙�銆傚湪鎵惧埌婊胯冻姊濅欢鐨勬枃浠跺墠锛屸€滄墦闁�(k膩i)鈥濆皪(du矛)瑭辨鐨勭媭鎱�(t脿i)娆勯兘鏈�(hu矛)椤ず鈥滄壘鍒颁簡0鍊�(g猫)鏂囦欢鈥濈殑淇℃伅锛屾偍鎳�(y墨ng)瑭茶€愬績绛夊緟锛屽彧鏈夌暥(d膩ng)鈥滄墦闁�(k膩i)鈥濇寜閳曠敱鐏板寲鐙€鎱�(t脿i)璁婃垚鍙敤鐙€鎱�(t脿i)鏅�(sh铆)锛屾墠琛ㄦ槑鎼滃皨绲�(ji茅)鏉�銆�

銆€銆€5銆佸揩閫熸墦鍗板伐浣滆〃

銆€銆€鑻ラ伕鎿団€滄枃浠垛€濊彍鍠腑鈥滄墦鍗扳€濆懡浠や締(l谩i)鎵撳嵃锛屾渻(hu矛)鍑虹従(xi脿n)鈥滄墦鍗扳€濆皪(du矛)瑭辨璁撴偍閬告搰锛岀▼搴忕箒鐟�銆傝嫢瑕佽烦閬�(gu貌)瑭插皪(du矛)瑭辨锛屾偍鍙互鍠搳鈥滃父鐢ㄢ€濆伐鍏锋瑒涓婄殑鈥滄墦鍗扳€濇寜閳曟垨鑰呮寜涓婼hift閸靛苟鍠搳鈥滄墦鍗伴爯(y霉)瑕解€濇寜閳�锛孍xcel灏囦娇鐢ㄢ€滈伕瀹氬伐浣滆〃鈥濋伕闋�(xi脿ng)鎵撳嵃銆�

銆€銆€6銆佸揩閫熷垏鎻涘伐浣滆〃

銆€銆€鎸塁trl+PageUp绲勫悎閸靛彲婵€娲诲墠涓€鍊�(g猫)宸ヤ綔琛�锛屾寜Ctrl+PageDown绲勫悎閸靛彲婵€娲诲悗涓€鍊�(g猫)宸ヤ綔琛ㄣ€傛偍閭勫彲鐢ㄩ紶妯�(bi膩o)鍘绘帶鍒跺伐浣滆〃搴曢儴鐨勬(bi膩o)绨芥痪鍕�(d貌ng)鎸夐垥蹇€熷湴绉诲嫊(d貌ng)宸ヤ綔琛ㄧ殑鍚嶅瓧锛岀劧鍚庡柈鎿婂伐浣滆〃閫�(j矛n)琛屽垏鎻�銆�

銆€銆€7銆佸揩閫熷垏鎻涘伐浣滅翱

銆€銆€灏�(du矛)浜庤純灏戝伐浣滅翱鍒囨彌锛屽彲鍠搳宸ヤ綔绨挎墍鍦ㄧ獥鍙�銆傝灏�(du矛)澶氬€�(g猫)绐楀彛涓嬬殑澶氬€�(g猫)宸ヤ綔閫�(j矛n)琛屽垏鎻涳紝鐢ㄢ€滅獥鍙ｂ€濊彍鍠渶鏂逛究銆傗€滅獥鍙ｂ€濊彍鍠殑搴曢儴鍒楀嚭浜嗗凡鎵撻枊(k膩i)浜嗗伐浣滅翱鐨勫悕瀛�锛岃鐩存帴鍒囨彌鍒颁竴鍊�(g猫)宸ヤ綔绨�锛屽緸鈥滅獥鍙ｂ€濊彍鍠伕鎿囧畠鐨勫悕瀛楀嵆鍙€�

銆€銆€鈥滅獥鍙ｂ€濊彍鍠渶澶氳兘鍒楀嚭9鍊�(g猫)宸ヤ綔绨�锛岃嫢澶氫簬9鍊�(g猫)锛屸€滅獥鍙ｂ€濊彍鍠墖鍖呭惈涓€鍊�(g猫)鍚嶇偤鈥滃绐楀彛鈥濈殑鍛戒护锛岄伕鐢ㄨ┎鍛戒护锛屽墖鍑虹従(xi脿n)涓€鍊�(g猫)鎸夊瓧姣嶉爢搴忓垪鍑烘墍鏈夊凡鎵撻枊(k膩i)鐨勫伐浣滅翱鍚嶅瓧鐨勫皪(du矛)瑭辨锛屽彧闇€鍠搳鍏朵腑闇€瑕佺殑鍚嶅瓧鍗冲彲銆�

銆€銆€鐠�(hu谩n)鐞冪恫(w菐ng)鏍＄壒鎺ㄥ嚭鏈�(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼锛屾暚璜�(q菒ng)闂�(gu膩n)娉ㄦ簼閫氳垏浜ゆ祦闋�(l菒ng)鍩熺殑瀵�(sh铆)韪愬拰鍕�(d貌ng)鎱�(t脿i)锛�锛�

銆€銆€>>>2012骞存渻(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼鍏嶈不(f猫i)瑭﹁伣(t墨ng)

銆€銆€>>>璨�(c谩i)鍕�(w霉)杌熶欢妯″<渚涙噳(y墨ng)閺堢鐞嗙殑娣卞堡鎳�(y墨ng)鐢�>瑾茬▼鏇存柊鍒嗕韩

銆€銆€>>> 鈥滆棟琛�(sh霉)鈥濇€х殑璨�(c谩i)鍕�(w霉)鍫�(b脿o)琛ㄥ浣曠悊瑙�      >>>绨�(ji菐n)杩帮細鍑虹磵瀵�(sh铆)鍕�(w霉)宸ヤ綔鐨勫熀鏈師鍓�

銆€銆€>>>浜嗚В杈︾悊浼佹キ(y猫)鎵€寰楃▍骞村害鐢冲牨(b脿o)绋嬪簭     >>>鐢熺敘(ch菐n)閬�(gu貌)绋嬬殑鎴愭湰鎺у埗鍩烘湰绋嬪簭

銆€銆€>>>2012鏈�(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼鐏啽鍫�(b脿o)鍚嶄腑<<<

銆€銆€8銆佸揩閫熸彃鍏ord琛ㄦ牸

銆€銆€Excel鍙互铏曠悊Word琛ㄦ牸涓垪鍑虹殑鏁�(sh霉)鎿�(j霉)锛屾偍鍙敤浠ヤ笅鏂规硶蹇€熸彃鍏ord琛ㄦ牸锛�

銆€銆€(1)鎵撻枊(k膩i)Word琛ㄦ牸鎵€鍦ㄧ殑鏂囦欢銆�

銆€銆€(2)鎵撻枊(k膩i)瑕佽檿鐞哤ord琛ㄦ牸鐨凟xcel鏂囦欢锛屽苟瑾�(di脿o)鏁村ソ鍏╃獥鍙ｇ殑浣嶇疆锛屼互渚胯兘鐪嬭(ji脿n)琛ㄦ牸鍜岃鎻掑叆琛ㄦ牸鐨勫崁(q奴)鍩�銆�

銆€銆€(3)閬镐腑Word涓殑琛ㄦ牸銆�

銆€銆€(4)鎸変綇榧犳(bi膩o)宸﹂嵉锛屽皣琛ㄦ牸鎷栧埌Excel绐楀彛涓紝鏉鹃枊(k膩i)榧犳(bi膩o)宸﹂嵉灏囪〃鏍兼斁鍦ㄩ渶瑕佺殑浣嶇疆鍗冲彲銆�

銆€銆€9銆佸揩閫熼張鎺ョ恫(w菐ng)涓婄殑鏁�(sh霉)鎿�(j霉)

銆€銆€鎮ㄥ彲浠ョ敤浠ヤ笅鏂规硶蹇€熷缓绔嬭垏缍�(w菐ng)涓婂伐浣滅翱涓暩(sh霉)鎿�(j霉)鐨勯張鎺ワ細

銆€銆€(1)鎵撻枊(k膩i)Internet涓婂惈鏈夐渶瑕侀張鎺ユ暩(sh霉)鎿�(j霉)鐨勫伐浣滅翱锛屽苟鍦ㄥ伐浣滅翱閬稿畾鏁�(sh霉)鎿�(j霉)锛岀劧鍚庡柈鎿娾€滅法杓€濊彍鍠殑鈥滃京(f霉)鍒垛€濆懡浠�銆�

銆€銆€(2)鎵撻枊(k膩i)闇€瑕�?ji菐ng)?chu脿ng)寤洪張鎺ョ殑Excel宸ヤ綔绨�锛屽湪闇€瑕侀’绀洪張鎺ユ暩(sh霉)鎿�(j霉)鐨勫崁(q奴)鍩熶腑锛屽柈鎿婂乏涓婅鍠厓鏍�銆�

銆€銆€(3)鍠搳鈥滅法杓€濊彍鍠腑鐨勨€滈伕鎿囨€х矘璨尖€濆懡浠わ紝鍦ㄢ€滈伕鎿囨€х矘璨尖€濆皪(du矛)瑭辨涓�锛岄伕鎿団€滅矘璨奸張鎺モ€濇寜閳曞嵆鍙€傝嫢鎮ㄦ兂鍦ㄥ壍(chu脿ng)寤洪張鎺ユ檪(sh铆)涓嶆墦闁�(k膩i)Internet宸ヤ綔绨�锛屽彲鍠搳闇€瑕侀張鎺ヨ檿鐨勫柈鍏冩牸锛岀劧鍚庨嵉鍏�(=)鍜孶RL鍦板潃鍙婂伐浣滅翱浣嶇疆銆�

銆€銆€10銆佸揩閫熷壍(chu脿ng)寤哄伐鍏锋瑒

銆€銆€閫氶亷(gu貌)宸ュ叿娆勬偍鍙互蹇嵎鍦拌í鍟�(w猫n)甯哥敤鐨勫懡浠ゆ垨鑷畾缇╃殑瀹�锛屾偍鍙互鏍规摎(j霉)闇€瑕佸揩閫熷壍(chu脿ng)寤鸿嚜宸辩殑宸ュ叿娆�銆傛柟娉曠偤锛�?ji菐n)铻曠盁鑲仦鎽鸿緢钘涙矁姊版懝鐧借繙顭墄鈥濆懡浠わ紝閬告搰鈥滃伐鍏锋瑒鈥濋伕闋�(xi脿ng)鍗�锛屽柈鎿娾€滄柊寤衡€濇寜閳�锛岃几鍏モ€滄柊寤哄伐鍏锋瑒鈥濆悕绋憋紝鐒跺悗鍠搳鈥滅⒑瀹氣€�銆傞€欐檪(sh铆)鏂板缓宸ュ叿娆勫嚭鐝�(xi脿n)鍦ㄧ獥鍙ｏ紝鎮ㄥ氨鍙互鐢ㄩ紶妯�(bi膩o)鎶婂叾浠栧伐鍏锋瑒涓殑鎸夐垥鎷栧埌鏂板缓宸ュ叿娆勪腑锛岃┎鎸夐垥灏辨渻(hu矛)鍦ㄦ鈥滆惤鎴垛€�銆傝嫢鍦ㄦ嫋鍕�(d貌ng)鏅�(sh铆)鎸夎憲Ctrl閸�锛屽墖鏈�(hu矛)灏囨寜閳曞京(f霉)鍒堕亷(gu貌)渚�(l谩i)銆傛敞鎰忥細涓嶈兘灏囨寜閳曟嫋鍒扳€滆嚜瀹氱京鈥濆皪(du矛)瑭辨鎴栧伐浣滆〃涓�锛屽惁鍓囪┎鎸夐垥灏囨渻(hu矛)琚埅闄ゃ€�

銆€銆€11銆佸揩閫熷壍(chu脿ng)寤哄伐浣滅翱

銆€銆€妯℃澘鏄竴鐢ㄤ締(l谩i)浣滅偤鍓�(chu脿ng)寤哄叾瀹冨伐浣滅翱鐨勬鏋跺舰寮�锛屽埄鐢ㄥ畠鍙互蹇€熷湴鍓�(chu脿ng)寤虹浉浼肩殑宸ヤ綔绨�銆傚壍(chu脿ng)寤烘ā鏉挎柟娉曠偤锛�

銆€銆€(1)鎵撻枊(k膩i)涓€鍊�(g猫)瑕佷綔鐐烘ā鏉跨殑宸ヤ綔绨�銆�

銆€銆€(2)閬告搰鈥滄枃浠垛€濊彍鍠腑鈥滃彟瀛樼偤鈥濆懡浠�锛屾墦闁�(k膩i)鈥滃彟瀛樼偤鈥濆皪(du矛)瑭辨銆�

銆€銆€(3)鍦ㄢ€滄枃浠跺悕鈥濇涓几鍏ユā鏉跨殑鍚嶅瓧锛屽緸鈥滀繚瀛橀鍨嬧€濆垪琛ㄤ腑閬稿畾鈥滄ā鏉�(*.xlt)鈥濋伕闋�(xi脿ng)锛岄€欐檪(sh铆)鈥滀繚瀛樹綅缃€濇渻(hu矛)鑷嫊(d貌ng)鍒囨彌鍒伴粯瑾�(r猫n)鐨勬ā鏉挎枃浠跺ぞTemplates鏂囦欢澶�銆�

銆€銆€(4)鍦ㄢ€滀繚瀛樹綅缃€濅腑閬告搰鈥滈浕瀛愯〃鏍兼ā鏉库€濇枃浠跺ぞ锛屽柈鎿娾€滀繚瀛樷€濆嵆鍙�銆傞€欐ǎ锛屾偍灏卞彲浠ユ牴鎿�(j霉)瑭叉ā鏉垮揩閫熷壍(chu脿ng)寤烘柊宸ヤ綔绨夸簡銆�

銆€銆€12銆佸揩閫熻烦杞�(zhu菐n)鍒板叾瀹冩枃浠�

銆€銆€鐢ㄨ秴绱�(j铆)閺堟帴鍦ㄥ悇鍊�(g猫)浣嶇疆涔嬮枔璺宠綁(zhu菐n)鍗佸垎鏂逛究锛岃嫢鎮ㄨ鍒囨彌鍒板叾瀹冩枃浠�锛屽彧闇€鐢ㄩ紶妯�(bi膩o)鎸囧悜甯舵湁涓嬪妰绶氱殑钘�(l谩n)鑹茶秴绱�(j铆)閺堟帴鏂囦欢锛岀劧鍚庡柈鎿婇紶妯�(bi膩o)鍗冲彲璺宠綁(zhu菐n)鍒拌秴绱�(j铆)閺堟帴鎵€鎸囧悜鐨勫瓙浣嶇疆涓婂幓锛岀湅瀹屽悗鑻ヨ杩斿洖锛屽彧闇€鍠搳鈥淲eb鈥濆伐鍏锋瑒涓婄殑鈥滆繑鍥炩€濇寜閳曞嵆鍙�銆�

銆€銆€鐠�(hu谩n)鐞冪恫(w菐ng)鏍＄壒鎺ㄥ嚭鏈�(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼锛屾暚璜�(q菒ng)闂�(gu膩n)娉ㄦ簼閫氳垏浜ゆ祦闋�(l菒ng)鍩熺殑瀵�(sh铆)韪愬拰鍕�(d貌ng)鎱�(t脿i)??锛�

銆€銆€>>>2012骞存渻(hu矛)瑷�(j矛)瀵�(sh铆)瑷�(x霉n)瑾茬▼鍏嶈不(f猫i)瑭﹁伣(t墨ng)

銆€銆€>>>璨�(c谩i)鍕�(w霉)杌熶欢妯″<渚涙噳(y墨ng)閺堢鐞嗙殑娣卞堡鎳�(y墨ng)鐢�>瑾茬▼鏇存柊鍒嗕韩

銆€銆€>>> 鈥滆棟琛�(sh霉)鈥濇€х殑璨�(c谩i)鍕�(w霉)鍫�(b脿o)琛ㄥ浣曠悊瑙�      >>>绨�(ji菐n)杩帮細鍑虹磵瀵�(sh铆)鍕�(w霉)宸ヤ綔鐨勫熀鏈師鍓�

銆€銆€>>>浜嗚В杈︾悊浼佹キ(y猫)鎵€寰楃▍骞村害鐢冲牨(b脿o)绋嬪簭     >>>鐢熺敘(ch菐n)閬�(gu貌)绋嬬殑鎴愭湰鎺у埗鍩烘湰绋嬪簭