Excel¼Æ¾Ú³B²z»P¤ÀªR¹ê¾ÔÄ_¨å¡]²Ä2ª©¡^ ( ²Åé ¦r) |
§@ªÌ¡G¯Õ«i | Ãþ§O¡G1. -> Office -> OFFICE -> EXCEL |
ĶªÌ¡G |
¥Xª©ªÀ¡G¹q¤l¤u·~¥Xª©ªÀ | 3dWoo®Ñ¸¹¡G 50523 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT°â»ù¡G 445 ¤¸ |
¥Xª©¤é¡G12/1/2018 |
¶¼Æ¡G464 |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ²Åé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9787121354595 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡G±ÀÂ褂 ÀHµÛ«H®§§Þ³Nªº¨³²rµo®i»PÀ³¥Î¡A¼Æ¾Ú§e²{¥X®ü¶q¡B¦h¼Ë»P§Ö³t¤T¤j¯SÂI¡A¦}¤wº¯³z¨ì·í¤µ¦U¦æ·~©M·~°È¾¯à»â°ì¡A¦¨¬°«nªº¥Í²£¦]¯À¡A²`¨è¼vÅT¨ì§Þ³N¡B°Ó·~¡Bªk«ß¡BªÀ·|³WSµ¥¤HÃþ¥Í¬¡ªº¤è¤è±±¡C¼Æ¾Ú§@¬°»P¤H¡B°]¡Bª«¤ñªÓªº¸ê·½¡A¥¿¦b¦¨¬°²Õ´ªº°]´I©M³Ð·sªº°ò¦¡A¼Æ¾Ú¤ÀªR¯à¤O¥¿¦b¦¨¬°²Õ´ªº®Ö¤ßÄvª§¤O¡C ¬JµM¼Æ¾Ú¦b·í¤µªÀ·|¤¤¦p¦¹«n¡A¨º¤\§Ú̦p¦óÀò¨ú¡B³B²z©M¤ÀªR¼Æ¾Ú©O¡HExcel ¤w¸g¬O¼s¤j¥Î¤á¸g±`¨Ï¥Îªº¤@ӼƾڳB²z©M¤ÀªR¤u¨ã¡A¤]¬OÀ³¥Î³Ì¼sªxªº¹q¤lªí®æ³B²z³n¥ó¤§¤@¡CExcel ±q1997 ª©¡B2003 ª©¨ì2016 ª©¡A¤@ª½³B¤_¤£Â_§¹µ½©M§ï¶i¤¤¡A¹ê¥Î©ö¾Ç¡CÀHµÛ¤j¼Æ¾Ú®ö¼éªº¨ÓÁ{¡AExcel ªº°Ó°È´¼¯à¤Æ¡B¥iµø¤Æ®ÄªG¡B¼Æ¾Ú¥æ¤¬¥\¯à¶V¨Ó¶V¨ü¨ì¼s¤j¥Î¤áªº³ß·R¡CµM¦Ó¡A¤£¤Ö¥Î¤á¦s¦bµÛ¡§Excel ¤£¹L¦p¦¹¡¨©M¡§Excel ¥u¬O¤@ӼƾڲÎpªí®æ¡¨µ¥½§²L»{ÃÑ¡A¦bExcel ªº¨Ï¥Î¤W¤]¬O²L¹Á»³¤î¡A¨S¦³¶i¤@¨B»â²¤Excel ªº¼Æ¾Ú³B²z»P¤ÀªR¯à¤O¡A·íµM§ó½Í¤£¤W¦p¦ó§Q¥ÎExcel ªº±j¤j¥\¯à¨Ó´£°ª¤u§@®Ä²v©MºÞ²z¤ô¥¤F¡C ¥»®Ñ¦}¨S¦³¹ïExcel ªº¦UÓ¥\¯à¶i¦æ¥þ±¤¶²Ð¡A¥u¬O´NExcel ¤¤ªº«nª¾ÃÑÂIµ²¦X¹ê¨Ò¶i¦æ«ÂI¸Ôz©M©Ý®iÀ³¥Î¡A¨ä¤¤¤]¦³Excel 2013 ¤¤·s¥\¯àªº¤@¨Ç»¡©ú©M¨Ï¥Î§Þ¥©¡CµL½×¬On¦bExcel ¤¤¶i¦æ¼Æ¾Ú²M²z¡B¾É¤J/¾É¥X¼Æ¾Ú¡AÁÙ¬O§Q¥ÎPower ¨t¦C³B²z¼Æ¾Ú¡A©Î¬O¦bExcel ¤¤³Ð«Ø¹Ïªí¡A¦p¦ó§¹¦¨³o¨Ç¥ô°ÈºÉ¦b¥»®ÑªºÁ¿¸Ñ¤¤¡C¥»®Ñ¥Dnµ²¦X¤½¥q¹ê»ÚÀô¹Ò¤UªºÀ³¥Î¹ê¨Ò¨ÓÁ¿¸Ñ¦UºØ¼Æ¾Ú³B²z»P¤ÀªR§Þ³N¡Aª`«ÂI±µ²¦X¡A¦P®ÉÁÙª`«ÅÞ¿è«äºûªº©Ý®i¡A¥H«K°ö¾iŪªÌªº¼Æ¾ÚÆ[¹î»P¨ç¼Æºc«Ø¯à¤O¡C¾Ç²ß§¹¥»®ÑY¤z³¹¸`©Mªþ¿ý¤¤¦³Ãö¼Æ¾Ú³WS©Êªº¬ÛÃöª¾ÃѦZ¡A¬Û«H¹ïŪªÌExcel ¼Æ¾ÚÀ³¥Î¤ô¥ªº´£¤É·|¦³©Ò»t¯q¡C ±i¾Ç¤~ °ê®a¶}µo»È¦æ°ª¯Å¸gÀÙ®v «e¨¥ ¥»®Ñªº²Õ´¬[ºc ¥»®Ñ¥HExcel 2013 ¬°°ò·Ç¥»O¡AÝÅU¦´Áª©¥»ªº¤£¦PÂI¡A¨Ï·sÂ¥Τ᳣¯à§Ö³t´x´¤Excel À³¥Î§Þ¥©¡A¿n²ÖExcel À³¥Îª¾ÃÑ¡C¥þ®Ñ¦@16 ³¹¡A¥t¥~ÁÙ¦³¤@Óªþ¿ý¡A¥Dn¤º®e¦p¤U¡C ²Ä1 ³¹¡G¼Æ¾Ú³B²z°ò¥»§Þ¥©¡C¥»³¹³q¹L¹ê¨Ò§Î¦¡ÄÄz¼Æ¾Ú³B²zªº¦UºØ°ò¦§Þ¥©¡C ²Ä2 ³¹¡G¼Æ¾Ú±M¶µ³B²z§Þ¥©¡C¥»³¹¥]§t±ø¥ó®æ¦¡¡B±Æ§Ç¡B¿z¿ï¡B¶×Á`¡B¦X¦}pºâ¡B©w¸q¦WºÙ¡B¤À¦C¡B¼Æ¾Ú¾É¤J/¾É¥Xµ¥¤è±ªº¤º®e¡AµÛ«¤¶²Ð¤F¼Æ¾Ú²M²z¤èªk¤ÎSQL »y¥y¦b¼Æ¾Ú¬d¸ß¤¤ªºÀ³¥Î¡C ²Ä3¡B4 ³¹¡G¼Æ¾Ú³zµøªí¡A¥]¬A¼Æ¾Ú³zµøªíªº°ò¦À³¥Î¡BÂX®i¡BPowerPivot »P¼Æ¾Ú³zµøªí¡B¼Æ¾Ú¼Ò«¬¡A¥H¤ÎPower Query À³¥Î¹ê¨Ò¡C ²Ä5~12 ³¹¡GExcel ¤½¦¡»P¨ç¼Æ¡C³o¨½¥Dn³q¹L¹ê¨Òªº§Î¦¡®i¥Ü¦bExcel ¤¤°õ¦æpºâ¤u§@ªº¤½¦¡»P¨ç¼Æ¡A¥H¤Î«ÂI¨ç¼ÆªºÀ³¥Î¡C ²Ä13 ³¹¡G¨ç¼Æ»P¤½¦¡ªººî¦XÀ³¥Î¡C¥»³¹¥Dn®i¥Ü¨ç¼Æ»P¤½¦¡¦b¸Ñ¨M¹ê»Ú¤u§@´_Âø°ÝÃD¤¤ªºÀ³¥Î¡C ²Ä14¡B15 ³¹¡GExcel ¹Ïªí¨î§@¡C³o¨½³q¹L¤@¨Ç¹ê¨Ò¤¶²ÐExcel ¹Ïªí¨î§@¥H¤Î§Q¥ÎPower View¨î§@BI ¹Ï¡C ²Ä16 ³¹¡GVBA ¦b¼Æ¾Ú³B²z¤¤ªºÀ³¥Î¡C¥»³¹¥Dn¤¶²Ð´XÓ±`¥ÎªºVBA ¼Æ¾Ú³B²z¹ê¨Ò¡C ¥»®Ñªþ¿ý³¡¤À¤¶²Ð¦p¦ó¥Î¼Æ¾Ú¼Ð·Ç¤Æ«äºû³WS¼Æ¾Ú©M¦p¦ó¾i¦¨¨}¦nªº¼Æ¾Ú³B²z²ßºD¡C ŪªÌ¹ï¶H ¥»®Ñ±¦VªºÅªªÌ¸s¥]¬AExcel ¤¤°ª¯Å¥Î¤á©M±q¨ÆExcel ¶}µoªº¬ÛÃöIT ¤Hû¡C¦]¦¹¡AŪªÌ¦b¾\Ū¥»®Ñ«eÀ³¨ã³Æ¨Ï¥ÎWindows ¾Þ§@¨t²Î¥B¦Ü¤Ö¨ã¦³Excel 2007 ªº¨Ï¥Î¸gÅç¡A¦}¤F¸ÑÁä½L©M¹«¼Ð¦bExcel ¤¤ªº¤@¨Ç¨Ï¥Î¤èªk¡A´x´¤Excel ªº¤@¨Ç°ò¥»¥\¯à©M±`¥Î©R¥O«ö¶sªº¾Þ§@¤èªk¡C PÁ ¥»®Ñ¥Dn¥Ñ¯Õ«i½s¼g¡A°Ñ»P½s¼gªº¤HûÁÙ¦³¼BౡB«\¤¦¡BÅǾǹp©MÃÓ¬K¦¨¡C·PÁ¡§Å]³N®v¤¤ªº²Â¤p«ÄÌ¡¨QQ ¸sªº¦U¦ìªB¤Í¡BExcelHome ¦b½u°ö°V±ÐºÞ¹Î¶¤¡A¥H¤ÎExcelHome ºô¯¸¯¸ªø©P¼yÅï¡Bª¾¦Wª©¥D¯¬¬x©¾¦Ñ®v©M¦U¦ì¦P¨Æ¹ï¥»®Ñªº¤ä«ù»PÀ°§U¡A¥L̤À§O¬O»¯Äõ¡B±i¸¿P¡B¦¶·£¡B§õ±Ó¡B´^´¼«i¡B®É©[¡B¤å³·¾§¡B¼BªY®®¡B¤ý¥Ã¦{µ¥¡A¦b¦¹¦V³o¨Ç³Ì¥i·Rªº¤Hªí¥Ü¥Ñ°Jªº·PÁ¡C ¾Ç²ßExcel ªº¤èªk §@¬°ExcelHome ½×¾Â°ö°V¤¤¤ß§U±Ð©M¤½¥qExcel °ö°VÁ¿®v¡A§Ú¸g±`·|±¹ï³o¼Ëªº´£°Ý¡G¡§¦p¦ó¾Ç²ßExcel¡H¡¨¡§«ç¤\¼Ë¤~¯à§Ö³t¦¨¬°Excel °ª¤â¡H¡¨µM¦Ó¡A³o¨Ç°ÝÃD¦}¤£¦nª½±µ¦^µª¡C¦b³o¨½¡A§Ú¥u·Q»¡¡GExcel ªº¾Ç²ß¬O¤@Ó´`§Çº¥¶iªº¹Lµ{¡A¨S¤°¤\¯µÄy©Îµ´©Û¥i¥HÅý§Ú̦bµu´Á¤º¦¨¬°°ª¤â¡Cµ§ªÌ»{¬°¡A¥u¦³¨ã³Æ¿n·¥ªº¤ßºA¡B¥¿½Tªº¤èªk¦}«ù¤§¥HùÚ¦a§V¤O¡A¤~¯à¾Ç¦³©Òªø¡C¦^º¦Û¤v¾Ç²ßExcel ªº¸g¾ú¡A¥¿À³¤F¡§«D¾ÇµL¥H¼s¤~¡A«D§ÓµL¥H¦¨¾Ç¡¨³o¥y¸Ü¡C³ÌªìªºÁx©Ä¤ßºA¦}¤£¥i©È¡A³Ì¥i©Èªº¬O¤ßºA¯Bļ¡BÃø¥HÀR¤U¤ß¨Ó¾Ç²ß¡C±¹ï¼Æ¾Ú³B²z»P¤ÀªR¡A§Ṳ́£¥²®ö¶O¤j§âªº®É¶¡¥h¾Ç²ß¨º¨Ç¥O¤H¥Í¬Èªº¤j«¬¼Æ¾Ú®w³n¥ó©ÎªÌ¦UºØµ{§Ç³]p»y¨¥¡C¥un§AªáÂI®É¶¡¡AÀR¤U¤ß¨ÓŪ¤@¥»Excel ªº®Ñ¡A½m¤@½mExcel ¼Æ¾Ú³B²z§Þ¥©¡A¬Û«H¹ï¤u§@¤¤¹J¨ìªºµ´¤j³¡¤À¼Æ¾Ú³B²z»P¤ÀªR°ÝÃD³£¥i´å¤b¦³§E¦a¸Ñ¨M¡C ¾Ç²ßExcel ªº¤è¦¡¦p¤U¡G¾\Ū¬ÛÃö¹Ï®Ñ¡A¥ÎOffice ¦Û±aªºÁp¾÷À°§U¡A°Ý¨Ã䪺¦P¨Æ¡A¥Îºôµ¸·j¯Á¸Ñ¨M°ÝÃDµ¥¡C¨ä¤¤¦bºôµ¸·j¯Á®É»Ýnª`·N¡A°ÝÃDªíznºÉ¥i¯à·Ç½T¡C¦b¤¬Ápºô®É¥N¡A¦³ÃöExcel¼Æ¾Ú³B²zÀ³¥Îªº¤å³¹¡B°Êµe¡BµøÀW«D±`¦h¡A³o¨Ç³£¬O§Ú̾Dzߪº¸ê·½¡C¾Ç²ßExcel¡A¹ê½î³Ì«n¡A¥¿¥i¿×§AÅ¥¨£¤F·|§Ñ°O¡A§A¬Ý¨£¤F´N°O¦í¤F¡A§A°µ¤F´N©ú¥Õ¤F¡C¦Ó³o¨ä¤¤Å¥¡X¬Ý¡X°µ´N¬O¾Ç²ßExcelªº³Ì¨Îµ²¦X¡A¦b°µ¤¤¾Ç¡A¦b¾Ç¤¤°µ¡A¦h½m²ß¬O³Ì¦nªº¤èªk¡A¥u¦³¦h½m¡A¤~¯à±N¨äÂà¤Æ¬°¦Û¤v©Ò¦³¡CÀHµÛ«H®§§Þ³Nªº¸³tµo®i¡AExcel ¼Æ¾Ú³B²z§Þ³N¤]¤é·s¤ë²§¡C±qExcel 1997/Excel 2003 §ó·s¤É¯Å¨ìExcel 2016¡AµL½×¬O¥Î¤á¬É±ÁÙ¬O¨ä¥æ¤¬¥\¯à¡AExcel ªº¼Æ¾Ú³B²z¤è¦¡¶V¨Ó¶V¤H©Ê¤Æ¡C¦]¦¹¡AÀHµÛExcel ªº¤É¯Å¡A¥Î¤á¤]À³ªáÂI®É¶¡¥h¤F¸Ñ©M¾Ç²ß·sª©¥»Excel ªº·s¥\¯à¡A¦Ó¤£¯à¬G¨B¦Û«Ê¡B»q¨¬¤£«e¡C ¬°¤è«KŪªÌ¾Ç²ß¡A¥»®ÑÁÙªþÃضW¤j®e¶qªº±Ð¾ÇµøÀW¤Î¨å«¬¨ç¼Æ»P¤½¦¡®×¨Ò¡C |
¤º®e²¤¶¡GÀHµÛ¼Æ¾Ú®É¥Nªº¨ÓÁ{¡AExcel ªº¼Æ¾Ú³B²z»P¤ÀªR¯à¤O¹ï¾³õ¤H¤h¦Ó¨¥¬O¤@¶µ¥²³ÆªºÂ¾·~§Þ¯à¡A¼Æ¾Ú³B²z»P¤ÀªR¯à¤O¤]¥¿¦b¦¨¬°²Õ´ªº®Ö¤ßÄvª§¤O¡C¥»®Ñ¦}¨S¦³¹ïExcel ªº¦UÓ¥\¯à¶i¦æ¥þ±¤¶²Ð¡A¦Ó¬O°¼«¤_Excel ¼Æ¾Ú³B²z»P¤ÀªR¦b¹ê»Ú¤u§@¤¤ªºÀ³¥Î¡A®Ñ¤¤ºë¿ï¤F²³¦hªº§Þ¥©©M¸g¨å®×¨Ò¡A¦}»²¥H²`¤J²L¥Xªº¸ÑªR¡A¤O¨DÅý§ó¦h§Æ±æ²`¤J´x´¤Excel ¼Æ¾Ú³B²z»P¤ÀªR§Þ¥©ªºÅªªÌ¨ú±oªø¨¬ªº¶i¨B¡C ¥»®Ñ±q¹ê»Ú¤u§@À³¥Î¥Xµo¡A«ÂI¤¶²Ð¤F¼Æ¾Ú³B²zªº«n§Þ¥©¤Î¨ç¼ÆªºÀ³¥Î¡A¯S§O¬O¼Æ¾Ú²M²z§Þ³NªºÀ³¥Î¯àÅýŪªÌ¹ï¼Æ¾Ú¥h°°¦s¯u¡A´x´¤¼Æ¾Ú¥D°ÊÅv¡A¥þ±´x±±¼Æ¾Ú¡FExcel ¤¤SQL¡B¼Æ¾Ú³zµøªí¡BPower Query¡BPower Pivot¡BVBA ªºÀ³¥Î«¦b«õ±¸ÁôÂ꺼ƾڻùÈ¡A»´ªQ¾ã¦X®ü¶q¼Æ¾Ú¡F¦UºØ¹ÏªíÃþ«¬ªº¨î§@§Þ¥©¤ÎPower View ªºÀ³¥Î¥i®i²{¼Æ¾Ú¥iµø¤Æ®ÄªG¡AÅý¼Æ¾Ú»¡¸Ü¡C ¥»®Ñ¤º®eÂ×´I¡A¹Ï¤å¦}Z¡A¬J¾A¦XExcel ¤¤°ª¯Å¥Î¤á¾\Ū¡A¤]¥i§@¬°Excel ªì¾ÇªÌªº°Ñ¦Ò¥Î®Ñ¡C³q¹L¹ï¥»®Ñªº¾Ç²ß¡AŪªÌ¥i¥H¾Ç¨ì¼Æ¾Ú³B²z»P¤ÀªRªº¬ì¾Ç¤u§@¤èªk¡A§Ö³t´x´¤¦UºØExcel ¼Æ¾Ú³B²z»P¤ÀªR§Þ¥©¡C ¥»®ÑªþÃؤº®e¥]¬A¶W¤j®e¶qªº±Ð¾ÇµøÀW¤Î¨å«¬¨ç¼Æ»P¤½¦¡®×¨Ò¡C |
¥Ø¿ý¡G²Ä1 ³¹ ¼Æ¾Ú³B²z°ò¥»§Þ¥© .......... 1 1.1 »{ÃÑExcel ªí®æ ............ 1 1.1.1 Excel ªí®æ¤¤ªº¹ï¶H ........... 2 1.1.2 »{ÃÑExcel ¶W¯Åªí .......... 3 1.2 ¼Æ¾ÚÅçÃÒªº±j¤j¥\¯à .......... 4 1.2.1 ¼Æ¾ÚÅçÃÒÀ³¥Î¤§¤@¡G³WS¼Æ¾Ú¿é¤J ....... 5 1.2.2 ¼Æ¾ÚÅçÃÒÀ³¥Î¤§¤G¡G¨î§@¤G¯Å¤U©Ôµæ³æ...... 6 1.2.3 ¦WºÙºÞ²z¾¹¬ð¯}¼Æ¾ÚÅçÃÒªº¨î ....... 8 1.2.4 ¼Æ¾ÚÅçÃÒ°éÄÀµL®Ä¼Æ¾Ú ......... 10 1.3 ¯«©_ªº¿ï¾Ü©ÊÖ߶K .......... 11 1.3.1 ¼Æ¾Ú¦ì¸m¤£Åܹê²{¸U¤¸¨Ó¦^¤Á´« ....... 12 1.3.2 ¿ï¾Ü©ÊÖ߶K²M°£¶WÃì±µ ......... 13 1.3.3 ¿ï¾Ü©ÊÖ߶KÂà´«¼Æ¾ÚÃþ«¬ ......... 14 1.3.4 ¸õ¹LªÅ³æ¤¸®æ ........... 14 1.4 ¬d§ä©M´À´« ........... 15 1.4.1 §å¶q²M°£³æ¤¸®æ¤¤ªºªÅ®æ©Î´«¦æ²Å ....... 16 1.4.2 §å¶q´À´«¤½¦¡ ........... 18 1.4.3 §å¶q´À´«³q°t²Å*©Î¡H ......... 18 1.4.4 §å¶q´¡¤J¦~¥÷ ........... 19 1.4.5 ««ª½¼Æ¾ÚÂà´«¬°¤ô¥¼Æ¾Ú ......... 20 1.5 ©_§®ªº©w¦ì±ø¥ó ............ 22 1.5.1 ¥Ñ¤W¦V¤U§å¶q¶ñ¥R ........... 23 1.5.2 ¥ª¥k§å¶q¶ñ¥R ........... 25 1.5.3 ¶¥±èª¬§å¶q¶ñ¥R ........... 27 1.5.4 §R°£¹ï¶H¹ê²{¤å¥ó½G¨ ......... 29 1.5.5 ©w¦ìªÅȹê²{§å¶q¨D©M ......... 30 1.6 ³Ð«Ø¡BÃö³¬¿é¤J¶WÃì±µ ......... 31 1.6.1 ³Ð«Ø¶WÃì±µ ........... 31 1.6.2 Ãö³¬¿é¤J¶WÃì±µ ........... 34 1.7 ³æ¤¸®æ®æ¦¡³]¸m ............ 34 1.7.1 »{ÃѦUºØ¼Æ¾Ú®æ¦¡ ........... 34 1.7.2 ªÅ³æ¤¸®æ»PªÅ¤å¥» ........... 35 1.7.3 ¦Û©w¸q³æ¤¸®æ®æ¦¡ ........... 36 1.7.4 ¦X¦}³æ¤¸®æ ........... 40 1.8 °ò¥»§Þ¥©ºî¦XÀ³¥Î®×¨Ò .......... 42 1.8.1 ´£¨ú²V¦X³æ¤¸®æ¤¤ªº¼Æ¦r ......... 42 1.8.2 ¬d§ä©M´À´«ªº§®¥Î ........... 45 ²Ä2 ³¹ ¼Æ¾Ú±M¶µ³B²z§Þ¥© ........... 48 2.1 ±ø¥ó®æ¦¡ ............. 48 2.1.1 »{Ãѱø¥ó®æ¦¡ ........... 48 2.1.2 ±ø¥ó®æ¦¡ªºÂ²³æÀ³¥Î ......... 49 2.1.3 ¥Î¥|¦â¥æ³q¿O¼Ð¥Ü°]°Èª¬ºA ......... 51 2.1.4 ¹ï¬d¸ßªº¼Æ¾Ú°ª«GÅã¥Ü ......... 52 2.1.5 ¼ÐÃѨâ¦C¤¤¤£¦Pªºª«®Æ¦WºÙ ......... 54 2.2 ±Æ§Ç¡B¿z¿ï»P¤ÀÃþ¶×Á` .......... 56 2.2.1 ±Æ§Ç¡B¿z¿ï»P¤ÀÃþ¶×Á`¹ï¼Æ¾Úªºn¨D ....... 56 2.2.2 «ö¹Ï¼Ð¶°¶i¦æ¼Æ¾Ú±Æ§Ç ......... 57 2.2.3 ¨Ï¥Î¦Û©w¸q§Ç¦C±Æ§Ç ......... 58 2.2.4 §Q¥Î±Æ§Ç¥Í¦¨¦¨ÁZ³æ ......... 61 2.3 ¦X¦}pºâ ............ 63 2.3.1 §Q¥Î¤½¦¡¦X¦}pºâ ........... 63 2.3.2 «ö¦ì¸m¶i¦æ¦X¦}pºâ ......... 64 2.3.3 «ö¶µ¥Ø¶i¦æ¦X¦}pºâ ......... 66 2.3.4 §Q¥Î¦X¦}pºâ¹ï¤ñ®t²§ ......... 66 2.4 ¦WºÙºÞ²z¾¹ ........... 69 2.4.1 »{ÃѦWºÙºÞ²z¾¹ ........... 69 2.4.2 ³Ð«Ø¦WºÙªº3 ºØ¤è¦¡ ......... 69 2.4.3 ¦WºÙ¦b¨ç¼Æ¤¤ªºÀ³¥Î¡G¦X¦}³øªí½s¨î ....... 72 2.5 ¼Æ¾Ú¤À¦C ...........73 2.5.1 ©T©w¼e«×ªº¼Æ¾Ú¤À¦C ......... 73 2.5.2 ¹ïSAP «Ì¹õ¤¤´_¨î¥X¨Óªº¼Æ¾Ú¤À¦C ........ 75 2.5.3 «ö¤À¹j²Å¸¹¶i¦æ¼Æ¾Ú¤À¦C ......... 76 2.5.4 §Q¥Î¤À¦C§ïÅܼƾÚÃþ«¬ ......... 77 2.5.5 §Ö³t¶ñ¥R³B²zµLªk¤À¦Cªº¼Æ¾Ú ......... 79 2.6 ¼Æ¾Ú²§±`³B²z ........... 80 2.6.1 ¼Æ¾Ú²§±`ªº±`¨£°ÝÃD¤Î³B²z§Þ¥© ....... 80 2.6.2 °O¨Æ¥»µ{§Ç¡§®»§¯°O¡¨ ......... 81 2.6.3 §Q¥Î¨ç¼Æ²M²z²§±`¼Æ¾Ú ......... 83 2.6.4 §Q¥Î¤À¦C²M²z²§±`¼Æ¾Ú ......... 83 2.6.5 §Q¥ÎWord ²M²z²§±`¼Æ¾Ú ......... 85 2.6.6 µLªk´¡¤J¦C©Î¦æªí®æªº³B²z ......... 86 2.6.7 §R°£«´_¼Æ¾Ú ........... 87 2.6.8 §Q¥ÎSQL »y¥y¹ê²{¤å¥óªº½G¨ ........ 89 2.6.9 §Q¥Î°Å¶KªO³B²z¦P¤@¦C¤¤±a¤£¦P³f¹ô²Å¸¹ªº¼Æ¾Ú .... 92 2.7 ¼Æ¾Úªº¾É¤J»P¾É¥X .......... 94 2.7.1 Excel ¼Æ¾Úªº¾É¤J¡B¾É¥X²¤¶ ......... 94 2.7.2 Excel SQL °ò¦ª¾ÃÑ ........... 95 2.7.3 ¨Ï¥ÎOLE DB ¾É¤J¥~³¡¼Æ¾Ú ......... 98 2.7.4 ¨Ï¥ÎMicrosoft Query ¬d¸ß¥~³¡¼Æ¾Ú ....... 103 2.7.5 Áp¦X¬d¸ß¡B¤l¬d¸ß ........... 111 2.7.6 SQL »P¼Æ¾Ú³zµøªí ........... 114 2.7.7 ¾É¤J¤å¥»®æ¦¡ªº¼Æ¾Ú ......... 121 2.7.8 ¾É¥X¨ì¤å¥»¤å¥ó ........... 124 2.8 ¼Æ¾Ú±M¶µ³B²z§Þ¥©ºî¦X®×¨Ò ......... 125 2.8.1 ¥©¥Î§å¶q´¡¤J¦æ ........... 125 2.8.2 §å¶q¦X¦}³æ¤¸®æ ........... 128 ²Ä3 ³¹ ¼Æ¾Ú³zµøªí°ò¦ .......... 131 3.1 »{ÃѼƾڳzµøªí ........... 131 3.2 ¨î§@¼Æ¾Ú³zµøªíªº¤@¯ë¨BÆJ ......... 133 3.3 ¼Æ¾Ú³zµøªíªº×§ï¤Î¨ä¥¬§½½Õ¾ã ......... 135 3.4 ¼Æ¾Ú³zµøªíªº®æ¦¡³]¸m ........... 140 3.5 ¼Æ¾Ú³zµøªíȦr¬qªº³]¸m ........... 148 ²Ä4 ³¹ ¼Æ¾Ú³zµøªí»PPower ¨t¦C .......... 153 4.1 ¦b¼Æ¾Ú³zµøªí¤¤©w¸q¤½¦¡ ........... 153 4.2 ¹ï¼Æ¾Ú³zµøªí¤¤ªº¶µ¶i¦æ²Õ¦X ......... 158 4.3 §Q¥Î¦WºÙ³Ð«Ø°ÊºA¼Æ¾Ú³zµøªí ......... 167 4.4 ¤Á¤ù¾¹¦b¼Æ¾Ú³zµøªí¤¤ªºÀ³¥Î ......... 169 4.5 ¤éµ{ªí¦b¼Æ¾Ú³zµøªí¤¤ªºÀ³¥Î ......... 174 4.6 ³æ¶¦r¬q¼Æ¾Ú³zµøªí ........... 176 4.7 §Q¥Î¼Æ¾Ú³zµøªí©î¤Àªí®æ ........... 180 4.8 §Q¥Î¼Æ¾Ú³zµøªíÂà´«ªíµ²ºc ......... 184 4.9 PowerPivot ©M¼Æ¾Ú³zµøªí ........... 188 4.10 ¨Ï¥Î¼Æ¾Ú¼Ò«¬ ............. 191 4.11 §Q¥ÎPowerPivot ©M¤Á¤ù¾¹¨î§@¾P°â¬ÝªO ....... 195 4.12 Power Query °f¾Þ§@¤Gºûªí ......... 204 4.13 §Q¥ÎPower Query ¹ê²{µo³f¼Ðñ¼Æ¾Ú¾ã²z ...... 207 4.14 ¦hªí¼Æ¾ÚÃöÁpÃö¨tªº°ò¥»·§©À ......... 212 4.15 §Q¥ÎPower Query ®i¶}BOM pºâ²£«~§÷®Æ¦¨¥» ..... 214 4.16 §Q¥ÎPower Query ©î¤À³sÄò¸¹½X¬d§ä®t²§ ...... 225 ²Ä5 ³¹ Excel ¨ç¼Æ»P¤½¦¡ ........... 230 5.1 ¨ç¼Æ»P¤½¦¡°ò¦ ........... 230 5.2 ¤½¦¡¤¤ªº¤Þ¥Î ............. 233 5.3 ¤½¦¡ªº¬d¿ù»PºÊµø ........... 238 ²Ä6 ³¹ ÅÞ¿è¨ç¼Æ .............242 6.1 ÅÞ¿è¨ç¼Æ·§z ............. 242 6.2 ÅÞ¿è¨ç¼Æ®×¨Ò¡GÓ¤H©Ò±oµ|pºâ ......... 244 6.3 ÅÞ¿è¨ç¼Æºî¦XÀ³¥Î1¡G·~°Èû¬P¯Åµû©w ........ 246 6.4 ÅÞ¿è¨ç¼Æºî¦XÀ³¥Î2¡GÀ³¦¬½ã´Ú½ãÄÖ¤ÀªR¼Ò«¬ ...... 246 6.5 §Q¥ÎIF ¨ç¼Æ¹ê²{¼Æ¾Úªº§å¶q¶ñ¥R ........ 247 ²Ä7 ³¹ ¨D©M¡B²Îp¨ç¼Æ ............ 249 7.1 ¨D©M¡B²Îp¨ç¼Æ·§z ........... 249 7.2 ¨D©M¡B²Îp¨ç¼ÆÀ³¥Î®×¨Ò ........... 250 7.2.1 ¦h±ø¥ó¨D©M¤½¦¡ ........... 250 7.2.2 ¼Ò½k±ø¥ó¨D©M ........... 255 7.2.3 ´XºØ¯S®í¤è¦¡¨D©M ........... 256 7.2.4 ±ø¥óp¼Æ ........... 258 7.2.5 ¿z¿ïª¬ºA¤UªºSUBTOTAL ¨ç¼Æ ....... 260 7.2.6 ¤£«´_¼Æ¾Ú²Îp ........... 262 7.2.7 ÀW²v¤À¥¬ ........... 263 7.2.8 ¤£«´_±Æ¦W»P¤¤°ê¦¡±Æ¦W ......... 265 7.2.9 ½u©Ê´¡ÈªkªºÀ³¥Î ........... 265 7.2.10 ªÙ¤J¨ç¼ÆªºÀ³¥Î ........... 267 7.2.11 ¤W¤U¨ç¼ÆªºÀ³¥Î ......... 270 ²Ä8 ³¹ ¬d§ä»P¤Þ¥Î¨ç¼Æ .......... 272 8.1 ¬d§ä»P¤Þ¥Î¨ç¼Æ·§z .......... 272 8.2 VLOOKUP ¨ç¼ÆÀ³¥Î®×¨Ò .......... 273 8.2.1 «ö¦C¬d§ä ........... 273 8.2.2 °f¦V¬d§ä ........... 273 8.2.3 ¦h±ø¥ó¬d§ä ........... 274 8.2.4 ¤@¹ï¦h¬d§ä ........... 275 8.2.5 ¼Ò½k¬d§ä ........... 276 8.2.6 ¥©¥ÎVLOOKUP ®Ö¹ï»È¦æ½ã ........ 277 8.2.7 VLOOKUP ªº±`¨£¿ù»~Ãþ«¬¤Î¸Ñ¨M¤èªk ....... 279 8.3 LOOKUP ¨ç¼ÆÀ³¥Î®×¨Ò .......... 280 8.3.1 LOOKUP ¦V¶q©M¼Æ²Õ¬d§ä°ò¦ ........ 280 8.3.2 ¼Æ²Õ«¬¬d§ä ........... 281 8.3.3 ¤À²Õ¬d§ä ........... 282 8.3.4 ³æ¤@±ø¥ó¬d§ä ........... 283 8.3.5 ¦h±ø¥ó¬d§ä ........... 284 8.3.6 ¦b¦X¦}³æ¤¸®æ¤º¬d§ä ......... 285 8.4 INDEX ¨ç¼Æ ........... 286 8.4.1 INDEX ¨ç¼Æªº°ò¥»¥Îªk .......... 286 8.4.2 INDEX ¨ç¼Æªº¤Þ¥Î§Î¦¡ .......... 286 8.4.3 °õ¦æÂù¦V¬d§ä ........... 287 8.4.4 ³Ð«Ø°ÊºA°Ï°ì ........... 288 8.5 OFFSET ¨ç¼Æ ............ 291 8.5.1 OFFSET ¨ç¼Æªº°ò¥»¥Îªk ........ 291 8.5.2 ¦b¤Gºû°Ï°ì¤º¬d§ä ........... 291 8.5.3 ÀxÈ¥d§EÃBªºpºâ¤Î¬d¸ß ......... 292 8.5.4 OFFSET »P°ÊºA¼Æ¾ÚÅçÃÒ ........ 294 8.5.5 «öÃöÁä¦r³]¸m´¼¯à°O¾Ð¦¡¤U©Ôµæ³æ ....... 295 8.6 INDIRECT ¨ç¼Æ ........... 296 8.6.1 »{ÃÑINDIRECT ¨ç¼Æ ......... 296 8.6.2 ¶×Á`¦U¤Àªí¼Æ¾Ú ........... 298 8.6.3 ¬d¸ß¯S®í¤Àªí¼Æ¾Ú ........... 300 8.6.4 ¬d¸ß°Ï°ì¤¤ªºË¼Æ²Ä¤GÓ¼Æ ......... 301 8.6.5 «ö³ÌªñȬd¸ß ........... 302 8.7 HYPERLINK ¨ç¼Æ ........... 303 8.7.1 «Ø¥ß¶WÃì±µ¦}°ª«GÅã¥Ü¼Æ¾Ú°O¿ý ....... 303 8.7.2 ½s¨î¤u§@ªí¥Ø¿ý ........... 304 8.7.3 ¨ú±oµw½L«ü©w¥Ø¿ý¤Uªº¤å¥ó¦W ....... 305 ²Ä9 ³¹ ¤é´Á»P®É¶¡¨ç¼Æ .......... 308 9.1 »{ÃѤé´Á»P®É¶¡ªº¥»½è ........... 308 9.2 ªð¦^»P¤ë¥÷¬ÛÃöªº¼Æ¾Ú ..........309 9.3 »P¬P´Á¡B¤u§@¤é¦³Ãöªº¨ç¼Æ ......... 310 9.4 §Q¥Î°²¤é¨ç¼Æ¥©¸Ñ²¼¾Ú¯Ê¥¢°ÝÃD ......... 311 9.5 ÁôÂÃDATEDIF ¨ç¼Æ ............ 312 9.6 ®É¶¡¨ç¼ÆpºâÀ³¥Î¹ê¨Ò ........... 314 ²Ä10 ³¹ ¤å¥»¨ç¼Æ ............. 316 10.1 ±`¨£ªº¤å¥»¨ç¼Æ ........... 316 10.2 ¤å¥»¨ç¼Æ°ò¦ ............. 317 10.3 ¨â²Õ¤å¥»¨ç¼Æ¥Îªkªº¤ñ¸û ......... 318 10.4 ¤ÀÂ÷¤¤^¤å ............. 319 10.5 ®Ú¾Ú¦hÓÃöÁä¦r½T©wµ²ªG ......... 320 10.6 ±q¸ô®|¤¤´£¨ú¤å¥ó¦W ........... 321 10.7 ¥I´Ú¼ÒªO³]p ............. 322 10.8 ±q¤å¥»¤¤¤ÀÂ÷ª«®Æ¥N½X ........... 323 10.9 ¡§¤å¥»¨ç¼Æ¤§¤ý¡¨¡X¡XTEXT ¨ç¼Æ ........ 325 ²Ä11 ³¹ «H®§¨ç¼Æ ............ 328 11.1 ±`¨£ªº«H®§¨ç¼Æ ........... 328 11.2 ÀËÅç¼Æ¾ÚÃþ«¬¨ç¼Æ ........... 328 11.3 CELL ¨ç¼Æ¤Î¨äÀ³¥Î .......... 329 11.3.1 CELL ¨ç¼Æ·§z .......... 329 11.3.2 CELL ¨ç¼ÆÀ³¥Î .......... 330 11.4 ®Ú¾ÚÃöÁä¦r³]¸m´¼¯à¼Ò½k¬d¸ß ......... 331 ²Ä12 ³¹ ¼Æ²Õ¤½¦¡ ............. 334 12.1 ¼Æ²Õ¤½¦¡ªº·§©À»P¯S©Ê ........... 334 12.2 ³æ¤@³æ¤¸®æ¼Æ²Õ¤½¦¡ ........... 337 12.2.1 ³æ¤@³æ¤¸®æ¼Æ²Õ¤½¦¡ªº¨âÓ¹ê¨Ò ....... 337 12.2.2 MMULT ¨ç¼ÆÀ³¥Î .......... 339 12.2.3 À³¦¬½ã´Ú§EÃB½ãÄÖªºpºâ ......... 341 12.2.4 ¤@¹ï¦h¬d¸ß¸g¨åÀ³¥Î ......... 342 12.3 ¦h³æ¤¸®æ¼Æ²Õ¤½¦¡ ........... 344 12.3.1 ±ø¥ó¨D©M ........... 344 12.3.2 «ö¦~ÄÖ¬q²ÎpÃ㾤H¼ÆªºÀW²v¤À¥¬ ....... 345 12.3.3 ¹w´ú¥¼¨ÓÈ ........... 346 ²Ä13 ³¹ ¨ç¼Æ»P¤½¦¡ªººî¦XÀ³¥Î ........... 348 13.1 ´`Àô¤Þ¥Î»P¡¥Npºâ ........... 348 13.2 ÀH¾÷¨ç¼ÆªºÀ³¥Î ........... 350 13.3 ³W¹º¨D¸ÑªºÀ³¥Î ........... 351 13.4 ª½½uªk§éÂÂpºâªí ........... 354 13.5 ¥ý¶i¥ý¥Xªkpºâ®w¦sª«®Æªº½ãÄÖ ......... 356 ²Ä14 ³¹ Excel ¹Ïªí¨î§@§Þ¥© ...........359 14.1 Excel ¹Ïªí¨î§@°ò¦ ...........359 14.1.1 »{ÃÑExcel ¹Ïªín¯À .......... 359 14.1.2 Excel ¹Ïªí¨î§@ì«h ......... 360 14.1.3 Excel ¼Æ¾ÚÃö¨t»P¹Ïªí¿ï¾Ü ......... 361 14.1.4 ¹Ïªí¨î§@ªºª`·N¨Æ¶µ ......... 362 14.2 Excel ¹Ïªí¨î§@§Þ¥©¨t¦C ......... 364 14.2.1 §Ö³t¦V¹Ïªí°l¥[¼Æ¾Ú¨t¦C ......... 364 14.2.2 Åý§é½u¹Ï±qÁa§¤¼Ð¶b¶}©l ......... 365 14.2.3 ³]¸m¹Ïªí¤¬¸É¦â ........... 366 14.2.4 ¹Ïªí°t¦âì«h©M¨ú¦â¤èªk ......... 366 14.2.5 ¦Û°Êø¨î°Ñ¦Ò½u ........... 367 14.2.6 ±N¼Æ¾Ú¿ù¦æ»PªÅ¦æ²Õ´ ......... 368 14.2.7 ¨Ï¥Îº¦/¶^¬W½uÅã¥Ü¹wºâ»P¹ê»Ú®t²§ ...... 370 14.2.8 ²K¥[»~®t½u ........... 372 14.2.9 ø¹Ï«eªº¼Æ¾Ú±Æ§Ç ......... 375 14.2.10 ¥ÎÃC¦â°Ï¤À·~ÁZ°ª§Cªº¬W§Î¹Ï ....... 377 14.2.11 ©~¤_±ø§Î¹Ï¤§¶¡ªº¤ÀÃþ¶b¼Ðñ ........ 379 ²Ä15 ³¹ ±M·~¹Ïªí¨î§@ ........... 382 15.1 ¶êÀô¹Ï ............ 382 15.2 ©·½u¹ï¤ñ¹Ï ........... 384 15.3 ®ðªw¹Ï ............. 386 15.4 ¯x°}¹Ï ............ 389 15.5 ¥ªO¹Ï ............. 392 15.6 ¤£µ¥¼e¬W§Î¹Ï ............. 394 15.7 ·Æ¯]¹Ï ............. 397 15.8 ¤£µ¥¶ZÁa§¤¼Ð¹Ï§Î ........... 400 15.9 ¦Ê¤À¤ñ°ï¿n¬W§Î¹Ï ........... 404 15.10 §Q¥Î¼Æ¾ÚÅçÃҳЫذʺA¹Ï§Î ......... 407 15.11 ¥»¶q§Q¤ÀªR°ÊºA¹Ï ........... 409 15.12 §Q¥Î¦WºÙ»P±±¥ó¨î§@°ÊºA¹Ï§Î ......... 413 15.13 Power View °ò¦........... 417 15.14 Power View BI ¹Ï............ 420 ²Ä16 ³¹ VBA ¦b¼Æ¾Ú³B²z¤¤ªºÀ³¥Î .......... 424 16.1 ¨î§@¥Ø¿ýÃì±µ³øªí ........... 424 16.2 §Q¥Î´`Àô¤À¸Ñ³sÄòµo²¼¸¹½X ......... 425 16.3 VBA ¦Û©w¸q¨ç¼Æ ............ 427 16.4 ¦X¦}¤u§@ªí ............. 430 16.5 ¦X¦}¤u§@ï ............. 431 16.6 ±N¤u§@襤ªº¦h±i¤u§@ªí§å¶q´_¨î¨ìÁ`ªí ....... 434 16.7 ²©ö³ø»ù³æ¨t²Î ........... 436 ªþ¿ýA ¥Î¼Æ¾Ú¼Ð·Ç¤Æ«äºû³WS¼Æ¾Ú .......... 438 |
§Ç¡G |