Excelé常ç¨å ¬å¼å¦ä¸åèï¼
1ãAVERAGE è¿åéå®æ°æ®åºé¡¹çå¹³åå¼
2ãCOUNT 计ç®æ°æ®åºä¸å å«æ°åçåå æ ¼ç个æ°
3ãCOUNTA计ç®æ°æ®åºä¸é空åå æ ¼ç个æ°
4ãDGET ä»æ°æ®åºä¸æå满足æå®æ¡ä»¶çå个记å½
5ãMAX è¿åéå®æ°æ®åºé¡¹ä¸çæ大å¼
6ãMIN è¿åéå®æ°æ®åºé¡¹ä¸çæå°å¼
7ãPRODUCT ä¹ä»¥ç¹å®å段ï¼æ¤å段ä¸çè®°å½ä¸ºæ°æ®åºä¸æ»¡è¶³æå®æ¡ä»¶çè®°å½ï¼ä¸çå¼
8ãSTDEV æ ¹æ®æ°æ®åºä¸éå®é¡¹ç示ä¾ä¼°ç®æ ååå·®
9ãSTDEVP æ ¹æ®æ°æ®åºä¸éå®é¡¹çæ ·æ¬æ»ä½è®¡ç®æ ååå·®
10ãSUM 对æ°æ®åºä¸æ»¡è¶³æ¡ä»¶çè®°å½çå段åä¸çæ°åæ±å
11ãVAR æ ¹æ®æ°æ®åºä¸éå®é¡¹ç示ä¾ä¼°ç®æ¹å·®
12ãVARP æ ¹æ®æ°æ®åºä¸éå®é¡¹çæ ·æ¬æ»ä½è®¡ç®æ¹å·®
13ãGETPIVOTDATA è¿ååå¨å¨æ°æ®éè§è¡¨ä¸çæ°æ®
æ©å±èµæï¼
1ãLEFTå½æ°å½æ°å称ï¼LEFT主è¦åè½ï¼ä»ä¸ä¸ªææ¬å符串ç第ä¸ä¸ªå符å¼å§ï¼æªåæå®æ°ç®çå符ã使ç¨æ ¼å¼ï¼LEFT(text,num_chars)åæ°è¯´æï¼text代表è¦æªå符çå符串ï¼num_chars代表ç»å®çæªåæ°ç®ã
2ãRIGHTå½æ°å½æ°å称ï¼RIGHT主è¦åè½ï¼ä»ä¸ä¸ªææ¬å符串çæåä¸ä¸ªå符å¼å§ï¼æªåæå®æ°ç®çå符ã使ç¨æ ¼å¼ï¼RIGHT(text,num_chars)
3ãExcelæ¯åå ¬å®¤èªå¨åä¸é常éè¦çä¸æ¬¾è½¯ä»¶ï¼Excelå½æ°åæ¯Excelä¸çå ç½®å½æ°ãExcelå½æ°å ±å å«11ç±»ï¼åå«æ¯æ°æ®åºå½æ°ãæ¥æä¸æ¶é´å½æ°ãå·¥ç¨å½æ°ãè´¢å¡å½æ°ãä¿¡æ¯å½æ°ãé»è¾å½æ°ãæ¥è¯¢åå¼ç¨å½æ°ãæ°å¦åä¸è§å½æ°ãç»è®¡å½æ°ãææ¬å½æ°ä»¥åç¨æ·èªå®ä¹å½æ°ã