²½Öè1£ºÔÚK3µ¥Ôª¸ñÖÐÊäÈë\£¬°´Enter¼üºóÍê³É×Ü·ÖµÄ×Ô¶¯Ìî³ä¡£
²½Öè2£ºÔÚL3µ¥Ôª¸ñÖÐÊäÈë\£¬°´Enter¼üºóÍê³Éƽ¾ù·ÖµÄ×Ô¶¯Ìî³ä¡£ 4.½âÌâ²½Ö裺
²½Öè1£ºÔÚC3µ¥Ôª¸ñÖÐÊäÈë\°à\°à\°à\£¬°´Enter¼üºóÍê³É°à¼¶µÄ×Ô¶¯Ìî³ä¡£ 5.½âÌâ²½Ö裺
²½Öè1£ºÔÚB3µ¥Ôª¸ñÖÐÊäÈë\ѧºÅ¶ÔÕÕ!$A$3:$B$20,2,FALSE)\£¬°´Enter¼üºóÍê³ÉÐÕÃûµÄ×Ô¶¯Ìî³ä¡£ 6.½âÌâ²½Ö裺
²½Öè1£ºÔÚ\³É¼¨·ÖÀà»ã×Ü\¹¤×÷±íÖÐÑ¡Öе¥Ôª¸ñC3£ºC20£¬µ¥»÷¡¾Êý¾Ý¡¿Ñ¡ÏÏ¡¾ÅÅÐòºÍɸѡ¡¿×éÖеÄ\ÉýÐò\°´Å¥£¬µ¯³ö\ÅÅÐòÌáÐÑ\¶Ô»°¿ò£¬µ¥»÷\À©Õ¹Ñ¡¶¨ÇøÓò\µ¥Ñ¡°´Å¥¡£µ¥»÷\ÅÅÐò\°´Å¥£¬Íê³É\°à¼¶\ÁеÄÉýÐòÅÅÐò¡£
²½Öè2£ºÑ¡Öе¥Ôª¸ñC21£¬µ¥»÷¡¾Êý¾Ý¡¿Ñ¡ÏÏ¡¾·Ö¼¶ÏÔʾ¡¿×éÖеÄ\·ÖÀà»ã×Ü\°´Å¥£¬µ¯³ö\·ÖÀà»ã×Ü\¶Ô»°¿ò£¬µ¥»÷\·ÖÀà×Ö¶Î\ÏÂÀ°´Å¥Ñ¡Ôñ\°à¼¶\£¬µ¥»÷\»ã×Ü·½Ê½\ÏÂÀ°´Å¥Ñ¡Ôñ\×î´óÖµ\£¬ÔÚ\Ñ¡¶¨»ã×ÜÏî\¸´Ñ¡¿òÖй´Ñ¡\ÓïÎÄ\¡¢\Êýѧ\¡¢\Ó¢Óï\¡¢\ÉúÎï\¡¢\µØÀí\¡¢\ÀúÊ·\¡¢\ÕþÖÎ\¡£¹´Ñ¡\»ã×ܽá¹ûÏÔʾÔÚÊý¾ÝÏ·½\¸´Ñ¡¿ò¡£µ¥»÷\È·¶¨\°´Å¥¡£ 7½âÌâ²½Ö裺
²½Öè1£ºÑ¡ÖÐÿ¸ö°à¸÷¿Æ×î´ó³É¼¨ËùÔڵĵ¥Ôª¸ñ£¬µ¥»÷¡¾²åÈë¡¿Ñ¡ÏÏ¡¾Í¼±í¡¿×éÖÐ\ÌõÐÎͼ\°´Å¥£¬Ñ¡Ôñ\´Ø×´ÌõÐÎͼ\¡£
²½Öè2£ºÓÒ»÷ͼ±íÇø£¬Ñ¡Ôñ\Ñ¡ÔñÊý¾Ý\£¬µ¯³ö\Ñ¡ÔñÊý¾ÝÔ´\¶Ô»°¿ò£¬Ñ¡ÖÐ\ͼÀýÏî\ϵÄ\ϵÁÐ1\£¬µ¥»÷\±à¼\°´Å¥£¬µ¯³ö\±à¼Êý¾ÝϵÁÐ\¶Ô»°¿ò£¬ÔÚ\ϵÁÐÃû³Æ\ÖÐÊäÈë\°à\¡£µ¥»÷\È·¶¨\°´Å¥ºó°´ÕÕͬÑù·½·¨±à¼\ϵÁÐ2\¡¢\ϵÁÐ3\Ϊ\°à\¡¢\°à\¡£
²½Öè3£ºÔÚ\Ñ¡ÔñÊý¾ÝÔ´\¶Ô»°¿òÖУ¬Ñ¡ÖÐ\ˮƽ£¨·ÖÀࣩÖá±êÇ©\ϵÄ\£¬µ¥»÷\±à¼\°´Å¥£¬µ¯³ö\Öá±êÇ©\¶Ô»°¿ò£¬ÔÚ\Öá±êÇ©ÇøÓò\ÏÂÊäÈë\ÓïÎÄ,Êýѧ,Ó¢Óï,ÉúÎï,µØÀí,ÀúÊ·,ÕþÖÎ\¡£µ¥»÷\È·¶¨\°´Å¥¼´¿ÉÍê³ÉÉèÖᣠ8.½âÌâ²½Ö裺
µ¥»÷\±£´æ\°´Å¥£¬Íê³É\µÚһѧÆÚÆÚÄ©³É¼¨.xlsx\µÄ±£´æ¡£
9/СÀîÔÚ¶«·½¹«Ë¾µ£ÈÎÐÐÕþÖúÀí£¬Äêµ×СÀîͳ¼ÆÁ˹«Ë¾Ô±¹¤µµ°¸ÐÅÏ¢µÄ·ÖÎöºÍ»ã×Ü¡£
ÇëÄã¸ù¾Ý¶«·½¹«Ë¾Ô±¹¤µµ°¸±í£¨\Îļþ£©£¬°´ÕÕÈçÏÂÒªÇóÍê³Éͳ¼ÆºÍ·ÖÎö¹¤×÷£º
1. Çë¶Ô\Ô±¹¤µµ°¸±í\¹¤×÷±í½øÐиñʽµ÷Õû£¬½«ËùÓй¤×ÊÁÐÉèΪ±£ÁôÁ½Î»Ð¡ÊýµÄÊýÖµ£¬Êʵ±¼Ó´óÐиßÁÐ¿í¡£ 2. ¸ù¾ÝÉí·ÝÖ¤ºÅ£¬ÇëÔÚ\Ô±¹¤µµ°¸±í\¹¤×÷±íµÄ\³öÉúÈÕÆÚ\ÁÐÖУ¬Ê¹ÓÃMIDº¯ÊýÌáÈ¡Ô±¹¤ÉúÈÕ£¬µ¥Ôª¸ñʽÀàÐÍΪ\Äê'm'ÔÂ'd'ÈÕ'\¡£
3. ¸ù¾ÝÈëְʱ¼ä£¬ÇëÔÚ\Ô±¹¤µµ°¸±í\¹¤×÷±íµÄ\¹¤Áä\ÁÐÖУ¬Ê¹ÓÃTODAYº¯ÊýºÍINTº¯Êý¼ÆËãÔ±¹¤µÄ¹¤Á䣬¹¤×÷ÂúÒ»Äê²Å¼ÆÈ빤Áä¡£
4.ÒýÓÃ\¹¤Á乤×Ê\¹¤×÷±íÖеÄÊý¾ÝÀ´¼ÆËã\Ô±¹¤µµ°¸±í\¹¤×÷±íÔ±¹¤µÄ¹¤Á乤×Ê£¬ÔÚ\»ù´¡¹¤×Ê\ÁÐÖУ¬¼ÆËãÿ¸öÈ˵Ļù´¡¹¤×Ê¡££¨»ù´¡¹¤×Ê=»ù±¾¹¤×Ê+¹¤Á乤×Ê£© 5. ¸ù¾Ý\Ô±¹¤µµ°¸±í\¹¤×÷±íÖеŤ×ÊÊý¾Ý£¬Í³¼ÆËùÓÐÈ˵Ļù´¡¹¤×Ê×ܶ²¢½«ÆäÌîдÔÚ\ͳ¼Æ±¨¸æ\¹¤×÷±íµÄB2µ¥Ôª¸ñÖС£
6. ¸ù¾Ý\Ô±¹¤µµ°¸±í\¹¤×÷±íÖеŤ×ÊÊý¾Ý£¬Í³¼ÆÖ°ÎñΪÏîÄ¿¾ÀíµÄ»ù±¾¹¤×Ê×ܶ²¢½«ÆäÌîдÔÚ\ͳ¼Æ±¨¸æ\¹¤×÷±íµÄB3µ¥Ôª¸ñÖС£ 7. ¸ù¾Ý\Ô±¹¤µµ°¸±í\¹¤×÷±íÖеÄÊý¾Ý£¬Í³¼Æ¶«·½¹«Ë¾±¾¿ÆÉúƽ¾ù»ù±¾¹¤×Ê£¬²¢½«ÆäÌîдÔÚ\ͳ¼Æ±¨¸æ\¹¤×÷±íµÄB4µ¥Ôª¸ñÖС£
8. ͨ¹ý·ÖÀà»ã×ܹ¦ÄÜÇó³öÿ¸öÖ°ÎñµÄƽ¾ù»ù±¾¹¤×Ê¡£
9. ´´½¨Ò»¸ö±ýͼ£¬¶Ôÿ¸öÔ±¹¤µÄ»ù±¾¹¤×ʽøÐбȽϣ¬²¢½«¸Ãͼ±í·ÅÖÃÔÚ\ͳ¼Æ±¨¸æ\ÖС£
10. ±£´æ\Îļþ¡£
1.½âÌâ²½Ö裺
²½Öè1£ºÆô¶¯¿¼ÉúÎļþϵÄ\£¬´ò¿ª\Ô±¹¤µµ°¸\¹¤×÷±í¡£
²½Öè2£ºÑ¡ÖÐËùÓй¤×ÊÁе¥Ôª¸ñ£¬µ¥»÷¡¾¿ªÊ¼¡¿Ñ¡ÏÏ¡¾µ¥Ôª¸ñ¡¿×éÖеÄ\¸ñʽ\ÏÂÀ°´Å¥£¬ÔÚµ¯³öµÄÏÂÀÁбíÖÐÑ¡Ôñ\ÉèÖõ¥Ôª¸ñ¸ñʽ\ÃüÁµ¯³ö\ÉèÖõ¥Ôª¸ñ¸ñʽ\¶Ô»°¿ò¡£ÔÚ\Êý×Ö\Ñ¡Ï\·ÖÀà\×éÖÐÑ¡Ôñ\ÊýÖµ\£¬ÔÚСÊýλÊý΢µ÷¿òÖÐÉèÖÃСÊýλÊýΪ\¡£ÉèÖÃÍê±Ïºóµ¥»÷\È·¶¨\°´Å¥¼´¿É¡£
²½Öè3£ºÑ¡ÖÐËùÓе¥Ôª¸ñÄÚÈÝ£¬µ¥»÷¡¾¿ªÊ¼¡¿Ñ¡ÏÏ¡¾µ¥Ôª¸ñ¡¿×éÖеÄ\¸ñʽ\ÏÂÀ°´Å¥£¬ÔÚµ¯³öµÄÏÂÀÁбíÖÐÑ¡Ôñ¡°×Ô¶¯µ÷ÕûÐиߡ±ÃüÁî¡£
²½Öè4£ºµ¥»÷¡¾¿ªÊ¼¡¿Ñ¡ÏÏ¡¾µ¥Ôª¸ñ¡¿×éÖеÄ\¸ñʽ\ÏÂÀ°´Å¥£¬°´ÕÕÉèÖÃÐиßͬÑùµÄ·½Ê½Ñ¡Ôñ¡°×Ô¶¯µ÷ÕûÁÐ¿í¡±ÃüÁî¡£ 2.½âÌâ²½Ö裺
²½Öè1£ºÔÚ¡°Ô±¹¤µµ°¸¡±±í¹¤×÷±íÖÐG3µ¥Ôª¸ñÖÐÊäÈë\Äê\ÔÂ\ÈÕ\£¬°´\¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÔ±¹¤£¬²¢Êʵ±µ÷Õû¸ÃÁеÄÁÐ¿í¡£ 3.½âÌâ²½Ö裺
²½Öè1£ºÔÚ¡°Ô±¹¤µµ°¸¡±±íµÄJ3µ¥Ôª¸ñÖÐÊäÈë\365)\£¬±íʾµ±Ç°ÈÕÆÚ¼õÈ¥Èëְʱ¼äµÄÓà¶î³ýÒÔ365ÌìºóÔÙÏòÏÂÈ¡Õû£¬°´Enter¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÔ±¹¤¡£ 4.½âÌâ²½Ö裺
²½Öè1£ºÔÚ¡°Ô±¹¤µµ°¸¡±±íµÄL3µ¥Ôª¸ñÖÐÊäÈë\¹¤Á乤×Ê!$B$3\£¬°´\¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÔ±¹¤¡£
²½Öè2£ºÔÚM3µ¥Ôª¸ñÖÐÊäÈë\£¬°´\¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÔ±¹¤¡£ 5.½âÌâ²½Ö裺
²½Ö裺ÔÚ\ͳ¼Æ±¨¸æ\¹¤×÷±íÖеÄB2µ¥Ôª¸ñÖÐÊäÈë\Ô±¹¤µµ°¸!M3:M37)\£¬°´\¼üÈ·ÈÏ¡£ 6.½âÌâ²½Ö裺
²½Ö裺ÔÚ\ͳ¼Æ±¨¸æ\¹¤×÷±íÖеÄB3µ¥Ôª¸ñÖÐÊäÈë\Ô±¹¤µµ°¸!K6+Ô±¹¤µµ°¸!K7\°´Enter¼üÈ·ÈÏ¡£ 7.½âÌâ²½Ö裺
²½Ö裺ÉèÖÃ\ͳ¼Æ±¨¸æ\¹¤×÷±íÖеÄB4µ¥Ôª¸ñ¸ñʽΪ2ΪСÊý£¬È»ºóÔÚB4µ¥Ôª¸ñÖÐÊäÈë\Ô±¹¤µµ°¸!H3:H37,\±¾¿Æ\£¬Ô±¹¤µµ°¸!K3:K37)\£¬°´Enter¼üÈ·ÈÏ¡£ 8.½âÌâ²½Ö裺
²½Öè1£ºÑ¡ÖÐE38£¬µ¥»÷¡¾Êý¾Ý¡¿Ñ¡ÏÏ¡¾·Ö¼¶ÏÔʾ¡¿×éÖеÄ\·ÖÀà»ã×Ü\°´Å¥£¬µ¯³ö\·ÖÀà»ã×Ü\¶Ô»°¿ò¡£µ¥»÷\·ÖÀà×Ö¶Î\×éÖеÄÏÂÀ°´Å¥Ñ¡Ôñ\Ö°Îñ\£¬µ¥»÷\»ã×Ü·½Ê½\×éÖеÄÏÂÀ°´Å¥Ñ¡Ôñ\ƽ¾ùÖµ\£¬ÔÚ\Ñ¡¶¨»ã×ÜÏî\×éÖй´Ñ¡\»ù±¾¹¤×Ê\¸´Ñ¡¿ò¡£ ²½Öè2£ºµ¥»÷\È·¶¨\°´Å¥¼´¿É¿´µ½Êµ¼ÊЧ¹û¡£
9.½âÌâ²½Ö裺
²½Öè1£ºÍ¬Ê±Ñ¡ÖÐÿ¸öÖ°Îñƽ¾ù»ù±¾¹¤×ÊËùÔڵĵ¥Ôª¸ñ£¬µ¥»÷¡¾²åÈë¡¿Ñ¡ÏÏ¡¾Í¼±í¡¿×éÖеÄ\±ýͼ\°´Å¥£¬Ñ¡Ôñ\·ÖÀëÐͱýͼ\ÃüÁî¡£
²½Öè2£ºÓÒ»÷ͼ±íÇø£¬Ñ¡Ôñ\Ñ¡ÔñÊý¾Ý\ÃüÁµ¯³ö\Ñ¡ÔñÊý¾ÝÔ´\¶Ô»°¿ò£¬Ñ¡ÖÐ\ˮƽ£¨·ÖÀࣩÖá±êÇ©\ϵÄ\£¬µ¥»÷\±à¼\°´Å¥£¬µ¯³ö\Öá±êÇ©\¶Ô»°¿ò£¬ÔÚ\Öá±êÇ©ÇøÓò\ÖÐÊäÈë\²¿ÃžÀí,ÈËÊÂÐÐÕþ¾Àí,ÎÄÃØ,ÏîÄ¿¾Àí,ÏúÊÛ¾Àí,Ñз¢¾Àí,Ô±¹¤,×ܾÀí\¡£ ²½Öè3£ºµ¥»÷\È·¶¨\°´Å¥¡£
²½Öè3:£º¼ôÇиÃͼ¸´ÖƵ½\ͳ¼Æ±¨¸æ\¹¤×÷±íÖС£ 8.½âÌâ²½Ö裺
²½Ö裺µ¥»÷\±£´æ\°´Å¥£¬±£´æ\Îļþ¡£
10/СÍõ½ñÄê±ÏÒµºó£¬ÔÚÒ»¼Ò¼ÆËã»úͼÊéÏúÊÛ¹«Ë¾µ£ÈÎÊг¡²¿ÖúÀí£¬Ö÷ÒªµÄ¹¤×÷Ö°Ôð
ÊÇΪ²¿ÃžÀíÌṩÏúÊÛÐÅÏ¢µÄ·ÖÎöºÍ»ã×Ü¡£
ÇëÄã¸ù¾ÝÏúÊÛͳ¼Æ±í£¨¡°Excel.xlsx¡± Îļþ£©£¬°´ÕÕÈçÏÂÒªÇóÍê³Éͳ¼ÆºÍ·ÖÎö¹¤×÷£º
1. ½«¡°sheet1¡±¹¤×÷±íÃüÃûΪ¡°ÏúÊÛÇé¿ö¡±£¬½«¡°sheet2¡±ÃüÃûΪ¡°Í¼Ê鶨¼Û¡±¡£
2. ÔÚ¡°Í¼ÊéÃû³Æ¡±ÁÐÓÒ²à²åÈëÒ»¸ö¿ÕÁУ¬ÊäÈëÁбêÌâΪ¡°µ¥¼Û¡±¡£ 3. ½«¹¤×÷±í±êÌâ¿çÁкϲ¢ºó¾ÓÖв¢Êʵ±µ÷ÕûÆä×ÖÌå¡¢¼Ó´ó×ֺţ¬²¢¸Ä±ä×ÖÌåÑÕÉ«¡£ÉèÖÃÊý¾Ý±í¶ÔÆ뷽ʽ¼°µ¥¼ÛºÍС¼ÆµÄÊýÖµ¸ñʽ£¨±£Áô2λСÊý£©¡£¸ù¾ÝͼÊé±àºÅ£¬ÇëÔÚ¡°ÏúÊÛÇé¿ö¡±¹¤×÷±íµÄ¡°µ¥¼Û¡±ÁÐÖУ¬Ê¹ÓÃVLOOKUPº¯ÊýÍê³ÉͼÊéµ¥¼ÛµÄÌî³ä¡£¡°µ¥¼Û¡±ºÍ¡°Í¼Êé±àºÅ¡±µÄ¶ÔÓ¦¹ØϵÔÚ¡°Í¼Ê鶨¼Û¡±¹¤×÷±íÖС£ 4.ÔËÓù«Ê½¼ÆË㹤×÷±í¡°ÏúÊÛÇé¿ö¡±ÖÐHÁеÄС¼Æ¡£
5. Ϊ¹¤×÷±í¡°ÏúÊÛÇé¿ö¡±ÖеÄÏúÊÛÊý¾Ý´´½¨Ò»¸öÊý¾Ý͸ÊÓ±í£¬·ÅÖÃÔÚÒ»¸öÃûΪ¡°Êý¾Ý͸ÊÓ·ÖÎö¡±µÄй¤×÷±íÖУ¬ÒªÇóÕë¶Ô¸÷Êéµê±È½Ï¸÷ÀàÊéÿÌìµÄÏúÊ۶ÆäÖУºÊéµêÃû³ÆΪÁбêÇ©£¬ÈÕÆÚºÍͼÊéÃû³ÆΪÐбêÇ©£¬²¢¶ÔÏúÊÛ¶îÇóºÍ¡£ 6. ¸ù¾ÝÉú³ÉµÄÊý¾Ý͸ÊÓ±í£¬ÔÚ͸ÊÓ±íÏ·½´´½¨Ò»¸ö´Ø×´ÖùÐÎͼ£¬Í¼±íÖнö¶Ô²©´ïÊéµêÒ»Ô·ݵÄÏúÊÛ¶îС¼Æ½øÐбȽϡ£ 7. ±£´æ¡°Excel.xlsx¡±Îļþ¡£
1.½âÌâ²½Ö裺
²½Öè1£ºÆô¶¯¿¼ÉúÎļþ¼ÐϵÄ\¡£
²½Öè2£ºË«»÷\¹¤×÷±íÃû£¬´ý\³Ê±à¼×´Ì¬ºóÊäÈë\ÏúÊÛÇé¿ö\¼´¿É£¬°´ÕÕͬÑùµÄ·½Ê½½«\ÃüÃûΪ\ͼÊ鶨¼Û\¡£ 2.½âÌâ²½Ö裺
²½Öè1£ºÔÚ¡°ÏúÊÛÇé¿ö¡±¹¤×÷±íÖУ¬Ñ¡ÖÐ\ÏúÁ¿£¨±¾£©\ËùÔÚµÄÁУ¬µ¥»÷Êó±êÓÒ¼ü£¬ÔÚµ¯³öµÄµÄÁбíÖÐÑ¡Ôñ\²åÈë\ÃüÁî¡£
²½Öè2£º¹¤×÷±íÖÐËæ¼´³öÏÖвåÈëµÄÒ»ÁС£ ²½Öè3£ºÑ¡ÖÐF2µ¥Ôª¸ñ£¬ÊäÈë\µ¥¼Û\¶þ×Ö¡£ 3.½âÌâ²½Ö裺
²½Öè1£ºÔÚ¡°ÏúÊÛÇé¿ö¡±¹¤×÷±íÖÐÑ¡ÖÐA1£ºH1µ¥Ôª¸ñ£¬µ¥»÷Êó±êÓÒ¼ü£¬ÔÚµ¯³öµÄÏÂÀÁбíÖÐÑ¡Ôñ\ÉèÖõ¥Ôª¸ñ¸ñʽ\ÃüÁµ¯³ö\ÉèÖõ¥Ôª¸ñ¸ñʽ\¶Ô»°¿ò¡£ÔÚ\¶ÔÆë\Ñ¡ÏϵÄ\Îı¾¿ØÖÆ\×éÖУ¬¹´Ñ¡\ºÏ²¢µ¥Ôª¸ñ\¸´Ñ¡¿ò£»ÔÚ\Îı¾¶ÔÆ뷽ʽ\×éµÄ\ˮƽ¶ÔÆë\Ñ¡ÏîÏÂÑ¡Ôñ\¾ÓÖÐ\£¬¶øºóµ¥»÷\È·¶¨\¼´¿É¡£
²½Öè2£º°´ÕÕͬÑùµÄ·½Ê½´ò¿ª\ÉèÖõ¥Ôª¸ñ¸ñʽ\¶Ô»°¿ò£¬Çл»ÖÁ\×ÖÌå\Ñ¡Ï£¬ÔÚ\×ÖÌå\ÏÂÀÁбíÖÐÑ¡ÔñÒ»ÖÖºÏÊʵÄ×ÖÌ壬´Ë´¦ÎÒÃÇÑ¡Ôñ\΢ÈíÑźÚ\¡£ÔÚ\×ÖºÅ\ÏÂÀÁбíÖÐÑ¡ÔñÒ»ÖÖºÏÊʵÄ×ֺţ¬´Ë´¦ÎÒÃÇÑ¡Ôñ\¡£ÔÚ\ÑÕÉ«\ÏÂÀÁбíÖÐÑ¡ÔñºÏÊʵÄÑÕÉ«£¬´Ë´¦ÎÒÃÇÑ¡Ôñ\±ê׼ɫ\ÖеÄ\À¶É«\¡£µ¥»÷\È·¶¨\°´Å¥¡£
²½Öè3£º½«¹â±êÖÃÓÚÊý¾ÝÇøÓòÈÎһλÖ㬰´Ctrl+A¼üÑ¡ÖÐÕû¸öÊý¾ÝÇøÓò£¬ÔÚ¡¾¿ªÊ¼¡¿Ñ¡Ïϵġ¾¶ÔÆ뷽ʽ¡¿×éÖÐÑ¡ÔñºÏÊʵĶÔÆ뷽ʽ£¬´Ë´¦ÎÒÃÇÑ¡Ôñ\¾ÓÖÐ\¡£
²½Öè4£ºÍ¬Ê±Ñ¡ÖÐ\µ¥¼Û\ºÍ\С¼Æ\ÁУ¬µ¥»÷Êó±êÓÒ¼ü£¬ÔÚµ¯³öµÄÏÂÀÁбíÖÐÑ¡Ôñ\ÉèÖõ¥Ôª¸ñ¸ñʽ\ÃüÁµ¯³ö\ÉèÖõ¥Ôª¸ñ¸ñʽ\¶Ô»°¿ò¡£Çл»ÖÁ\Êý×Ö\Ñ¡Ï£¬ÔÚ\·ÖÀà\ÏÂÀÁбíÖÐÑ¡Ôñ\ÊýÖµ\£¬ÔÚÓÒ²àµÄСÊýλÊý΢µ÷¿òÖÐÊäÈë\£¬ÉèÖÃÍê±Ïºóµ¥»÷\È·¶¨\°´Å¥¼´¿É¡£ 4.½âÌâ²½Ö裺 ²½Öè1£ºÔÚ\ÏúÊÛÇé¿ö\¹¤×÷±íµÄF3µ¥Ôª¸ñÖÐÊäÈë\ͼÊ鶨¼Û!$A$3:$C$19,3,FALSE)\£¬°´\¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÊý¾ÝÐС£
²½Öè2£ºÔÚ\ÏúÊÛÇé¿ö\¹¤×÷±íµÄH3µ¥Ôª¸ñÖÐÊäÈë\£¬°´\¼üÈ·ÈÏ£¬È»ºóÏòÏÂÌî³ä¹«Ê½µ½×îºóÒ»¸öÊý¾ÝÐС£ 5.½âÌâ²½Ö裺
²½Öè1£ºÔÚ\ÏúÊÛÇé¿ö\¹¤×÷±íÖÐÑ¡ÖÐÊý¾ÝÇøÓò£¬ÔÚ¡¾²åÈë¡¿Ñ¡Ïϵġ¾±í¸ñ¡¿×éÖе¥»÷\Êý¾Ý͸ÊÓ±í\°´Å¥£¬´ò¿ª\´´½¨Êý¾Ý͸ÊÓ±í\¶Ô»°¿ò£¬ÔÚ\Ñ¡Ôñ·ÅÖÃÊý¾Ý͸ÊÓ±íµÄλÖÃ\Ñ¡Ôñ\й¤×÷±í\µ¥Ñ¡°´Å¥¡£
²½Öè2£ºµ¥»÷\È·¶¨\°´Å¥ºó¼´¿É¿´µ½Êµ¼ÊЧ¹û¡£ ²½Öè3£ºË«»÷\£¬ÖØÃüÃûΪ\Êý¾Ý͸ÊÓ·ÖÎö\¡£
²½Öè4£º½«Êó±ê·ÅÖÃÓÚ\ÊéµêÃû³Æ\ÉÏ£¬´ýÊó±ê¼ýÍ·±äΪ˫ÏòÊ®×Ö¼ýÍ·ºóÍ϶¯Êó±êµ½\ÁбêÇ©\ÖУ¬°´ÕÕͬÑùµÄ·½Ê½Í϶¯\ÈÕÆÚ\ºÍ\ͼÊéÃû³Æ\µ½\ÐбêÇ©\ÖУ¬Í϶¯\С¼Æ\ÖÁ\ÊýÖµ\ÖС£ 6.½âÌâ²½Ö裺
²½Öè1£ºÑ¡Öв©´ïÊéµêÏúÊÛ¶îС¼Æ£¬µ¥»÷¡¾¿ªÊ¼¡¿Ñ¡ÏÏ¡¾Í¼±í¡¿×éÖеÄ\ÖùÐÎͼ\°´Å¥£¬ÔÚµ¯³öµÄÏÂÀÁбíÖÐÑ¡Ôñ\´Ø×´ÖùÐÎͼ\ÃüÁî¡£
²½Öè2£ºÔÚ\Êý¾Ý͸ÊÓͼ\Öе¥»÷\ÊéµêÃû³Æ\ÓÒ²àÏÂÈý½Ç°´Å¥£¬ÔÚÏÂÀÁбíÖÐֻѡÔñ\²©´ïÊéµê\¸´Ñ¡¿ò¡£
²½Öè3£ºµ¥»÷\È·¶¨\°´Å¥¡£ 7.½âÌâ²½Ö裺
²½Ö裺µ¥»÷\±£´æ\°´Å¥£¬±£´æ\Îļþ¡£
11/ СÁÖÊDZ±¾©Ä³Ê¦·¶´óѧ²ÆÎñ´¦µÄ»á¼Æ£¬¼ÆËã»úϵ¼ÆËã»ú»ù´¡ÊÒÌá½»Á˸ýÌ
ÑÐÊÒ2012ÄêµÄ¿Î³ÌÊÚ¿ÎÇé¿ö£¬Ï£Íû²ÆÎñ´¦¾¡¿ìºËËã²¢·¢·ÅËûÃÇÊҵĿÎʱ·Ñ¡£Çë¸ù¾Ý¿¼ÉúÎļþ¼ÐÏÂ\ËزÄ.xlsx\Öеĸ÷ÖÖÇé¿ö£¬°ïÖúСÁÖºËËã³ö¼ÆËã»ú»ù´¡ÊÒ2012Äê¶Èÿ¸ö½ÌÔ±µÄ¿Îʱ·ÑÇé¿ö¡£¾ßÌåÒªÇóÈçÏ£º