-- ·|­û / µù¥U -- ¡@
¡@±b¸¹¡G
¡@±K½X¡G
¡@ | µù¥U | §Ñ°O±K½X
3/26 ·s®Ñ¨ì¡I 3/19 ·s®Ñ¨ì¡I 3/14 ·s®Ñ¨ì¡I 12/12 ·s®Ñ¨ì¡I
ÁʮѬyµ{¡EQ & A¡E¯¸°È¯d¨¥ª©¡E«ÈªA«H½c
¢x 3ds Max¢x Maya¢x Rhino¢x After Effects¢x SketchUp¢x ZBrush¢x Painter¢x Unity¢x
¢x PhotoShop¢x AutoCad¢x MasterCam¢x SolidWorks¢x Creo¢x UG¢x Revit¢x Nuke¢x
¢x C#¢x C¢x C++¢x Java¢x ¹CÀ¸µ{¦¡¢x Linux¢x ´O¤J¦¡¢x PLC¢x FPGA¢x Matlab¢x
¢x Àb«È¢x ¸ê®Æ®w¢x ·j¯Á¤ÞÀº¢x ¼v¹³³B²z¢x Fluent¢x VR+AR¢x ANSYS¢x ²`«×¾Ç²ß¢x
¢x ³æ´¹¤ù¢x AVR¢x OpenGL¢x Arduino¢x Raspberry Pi¢x ¹q¸ô³]­p¢x Cadence¢x Protel¢x
¢x Hadoop¢x Python¢x Stm32¢x Cortex¢x Labview¢x ¤â¾÷µ{¦¡¢x Android¢x iPhone¢x
¥i¬d®Ñ¦W,§@ªÌ,ISBN,3dwoo®Ñ¸¹
¸Ô²Ó®ÑÄy¤ÀÃþ

¯u¥¿¾Ç·|Excel¨ç¼Æªº8°ó½Ò

( ÁcÅé ¦r)
§@ªÌ¡GExcel HomeÃþ§O¡G1. -> Office -> OFFICE -> EXCEL
ĶªÌ¡G 
¥Xª©ªÀ¡GùÖ®p¥Xª©¯u¥¿¾Ç·|Excel¨ç¼Æªº8°ó½Ò 3dWoo®Ñ¸¹¡G 42396
¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I

¡i¯Ê®Ñ¡j
NT©w»ù¡G 320 ¤¸
§é¦©»ù¡G 240 ¤¸

¥Xª©¤é¡G9/15/2015
­¶¼Æ¡G
¥úºÐ¼Æ¡G0
¯¸ªø±ÀÂË¡G
¦L¨ê¡G¶Â¥Õ¦L¨ê»y¨t¡G ( ÁcÅé ª© )
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R
(½Ð¥ýµn¤J·|­û)
ISBN¡G9789863477761
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç
(²Åé®Ñ¤W©Ò­z¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, ­YŪªÌ»Ý­n½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ)
§@ªÌ§Ç¡G

ĶªÌ§Ç¡G

«e¨¥¡G

¤º®e²¤¶¡G

½u¤W¤U¸ü
¶¡¬Ù¤U99%ªº®É¶¡

¹B¥Î¥ý¶iªº¼Æ¾ÚºÞ²z·§©À¨ÓÂk¯Ç¸ê®Æ¡A¦A¥H±j¤jªºExcel¨ç¼Æ¤Î¤½¦¡²Î­p¤ÀªR¼Æ¾Ú¡A¬O¨C¦ì¤W¯Z±Ú¦b¸ê°T®É¥N¤¤¡A¤@©w­n¾Ç·|ªº§Þ¯à¡C¥»®Ñ§Q¥Î²LÅã©öÀ´ªº¹Ï¤å»¡©ú¡B¥Í°Ê¬¡¼âªº´y­z¥H¤Î¤j¶q¹ê»Ú¤u§@¤¤ªº¸g¨å®×¨Ò¡A¤¶²ÐExcel³Ì±`¥Îªº¨ç¼Æ­pºâ­ì²z¤ÎÀ³¥Î§Þ¥©¡A¥]¬AÅÞ¿è¹Bºâ¡B¤é´Á»P®É¶¡¹Bºâ¡B¤å¦r¹Bºâ¡B´M§ä»P²Î­p¹Bºâµ¥¡C¥t¥~¡AÁÙ·|¤¶²Ð¬ì¾ÇºÞ²z¼Æ¾Úªº¤èªk¡AÁקK¦b¼Æ¾Ú·½ÀY´N²£¥Í°ÝÃD¡C

¥»®Ñ¾A¦X§Æ±æ´£°ª¿ì¤½®Ä²vªº¤W¯Z±Ú¡A¤×¨ä¬O¸g±`»Ý­n³B²z¡B¤ÀªR¤j¶q¸ê®Æ¨Ã»s§@¦¨²Î­p³øªíªº¬ÛÃö¤H¤h¾\Ū¡C
¥Ø¿ý¡G

²Ä1³¹ §A©Ò¤£ª¾¹DªºExcel
1.1 ³Ì¼F®`ªºExcel¥Îªk
1.2 §A²´¤¤¤£¤@¼ËªºExcel
1.3 ¤£·|Excelªº¼p®v´N¤£¬O¦n¼p®v

²Ä2³¹ ¤½¦¡¨ì©³¬O¤°»ò¡H
2.1 ¤°»ò¬OExcel¤½¦¡¡H
2.2 ¦p¦ó¦bExcel¤¤¨Ï¥Î¤½¦¡¡H
2.3 ¤½¦¡ªº²Õ¦¨»Pµ²ºc
2.4 Excel¤¤ªº¼Æ¾Ú
2.5 ¤½¦¡¤¤ªº¹Bºâ¤l
2.6 ¦b¤½¦¡¤¤°Ñ·ÓÀx¦s®æ
2.7 Excel¤¤ªº¨ç¼Æ
2.8 ¨Ï¥Î¨ç¼Æ½s¼g¤½¦¡

²Ä3³¹ ±`¥ÎªºÅÞ¿è¨ç¼Æ
3.1 Excel¤¤ªº¬O»P«D
3.2 IFÅý§Aªº¿ï¾Ü¤£¦A§xÃø
3.3 IF¨ç¼Æªº¤T­Ó¹Ù¦ñ

²Ä4³¹ ¥Î¨ç¼Æ¶i¦æ¼Æ¾Ç¹Bºâ»P¼Æ¾Ú²Î­p
4.1 ¥[Á`¹Bºâ¡A­º¿ïSUM¨ç¼Æ
4.2 ¨Ï¥ÎSUMIF«ö·Ó±ø¥ó¥[Á`
4.3 ¦h±ø¥ó¥[Á`¡A§ó¤è«KªºSUMIFS¨ç¼Æ
4.4 ¨D«ü©w¼Æ¾Úªº¥­§¡­È
4.5 ²Î­p²Å¦X±ø¥óªºÀx¦s®æ­Ó¼Æ
4.6 ¨Ï¥ÎCOUNTIFS¨ç¼Æ«ö·Ó¦h±ø¥ó²Î­pÀx¦s®æ­Ó¼Æ
4.7 ¨Ï¥Î¨ç¼Æ¨ú±Ë¼Æ­È

²Ä5³¹ ¥Î¨ç¼Æ³B²z¤å¦r
5.1 ±N¦h­Ó¦r¦ê¦X¨Ö¦¨¤@­Ó
5.2 ¥Î¨ç¼Æ­pºâ¤å¦rªºªø«×
5.3 Àˬd¤å¦r¬O§_¬Û¦P
5.4 ´M§ä«ü©w¦r¤¸¦b¦r¦ê¤¤ªº¦ì¸m
5.5 ¨Ï¥Î¨ç¼ÆºI¨ú³¡¤À¦r¤¸
5.6 ¨ú¥N¦r¦ê¤¤ªº³¡¤À¦r¤¸
5.7 ¨Ï¥ÎTEXT¨ç¼Æ´À¦r¦ê¡u¾ã§Î¡v
5.8 ¤å¦r»P¼Æ­È¤¬´«

²Ä6³¹ §Q¥Î¨ç¼Æ¹F¦¨§Ö³t´M§äªº¥Øªº
6.1 ¨Ï¥ÎVLOOKUP¬d¸ß²Å¦X±ø¥óªº¼Æ¾Ú
6.2 VLOOKUPªºÅp¥Í¥S§Ì¡XHLOOKUP
6.3 ¨Ï¥ÎMATCH¨ç¼Æ½T©w¼Æ¾Úªº¦ì¸m
6.4 ¨Ï¥ÎINDEX¨ç¼Æ¨ú±o«ü©w¦ì¸mªº¼Æ¾Ú

²Ä7³¹ ¥Î¨ç¼Æ³B²z¤é´Á»P®É¶¡
7.1 ´¦¶}¤é´Á©M®É¶¡ªº­±¨ã
7.2 ¦bExcel¤¤¿é¤J¤é´Á»P®É¶¡
7.3 ´£¨ú¤é´Á­È©M®É¶¡­È¤¤ªº¸ê°T
7.4 ¨ä¥L±`¨£ªº¤é´Á­pºâ°ÝÃD
7.5. «D³W½d¤é´Á©M®É¶¡ªº³B²z¤èªk

²Ä8³¹ ºÞ²z¦UºØ¼Æ¾Ú
8.1 Excel¤¤¨ä¹ê¥u¦³¨âºØªí®æ
8.2 ¼Æ¾ÚªíÀ³¸Ó°µ¦¨¤°»ò¼Ë¡H
8.3 §O½ñ¤J«Ø¥ß¸ê®Æªíªº³´¨À
§Ç¡G