銆€銆€绉樻浉(sh奴)璩囨牸鑰冭│(浜旂礆(j铆))杈﹀伐鑷嫊(d貌ng)鍖�:Excel浣跨敤鎶€宸�$lesson$

銆€銆€鍦ㄥ伐浣滅暥(d膩ng)涓敤闆诲瓙琛ㄦ牸渚�(l谩i)铏曠悊鏁�(sh霉)鎿�(j霉)灏囨渻(hu矛)鏇村姞杩呴€熴€佹柟渚�锛岃€屽湪鍚勭ó闆诲瓙琛ㄦ牸铏曠悊杌熶欢涓紝Excel浠ュ叾鍔熻兘寮�(qi谩ng)澶�銆佹搷浣滄柟渚胯憲绋�(ch膿ng)锛岃磸寰椾簡寤ｅぇ鐢ㄦ埗(h霉)鐨勯潚鐫�銆傞洊鐒禘xcel浣跨敤寰堢啊(ji菐n)鍠紝涓嶉亷(gu貌)鐪熸鑳界敤濂紼xcel鐨勭敤鎴�(h霉)骞朵笉澶�锛屽緢澶氫汉涓€鐩村仠鐣欏湪閷勫叆鏁�(sh霉)鎿�(j霉)鐨勬按骞筹紝鏈枃灏囧悜浣犱粙绱逛竴浜涢潪甯镐娇鐢ㄧ殑鎶€宸�锛屾帉鎻￠€欎簺鎶€宸у皣澶уぇ鎻愰珮浣犵殑宸ヤ綔鏁堢巼銆�

銆€?銆佺鐒栦浚顭墄宸ヤ綔绨挎牸寮�杞�(zhu菐n)鑷挵(hu谩n) 鐞� 缍�(w菐ng) 鏍du24ol.com

銆€銆€棣栧厛閬稿畾闇€瑕佸畾缇╂牸寮忕殑宸ヤ綔绨胯寖鍦�锛屽柈鎿娾€滄牸寮忊€濊彍鍠殑鈥滄ǎ寮忊€濆懡浠�锛屾墦闁�(k膩i)鈥滄ǎ寮忊€濆皪(du矛)瑭�(hu脿)妗�;鐒跺悗寰炩€滄ǎ寮忓悕鈥濆垪琛ㄦ涓伕鎿囧悎閬╃殑鈥滄ǎ寮忊€濈ó椤�(l猫i)锛屽緸鈥滄ǎ寮忓寘鎷€濆垪琛ㄦ涓伕鎿囨槸鍚︿娇鐢ㄨ┎绋ǎ寮忕殑鏁�(sh霉)瀛�銆佸瓧楂斻€佸皪(du矛)榻�銆侀倞妗�銆佸湒妗�銆佷繚璀�(h霉)绛夋牸寮忓収(n猫i)瀹�;鍠搳鈥滅⒑瀹氣€濇寜閳曪紝闂�(gu膩n)闁夆€滄ǎ寮忊€濆皪(du矛)瑭�(hu脿)妗�锛孍xcel宸ヤ綔绨跨殑鏍煎紡灏辨渻(hu矛)鎸夌収鐢ㄦ埗(h霉)鎸囧畾鐨勬ǎ寮忕櫦(f膩)鐢熻畩鍖栵紝寰炶€屾豢(m菐n)瓒充簡鐢ㄦ埗(h霉)蹇€�銆佸ぇ鎵瑰畾缇╂牸寮忕殑瑕佹眰銆�

銆€銆€鈷夊揩閫�?g貌u)?f霉)鍒跺叕寮�

銆€銆€寰�(f霉)鍒舵槸灏囧叕寮忔噳(y墨ng)鐢ㄤ簬鍏跺畠鍠厓鏍肩殑鎿嶄綔锛屾渶甯哥敤鐨勬湁浠ヤ笅骞剧ó鏂规硶锛�

銆€銆€涓€鏄嫋鍕�(d貌ng)鍒跺京(f霉)鍒躲€傛搷浣滄柟娉曟槸锛氶伕涓瓨鏀惧叕寮忕殑鍠厓鏍�锛岀Щ鍕�(d貌ng)绌哄績鍗佸瓧鍏夋(bi膩o)鑷冲柈鍏冩牸鍙充笅瑙掋€傚緟鍏夋(bi膩o)璁婃垚灏忓(sh铆)蹇冨崄瀛楁檪(sh铆)锛屾寜浣忛紶妯�(bi膩o)宸﹂嵉娌垮垪(灏�(du矛)琛岃▓(j矛)绠楁檪(sh铆))鎴栬(灏�(du矛)鍒楄▓(j矛)绠楁檪(sh铆))鎷栧嫊(d貌ng)锛岃嚦鏁�(sh霉)鎿�(j霉)绲�(ji茅)灏惧畬鎴愬叕寮忕殑寰�(f霉)鍒跺拰瑷�(j矛)绠�銆傚叕寮忓京(f霉)鍒剁殑蹇參鍙敱灏忓(sh铆)蹇冨崄瀛楀厜妯�(bi膩o)璺濊櫅妗嗙殑閬�(yu菐n)杩戜締(l谩i)瑾�(di脿o)绡€(ji茅)锛氬皬瀵�(sh铆)蹇冨崄瀛楀厜妯�(bi膩o)璺濊櫅妗嗚秺閬�(yu菐n)锛屽京(f霉)鍒惰秺蹇�;鍙嶄箣锛屽京(f霉)鍒惰秺鎱�銆�

銆€銆€涔熷彲浠ヨ几鍏ュ京(f霉)鍒�銆傛娉曟槸鍦ㄥ叕寮忚几鍏ョ祼(ji茅)鏉熷悗绔嬪嵆瀹屾垚鍏紡鐨勫京(f霉)鍒�銆傛搷浣滄柟娉曪細閬镐腑闇€瑕佷娇鐢ㄨ┎鍏紡鐨勬墍鏈夊柈鍏冩牸锛岀敤涓婇潰浠嬬垂鐨勬柟娉曡几鍏ュ叕寮忥紝瀹屾垚鍚庢寜浣廋trl閸靛苟鎸夊洖杌�(ch膿)閸�锛岃┎鍏紡灏辫寰�(f霉)鍒跺埌宸查伕涓殑鎵€鏈夊柈鍏冩牸銆�

銆€銆€閭勫彲浠ラ伕鎿囨€х矘璨�銆傛搷浣滄柟娉曟槸锛氶伕涓瓨鏀惧叕寮忕殑鍠厓鏍�锛屽柈鎿奅xcel宸ュ叿娆勪腑鐨勨€滃京(f霉)鍒垛€濇寜閳�銆傜劧鍚庨伕涓渶瑕佷娇鐢ㄨ┎鍏紡鐨勫柈鍏冩牸锛屽湪閬镐腑鍗€(q奴)鍩熷収(n猫i)鍠搳榧犳(bi膩o)鍙抽嵉锛岄伕鎿囧揩鎹烽伕鍠腑鐨勨€滈伕鎿囨€х矘璨尖€濆懡浠�銆傛墦闁�(k膩i)鈥滈伕鎿囨€х矘璨尖€濆皪(du矛)瑭�(hu脿)妗嗗悗閬镐腑鈥滅矘璨尖€濆懡浠わ紝鍠搳鈥滅⒑瀹氣€�锛屽叕寮忓氨琚京(f霉)鍒跺埌宸查伕涓殑鍠厓鏍�銆�

銆€?銆佹櫒鐒栦籂@绀哄柈鍏冩牸涓殑鍏紡

銆€銆€濡傛灉宸ヤ綔琛ㄤ腑鐨勬暩(sh霉)鎿�(j霉)澶氭暩(sh霉)鏄敱鍏紡鐢熸垚鐨�锛屽鏋滄兂瑕佸揩閫熺煡閬撴瘡鍊�(g猫)鍠厓鏍间腑鐨勫叕寮忓舰寮忥紝鍙互閫欐ǎ鍋氾細鐢ㄩ紶妯�(bi膩o)宸﹂嵉鍠搳鈥滃伐鍏封€濊彍鍠�锛岄伕鍙栤€滈伕闋�(xi脿ng)鈥濆懡浠�锛屽嚭鐝�(xi脿n)鈥滈伕闋�(xi脿ng)鈥濆皪(du矛)瑭�(hu脿)妗�锛屽柈鎿娾€滆鍦栤€濋伕闋�(xi脿ng)鍗★紝鎺ヨ憲瑷�(sh猫)缃€滅獥鍙ｉ伕闋�(xi脿ng)鈥濇瑒涓嬬殑鈥滃叕寮忊€濋爡(xi脿ng)鏈夋晥锛屽柈鎿娾€滅⒑瀹氣€濇寜閳�銆傞€欐檪(sh铆)姣忓€�(g猫)鍠厓鏍间腑鐨勫叕寮忓氨椤ず鍑轰締(l谩i)浜�銆傚鏋滄兂鎭㈠京(f霉)鍏紡瑷�(j矛)绠楃祼(ji茅)鏋滅殑椤ず锛屽啀瑷�(sh猫)缃€滅獥鍙ｉ伕闋�(xi脿ng)鈥濇瑒涓嬬殑鈥滃叕寮忊€濋爡(xi脿ng)澶辨晥鍗冲彲銆�

銆€?銆佺函鐒栬潮h闄ょ┖琛�

銆€銆€鏈夋檪(sh铆)鐐轰簡鍒櫎Excel宸ヤ綔绨夸腑鐨勭┖琛�锛屼綘鍙兘鏈�(hu矛)灏囩┖琛屼竴涓€鎵惧嚭鐒跺悗鍒櫎锛岄€欐ǎ鍋氶潪甯镐笉鏂逛究銆備綘鍙互鍒╃敤鈥滆嚜鍕�(d貌ng)绡╅伕鈥濆姛鑳戒締(l谩i)绨�(ji菐n)鍠(sh铆)鐝�(xi脿n)銆傚厛鍦ㄨ〃涓彃鍏ユ柊鐨勪竴琛�(鍏ㄧ┖)锛岀劧鍚庨伕鎿囪〃涓墍鏈夌殑琛�锛岄伕鎿団€滄暩(sh霉)鎿�(j霉)鈥濊彍鍠腑鐨勨€滅閬糕€濓紝鍐嶉伕鎿団€滆嚜鍕�(d貌ng)绡╅伕鈥濆懡浠�銆傚湪姣忎竴鍒楃殑闋�(xi脿ng)閮紝寰炰笅鎷夊垪琛ㄤ腑閬告搰鈥滅┖鐧解€�銆傚湪鎵€鏈夋暩(sh霉)鎿�(j霉)閮借閬镐腑鐨勬儏娉佷笅锛岄伕鎿団€滅法杓€濊彍鍠腑鐨勨€滃埅闄よ鈥�锛岀劧鍚庢寜鈥滅⒑瀹氣€濆嵆鍙�銆傛墍鏈夌殑绌鸿灏囪鍒幓銆傛彃鍏ヤ竴鍊�(g猫)绌鸿鏄偤浜嗛伩鍏嶅埅闄ょ涓€琛屾暩(sh霉)鎿�(j霉)銆�

銆€?銆佸簳瑭�?d貌ng)鍒囨彌杓稿叆娉�杞�(zhu菐n)鑷挵(hu谩n) 鐞� 缍�(w菐ng) 鏍du24ol.com

銆€銆€鐣�(d膩ng)浣犱娇鐢‥xcel 2000绶ㄨ集鏂囦欢鏅�(sh铆)锛屽湪涓€寮靛伐浣滆〃涓€氬父鏄棦鏈夋饥瀛�锛屽張鏈夊瓧姣嶅拰鏁�(sh霉)瀛�锛屼簬鏄皪(du矛)浜庝笉鍚岀殑鍠厓鏍硷紝闇€瑕佷笉鏂峰湴鍒囨彌涓嫳鏂囪几鍏ユ柟寮�锛岄€欎笉鍍呴檷浣庝簡绶ㄨ集鏁堢巼锛岃€屼笖璁撲汉涓嶅嫕鍏剁叐銆傚湪姝�锛岀瓎鑰呬粙绱逛竴绋柟娉曪紝璁撲綘鍦‥xcel 2000涓皪(du矛)涓嶅悓椤�(l猫i)鍨嬬殑鍠厓鏍�锛屽(sh铆)鐝�(xi脿n)杓稿叆娉曠殑鑷嫊(d貌ng)鍒囨彌銆�

銆€銆€鏂板缓鎴栨墦闁�(k膩i)闇€瑕佽几鍏ユ饥瀛楃殑鍠厓鏍煎崁(q奴)鍩�锛屽柈鎿娾€滄暩(sh霉)鎿�(j霉)鈥濊彍鍠腑鐨勨€滄湁鏁堟€р€�锛屽啀閬告搰鈥滆几鍏ユ硶妯″紡鈥濋伕闋�(xi脿ng)鍗�锛屽湪鈥滄ā寮忊€濅笅鎷夊垪琛ㄦ涓伕鎿団€滄墦闁�(k膩i)鈥�锛屽柈鎿娾€滅⒑瀹氣€濇寜閳曘€�

 ?2012骞寸鏇�(sh奴)璩囨牸鑰冭│缍�(w菐ng)绲�(lu貌)杓斿皫(d菐o)鎷涚敓绨�(ji菐n)绔�

?鐠�(hu谩n)鐞冪恫(w菐ng)鏍￠殕閲嶆帹鍑虹鏇�(sh奴)璩囨牸缍�(w菐ng)涓婅紨灏�(d菐o) 浜旀姌鐗规儬锛�

鏇村淇℃伅璜�(q菒ng)?ji膩n)L鍟�(w猫n)锛�绉樻浉(sh奴)璩囨牸闋婚亾    绉樻浉(sh奴)璩囨牸鑰冭│璜栧