excel教程 怎么制作表格视频教程全集很多人对这个问题比较感兴趣，下面让我们一起来看excel琛ㄦ艰棰濡浣朵，希望可以帮助到你。
excel琛ㄦ?艰?棰?濡?浣??朵?
?镐俊寰?澶?灏?浼?浼撮?界?ラ????浠?????互浣跨?ㄨ〃?兼?ュ??瑙?棰???锛?浣????翠??ラ??瑕???涔???琛ㄦ?艰?棰????ｆ??浠??蜂?瑕???涔???????互???藉?琛ㄦ?煎?朵?瑙?棰?锛?涓??㈡???缂??寸????excel??涔???琛ㄦ?艰?棰???绋?锛?涓?璧峰?荤??????
1???瑰?绘???ュ?璞?br>2???ㄦ??寮???绐??ｄ腑锛??瑰?荤?辨??浠跺??寤洪??椤瑰?★??ㄧ?瑰?绘?瑙?;
3???ㄧ?佃??涓??惧?拌?棰???浠躲??
4???ㄧ??ｄ腑???炬?ュ?版??浠堕??椤硅〃绀烘??瑙?棰???浠朵互?炬?ョ???瑰????ュ??xcel琛ㄦ?间腑锛??剧ず涓哄?炬????琛ㄧず??互?剧ず瑙?棰???浠跺??寸??璺????濡?????涓??鹃??锛???瑙?棰???浠跺氨琚????ュ??xcel??
?????瑰?荤‘瀹?锛?瑙?棰???浠跺氨琚?????宓??ュ?拌〃?间腑?︺??浠ヤ?灏辨???缂?涓哄ぇ瀹舵?寸????excel??涔???琛ㄦ?艰?棰???绋?锛?绠???涓?姝ラ?锛???甯︿?杞绘??et涓?涓??版???斤?璧跺揩??繁?ㄦ??璇?璇??э?
MicrosoftOfficeExcel|
?ㄧ?佃??涓???涔??朵?琛ㄦ?艰?棰???绋?
?ㄧ?佃??涓??朵?琛ㄦ?肩????绋?濡?涓?锛?
1????寮?Excel锛????绘?板缓涓?涓?a href="https://zhidao.baidu.com/search?word=Excel琛ㄦ?? highlight="true">Excel琛ㄦ??/a>??
2????涓???板缓琛ㄦ?肩???哄??锛????婚????抽??????┾??璁剧疆?????兼?煎?????
3???ㄥ脊?虹??瀵硅?妗?涓????┾??杈规???杩?涓???绛鹃〉??
4?????╃孩?茬嚎妗?涓???杩?涓ら」锛?灏变???琛ㄦ?肩?????ㄥ??澶??ㄩ?借?缃??绾裤??
5??瀵硅?妗?宸︿晶杩???互璁剧疆绾挎?＄??绮?缁???棰??诧???互?规????繁????瑕????┿??
6??璁剧疆瀹???琛ㄦ?肩??杈规?锛????烩??纭?????????杩??疯〃?煎氨?朵?瀹???浜???
excel?朵?琛ㄦ?肩??姝ラ???绋?
??xcel??琛ㄦ?兼???ㄦ??浠???娲讳腑寰?甯哥?ㄧ?????斤??ｄ?浣??ラ??瑕???涔???xcel??琛ㄦ?煎??涓??㈡??涓哄ぇ瀹跺甫?ヤ?excel?朵?琛ㄦ?肩??姝ラ???绋?_??xcel?朵?琛ㄦ?兼?楠わ?甯?????互甯??╁?板ぇ瀹?
???
excel?朵?琛ㄦ?肩??姝ラ???绋?
18涓?xcel??甯哥?ㄧ?????杩?绠???宸ф?荤?
Excel?芥?板???澶у?ㄦ?规?瑙ｈ?
excel?朵?琛ㄦ?肩??姝ラ???绋??ㄦ?????抽???瑰?诲?ㄥ揩?疯????涓????┾??灞???--?板缓excel宸ヤ?琛ㄢ???戒护
2?藉???板缓??琛ㄦ?煎??涓衡???版???璁♀??锛????绘??寮???浠?/p>
3璁剧疆濂借〃?肩????浣????村?崇焊寮?澶у?锛?杩???璁剧疆涓?4锛?椤甸?㈠?灞?--绾稿?澶у?--A4
4???╅〉?㈠????????琛?锛??抽???瑰?婚???┾??琛?楂????戒护锛?璁惧?濂借?楂?
5???╄〃澶翠?缃????????硷??抽???瑰?婚???┾??璁剧疆?????兼?煎???
6?ㄢ??璁剧疆?????兼?煎???瀵硅?妗?涓????┾??瀵归?????椤瑰?★??鹃??????骞跺?????尖??锛??瑰?烩??纭????????/p>
7??骞跺???杈??ユ??瀛????版???璁¤〃姹??烩??锛?骞跺??跺?涓?/p>
8杈??ユ?版???杩???????ヤ??ㄥ??
9???╄〃?兼?版?????ㄧ???????硷??瑰?诲?抽?????┾??璁剧疆?????兼?煎????戒护锛??ㄥ?璇?妗?涓????┾??杈规?????椤瑰?★?璁剧疆琛ㄦ?兼??剁嚎?＄?缁?锛?璁剧疆瀹??瑰?烩??纭????
10琛ㄦ?肩???烘???缃??????锛?杈??ユ?版???淇?瀛??冲???琛ㄦ?煎缓瀹?浜?
<<< 18涓 Excel ??甯哥?ㄧ?????杩?绠???宸 ?荤?涓????ユ?鹃??澶???瀹瑰???锛?=IF(COUNTIF(A:AA2)>1????澶?????")??
浜????ㄥ?虹??骞存???ヨ?绠?骞撮????锛?=TRUNC((DAYS360(H6??2009/8/30??ALSE))/3600)??
涓???浠?杈??ョ??18浣?韬?唤璇??风???虹??骞存??璁＄????锛?=CONCATENATE(MID(E274)??/??MID(E2112)??/??MID(E2132))??
????浠?杈??ョ??韬?唤璇??风????璁╃郴缁????ㄦ?????у?????互杈??ヤ互涓????锛?=IF(LEN(C2)=15IF(MOD(MID(C2151)2)=1???封????濂斥??)IF(MOD(MID(C2171)2)=1???封????濂斥??))?????????C2??浠ｈ〃??????ヨ韩浠借??风?????????笺??
浜???姹???锛? =SUM(K2:K56) ????瀵?2??56杩?涓??哄??杩?琛?姹???;
????骞冲???帮? =AVERAGE(K2:K56) ????瀵?2 K56杩?涓??哄??姹?骞冲????
涓???????锛? =RANK(K2锛?K$2:K$56) ????瀵?5??瀛︾??????缁╄?琛?????;
????绛?绾э? =IF(K2>=85??浼???IF(K2>=74??????IF(K2>=60?????尖????涓????尖??)))
涔???瀛︽???昏?锛? =K2_0.3+M2_0.3+N2_0.4 ??????璁?????M????N????????剧??瀛︾??????骞虫?舵?昏?????????涓?????????????涓?椤规??缁?
??????楂???锛? =MAX(K2:K56) ????姹?K2??56?哄??(55??瀛︾??)????楂???;
??涓?????浣???锛? =MIN(K2:K56) ????姹?K2??56?哄??(55??瀛︾??)????浣???;
??浜??????版?浜烘?扮?璁★?
(1) =COUNTIF(K2:K56??100?? ????姹?K2??56?哄??100????浜烘????璁炬??缁???瀛??句?K57??????
(2) =COUNTIF(K2:K56??>=95??-K57 ????姹?K2??56?哄??95锝?99.5????浜烘????璁炬??缁???瀛??句?K58??????
(3)=COUNTIF(K2:K56??>=90??-SUM(K57:K58) ????姹?K2??56?哄??90锝?94.5????浜烘????璁炬??缁???瀛??句?K59??????
(4)=COUNTIF(K2:K56??>=85??-SUM(K57:K59) ????姹?K2??56?哄??85锝?89.5????浜烘????璁炬??缁???瀛??句?K60??????
(5)=COUNTIF(K2:K56??>=70??-SUM(K57:K60) ????姹?K2??56?哄??70锝?84.5????浜烘????璁炬??缁???瀛??句?K61??????
(6)=COUNTIF(K2:K56??>=60??-SUM(K57:K61) ????姹?K2??56?哄??60锝?69.5????浜烘????璁炬??缁???瀛??句?K62??????
(7) =COUNTIF(K2:K56??<60?? ????姹?K2??56?哄??60??浠ヤ???浜烘????璁炬??缁???瀛??句?K63??????
璇存??锛?COUNTIF?芥?颁????绠???涓??哄???枫??濂崇??浜烘?般??
濡?锛?=COUNTIF(C2:C351???封??) ????姹?C2??351?哄??(??50浜??锋?т汉??
??涓???浼?绉???锛? =SUM(K57:K60)/55_100
?????????肩??锛? =SUM(K57:K62)/55_100
??浜???????宸?? =STDEV(K2:K56) ????姹?K2??56?哄??(55浜?????缁╂尝?ㄦ?????板?艰?灏?锛?璇存??璇ョ??????寸????缁╁樊寮?杈?灏?锛???涔?锛?璇存??璇ョ????ㄤ袱??????);
???????′欢姹???锛? =SUMIF(B2:B56???封??锛?K2:K56) ??????璁???瀛??惧??????у???K??瀛??惧????????帮???姝ゅ?芥?拌?????缁???琛ㄧず姹?璇ョ???风??????缁╀???;
??涓??? 澶??′欢姹???锛? {=SUM(IF(C3:C322=???封??IF(G3:G322=110)))锝? ??????璁???(C3:C322?哄??)瀛??惧??????у???G??(G3:G322?哄??)瀛??惧??????ㄧ??骇浠ｇ??(1??2??3??4??5)锛???姝ゅ?芥?拌?????缁???琛ㄧず姹? 涓??????风??浜烘??杩????涓??扮??芥?帮?杈?瀹???瑕???Ctrl+Shift+Enter缁?????浜х????{?︹?︼???)????{锝???涓??芥??宸ヨ??ワ????界?ㄧ?????骇????
???????规???虹???ユ?????ㄨ?绠??ㄥ?锛?=TRUNC((DAYS360(D3NOW( )))/3600)
<<<
Excel?芥?板???澶у? ?规? 瑙ｈ?涓????′欢?ゆ???IF?芥?般??
????锛??ゆ????缁╂??灞???绛?娆°??
?规?锛?
1????瀹??????????笺??
2???ㄧ?????????间腑杈??ュ???锛?=IF(C3>=90."浼?绉?",IF(C3>=80."??ソ",IF(C3>=60."????quot;,"涓?????quot;)))??
3??Ctrl+Enter濉?????
瑙ｈ?锛?
IF?芥?版???′欢?ゆ???芥?帮??规???ゆ?????杩???瀵瑰????硷?濡????ゆ???′欢涓?RUE锛???杩???绗??涓????帮?濡???涓?ALSE锛???杩???绗??涓????般??
浜????′欢姹???锛?SUMIF??SUMIFS?芥?般??
????锛?姹??风?????绘??缁╁???风??涓????板ぇ浜?绛?浜?80?????绘??缁┿??
?规?锛?
1???ㄥ?搴????????????间腑杈??ュ???锛?=SUMIF(D3:D9."??quot;,C3:C9)??=SUMIFS(C3:C9.C3:C9.">=80",D3:D9."??quot;)??
瑙ｈ?锛?
1??SUMIF?芥?扮?ㄤ????′欢姹??????ㄦ????′欢???芥??涓?涓?????瑙ｈ?娉?缁???涓猴?SUMIF(?′欢???达??′欢锛?姹?????????
2??SUMIFS?芥?扮?ㄤ?澶??′欢姹??????ㄦ????′欢??互??澶?涓?????瑙ｈ?娉?缁???锛?SUMIFS(姹??????达??′欢1???达??′欢1.?′欢2???达??′欢2.?︹?︽?′欢N???达??′欢N)??
涓????′欢璁℃?帮?COUNTIF??COUNTIFS?芥?般??
????锛?璁＄??风????浜烘?版???风??涓???缁?gt;=80????浜烘?般??
?规?锛?
1???ㄥ?搴????????????间腑杈??ュ???锛?=COUNTIF(D3:D9."??quot;)??=COUNTIFS(D3:D9."??quot;,C3:C9.">=80")??
瑙ｈ?锛?
1??COUNTIF?芥?扮?ㄤ????′欢璁℃?帮??ㄨ??版?′欢???芥??涓?涓?????瑙ｈ?娉?缁???涓猴?COUNTIF(?′欢???达??′欢).
2??COUNTIFS?芥?扮?ㄤ?澶??′欢璁℃?帮??ㄨ??版?′欢??互??澶?涓?????瑙ｈ?娉?缁???涓猴?COUNTIFS(?′欢????.?′欢1.?′欢????.?′欢2?︹?︽?′欢????锛??′欢N)??
?????版???ヨ?锛?VLOOKUP?芥?般??
????锛??ヨ??稿?充汉??瀵瑰?????缁┿??
?规?锛?
?ㄧ?????????间腑杈??ュ???锛?=VLOOKUP(H3.B3:C9.2.0)??
瑙ｈ?锛?
?芥??LOOKUP???烘?????藉氨???版???ヨ?????瑙ｈ?娉?缁???涓猴?VLOOKUP(?ユ?剧???硷??ユ?捐???达??炬?ユ?捐???翠腑??绗?????锛?绮惧???归??杩???ā绯??归??)??
浜????????ヨ?锛?LOOKUP?芥?般??
????锛??规?????濮????ヨ?瀵瑰???瀛﹀?枫??
?规?锛?
?ㄧ?????????间腑杈??ュ???锛?=LOOKUP(1.0/(B3:B9=H3),A3:A9)??
瑙ｈ?锛?
???LOOKUP?芥?扮??璇??缁???涓猴?LOOKUP(?ユ?剧???硷??ユ?剧???′欢锛?杩????肩??????????ず渚?涓?娇?ㄧ??浣???寮??ㄦ????ユ?剧???间负1.?′欢涓?.?规??OOKUP?芥?扮???圭?癸?濡??? LOOKUP ?芥?版?句?? lookup_value锛???璇ュ?芥?颁?涓? lookup_vector 涓??浜???绛?浜? lookup_value ????澶у?艰?琛??归????
?????ヨ?濂芥??。锛?INDEX+MATCH ?芥??/p>
????锛??规??????ヨ?瀵瑰???绛?娆°??
?规?锛?
?ㄧ?????????间腑杈??ュ???锛?=INDEX(E3:E9.MATCH(H3.B3:B9.0))??
瑙ｈ?锛?
1??INDEX?芥?帮?杩???缁?瀹????村??琛???浜ゅ??澶????笺??
2??MATCH?芥?帮?缁??烘??瀹??煎?ㄦ??瀹????村???????ㄤ?缃???
3?????锛?=INDEX(E3:E9.MATCH(H3.B3:B9.0))锛??ヨ?E3:E9涓??MATCH(H3.B3:B9.0)琛????硷?骞惰?????
涓????????虹??骞存??锛?TEXT+MID?芥?般??
????锛?浠???瀹???韬?唤璇??风??涓??????哄?诲勾????
?规?锛?
1????瀹??????????笺??
2??杈??ュ???锛?=TEXT(MID(C3.7.8),"00-00-00")??
3??Ctrl+Enter濉?????
瑙ｈ?锛?
1???╃??ID?芥?颁?C3?????间腑????浠?绗?涓??濮?锛??垮害涓???瀛?绗︿覆??
2???╃??EXT?芥?板?瀛?绗︾???煎?杞???负??00-00-00?????煎?锛???965-08-21.
????璁＄?骞撮?锛?DATEDIF?芥?般??
????锛??规????虹??韬?唤璇??疯?绠??哄?搴???骞撮???
?规?锛?
1????瀹??????????笺??
2??杈??ュ???锛?=DATEDIF(TEXT(MID(C3.7.8),"00-00-00"),TODAY(),"y")&"?ㄥ?"??
3??Ctrl+Enter濉?????
瑙ｈ?锛?
1???╃??ID?峰??C3?????间腑浠?绗?涓??濮?锛??垮害涓???瀛?绗︿覆??
2????ext?芥?板?瀛?绗︿覆杞???负锛?00-00-00???煎?????965-08-21.
3???╃??ATEDIF?芥?拌?绠??哄??褰????ユ??(TODAY())???稿樊骞翠唤(y)??
涔???涓??藉?????锛?SUMPRODUCT+COUNTIF?芥?般??
????锛?瀵规??缁╄?琛???????
?规?锛?
1????瀹??????????笺??
2???ㄧ?????????间腑杈??ュ???锛?=SUMPRODUCT((C$3:C$9>C3)/COUNTIF(C$3:C$9.C$3:C$9))+1.
3??Ctrl+Enter濉?????
瑙ｈ?锛???????????ㄥ??(C$3:C$9>C3)杩????????涓??扮?锛??哄??C$3:C$9涓?ぇ浜?C3???????间釜?般???????ㄥ??COUNTIF(C$3:C$9.C$3:C$9)??互??瑙ｄ负锛?_1/COUNTIF(C$3:C$9.C$3:C$9),???COUNTIF(C$3:C$9.C$3:C$9)杩??????间负1.?????ㄤ?杈??╄?绠?????浠ヤ?杩板???涔???互绠???涓猴?=SUMPRODUCT((C$3:C$9>C3)_1)+1.
<<<
excel?朵?琛ㄦ?肩??姝ラ???绋??稿? ??绔? 锛?
?? excel琛ㄦ?煎?朵???绋?
?? Excel琛ㄦ?煎?烘????浣???绋?
?? excel?朵?琛ㄦ?肩??姝ラ???绋?
?? Excel涓?〃?煎?朵??炬????绋????规?
?? excel?朵?琛ㄦ?肩???规?姝ラ??
?? Excel琛ㄦ?煎?朵??捐〃???规???绋??ㄨВ
?? ??绠?????琛ㄦ?煎?朵??规???宸
?? excel琛ㄦ?煎?朵?娴?绋??剧???规?姝ラ?
?? excel?朵?婕?浜?〃?肩???规?姝ラ??
var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?1fc3c5445c1ba79cfc8b2d8178c3c5dd"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })();