excel高级使用技巧.pdf

《excel高级使用技巧.pdf》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、

 !"#$%&'()*+,-./012345
6789:;<=>

?@A
BCA
D
E
FG,-7HIJ,-K
LMNOPQRSTUK
VWMNXYZ.[],-K6MN^_,-4N`,-GK
LMaEFbcK66
M,-7HIJ,-K66
MNOPQ)de66
Uf
NXYZ.[g],-KhMEijklFN^_,-K66
MaE

2、FWm,-7Hn,-KVWMNIJ,-KLMN`opqr5sa7Hn,-tuWmNvwxKyz{

3、}~MaEF7H-NAa]w-KMKMlN^_N)BN ¡¢NKM£N KM¤¥N¦§KM£N ¨KM ©ªN«¬xc® ¨KMNK¯Mv°E7
Fa±EF²³®,-´µ ¶·®µw¸¹-µwfºN w³®N^_v»yz{

4、N`¼½¾x¿ÀÁÂÂz
DÀÁÂÂzÃIJ ¨Än,-´µ ²·®NJÅSÆÇw·

5、®,-ÈÉ´µfNºÈÉfQ)§Ê SË®Ìa,-ÍÎÌ_N`ÏvxÐÑyz{

6、N^_@AB¾Ò ¨²·®NX3ÈÉ®ÓONÔÕw³®,-fQJŧʠSË®aE"FÖ×صwf w·Nv»yz{

7、NABSÙNrRÈÉÚÛÜ saÝ,-fN^_v»yz{

8、NµºowxpqNÒÞ ܧÊsÈwfaE#Fß7H®f²[àßáâNnãäåæç·ßèNéêëNÈìíAB¾KîM£N ïK ©M¤¥N§ÊK ©MðñNKòM

9、 ©ªNJÅó¹K¼½ ©MôxKßM©ÞõNK¯Mv°E7FaȺç·Gr§Ãsa7Hö÷ß&'øHNr`ó¹K¼½ ©MôxKßM©ùõúaûE(FAyz{

10、ü ïjý7Hw·®Þþ²f®ºN
 ®·N^_vxyz{

11、ü ·®ayz{

12、ü ÝUf ÒÞfÝaÈì鯠ïf®NÞõ9:@A)B. ïݺÊ!aE/Fãä3 7Hn23  Ë0

13、NrÖCA N^_vÂ

14、ÂzÂ.san3!Ax. n3"#~KM£K3M©KÚÛM¤¥NÈÉrö÷sýÃ$%aD Ázz&'LL(((Á)*+Â*,)-L&,L).LÂ/,Â

15、0LÂ/0
6Áz-fÄnNÞº12c3yc 45N7H55NIJAK6*MK78MÃÍâ9N:7HÞ¶;5NrÖÈìZsaXYZ.[y5_<-w·4cE7Hc=Þ NrIJc9FN>
,-K?2
@y
MN
c r[2DyAc

16、sa 
NABBx¿CDKEMNtFBTâGüG_Nv»B)FBxnøH5INrÍâs2cycaȺ]ÖnJÅ12cyc23N]n1cøH÷wxN`AK ¨K78M¤¥NRf78 w·4cÑaȺ`2L2DyDcfax$[w·K@MMNCAOPaAQRz)yQºNÞSTUVWyVXYZ[BN]^º_AÈÉ`aYafUK/NbMèNg]V/,Â

17、,-[BcNR/[Bca-QcNb[Bca- 2cN^_AK@MRQc2câycNy

18、
,-?Q
@GNG@2
Nºy
fèrndsN`ABx)y
NÍâQc2cÒÞ E7eFaÖµ NfÞwg.[AyhiyQjViQjVNA[R¡¢jklw·klNîm9UK?yhiyQjViQjVE2
!y
FMan7Noówpqár_s®N2tuKvgMD2tuKpwxMN2#tuyNz{,-K?yhiyQjViQjVEGýÏpqár_søHGN2NGGN2NGUGN2#NGLß

19、aGFM&'øHUýÏpqár_sø

20、HpwxvgULß

21、a}~DåæNANMÊvaw·AOPNr[P&áâºN,-"6xGºNUKÖM~,-"6ÑGºNUKGaÈìõHNAþéMÊaoóâQNdeøHQaz{Q,-ß?EQ"6NKÖMNKMFµºNfSËaO7N7H,-?EQ"6NKÖMNEQ?/6NKMNKGFFr1âGâs·a7H,-?EQ"6NKGNEQ?#6NKMNEQ/6NKMNKMFFFr1âGUs·a