À´Ô´_ÕýµÂ²ÆÎñ ·¢ÎÄÈÕÆÚ_2024Äê01ÔÂ05ÈÕ
¹Ì¶¨×ʲú¼ÓËÙÕÛ¾ÉÓÅ»ÝÕþ²ß×¢ÒâÊÂÏî
´ð£º¡¶¹ú¼ÒË°Îñ×ֹܾØÓÚ·¢Æ±×¨ÓÃÕÂʽÑùÓйØÎÊÌâµÄ¹«¸æ¡·£¨¹ú¼ÒË°Îñ×ֹܾ«¸æ2011ÄêµÚ7ºÅ£©Ã÷È·¹æ¶¨ÁË·¢Æ±×¨ÓÃÕÂʽµÄÑùʽºÍ¹æ¸ñ£¬Ò»°ã·¢Æ±ÉϼӸǵķ¢Æ±Õ¶¼±ØÐëÊǹ涨¹æ¸ñµÄ¡£µ«ÊÇ£¬Ò²ÓÐÌØÊâÇé¿ö£¬±ÈÈçÎÒÃdz£¼ûµÄ³ö×⳵רÓ÷¢Æ±µÈÌ×Ó¡·¢Æ±×¨ÓÃÕµķ¢Æ±£¬ÓÉÓÚ·¢Æ±¹æ¸ñС£¬²»ÊʺϼӸÇ7ºÅ¹«¸æ¹æ¶¨¹æ¸ñµÄ·¢Æ±×¨ÓÃÕ£¬¿ÉÒÔÌ×Ó¡ÑùʽÏàͬµ«Êǹæ¸ñËõСµÄ·¢Æ±×¨ÓÃÕ£¬¾ßÌåµÄ¹æ¸ñ¿ÉÒԲο¼¸÷µØµÄ¹æ¶¨¡£¡¾¡¿ ÔðÈα༣ºÄà°Í½ã»á¼Æ¹¤×÷»ù±¾Á÷³ÌÓÐÄÄЩ ÄãÐèÒªÖªµÀ
²ÆÎñ¹¤×÷Öظ´·±ÔÓ£¬ÄãÊÇ·ñ¶Ô¹¤×÷ÖÐËùÐèÒªµÄ±í¸ñ×ö¹ýÇåÎúµÄ·ÖÀࣿÄãÊÇ·ñÖªµÀÄÄЩ²ÆÎñ»·½ÚÓ¦¸ÃʹÓÃÄÄЩ²ÆÎñ±í¸ñ£¿¿Î³ÌÒÔ²ÆÎñÈËÔ±ÔÚ¹ÜÀíÖеľßÌåÓ¦ÓÃΪÖ÷Ïߣ¬Ó빤×÷ÐèÒªÏà½áºÏ£¬Ö±½ÓÄ£Äâ°ì¹«ÊÒÏÖ³¡¹¤×÷»·¾³£¬½«ExcelµÄ¹¦ÄÜÇø²Ù×÷¡¢º¯ÊýÓ¦Óá¢Í¼±íÖÆ×÷µÈ¼¼ÇɹᴩÔڲɹºÓë´æ»õ¹ÜÀí³¡¾°Öн²½â£¬Ñ§ÍêÖ®ºó¶Ô²ÆÎñ¹¤×÷ÖÐÄÄЩ»·½ÚÓ¦ÓÃÄÄЩExcel¼¼ÄÜÁËÈçÖ¸ÕÆ£¬Ê¹ÄúµÄExcelʹÓÃˮƽÌáÉýµ½Ò»¸öеIJã´Î¡£¿Î³ÌÏêÇé½éÉܿγÌÃû³ÆÉÏ¿Îʱ¼ä2020Äê11ÔÂ27ÈÕ15:00¡ª¡ª16:30£¬×Ô±¨Ãûºó62ÌìÓÐЧ£¬³©Ñ§¿¨Ãâ·Ñ£¬Ö±²¥ºó¿É¹©»Ø·Å¡£Ê¦×ʽéÉܺúÑ©·É£¬Ö춻á¼ÆÖ°³Æ£¬Ê®ËÄÄê²ÆÎñ¡¢Ë°ÎñÁìÓòʵս¹¤×÷¾Ñ飬ÔøÔÚ¶à¼ÒÉÏÊй«Ë¾ÈÎÖ°£¬´ÓÆÕͨ»á¼ÆÒ»Ö±µ½²ÆÎñ¾Àí£¬Õý±£»á¼ÆÍøУÌØÑû²Æ˰ר¼Ò¡£Åàѵ¶ÔÏó²Æ»á¹¤×÷Õ߿γ̴ó¸ÙÉÌÆ·½øÏú´æÌ×±íÉè¼Æ²É¹º³É±¾·ÖÎö¿â´æ·ÖÎö³ö¿â³É±¾¼ÆËã¡¢ÏúÊÛëÀû·ÖÎöºËËãÄ£°åÖ÷Òª¹´»ü¹Øϵ²É¹ºÓë´æ»õºËË㹤×÷ÖбØÐëÕÆÎÕµÄexcelº¯Êý£ºindex¡¢match¡¢countif¡¢sumifsµÈ¿Î³ÌÊÕÒæͨ¹ý¿Î³Ìѧϰ£¬ÕÆÎÕ²ÆÎñ¹¤×÷Öи÷ÒµÎñ»·½Ú±Ø»áµÄExcel¼¼ÇÉ£¬×î´óÏ޶ȵØÌá¸ß¹¤×÷ЧÂÊ¡£ ¡¾°¸Àý½²½â¡¿»¥ÁªÍøÀí²ÆµÄÒµÎñģʽÏÂÕËÎñ´¦Àí