yh818ÒøºÓ

ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñΪÁËÂú×ãÖ÷¹Ë¸÷·½ÃæµÄÐèÇó £¬ÊµÊ±ÁË½â²¢ÕÆÎÕÁíÀàÍøÕ¾ÖÆ×÷±í¸ñÔõô×ö²úÆ·µÄÁ÷Ïò¡¢Êг¡ÊÊÓ¦ÐÔ¡¢²úÆ·¼Û¸ñ¶¨Î»ÒÔ¼°¿Í»§¶Ô²úÆ·µÄÂúÒâˮƽ £¬ÌØÖƶ¨ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñµÄ²úƷЧÀͼƻ®¡£

±¾ÎÄĿ¼һÀÀ£º

  • 1¡¢ÔõÑùÖÆ×÷бÏß±íÍ·
  • 2¡¢ÁíÀàExcelÆÊÎö-PQÊý¾ÝÇåÏ´
  • 3¡¢ÈçºÎÖÆ×÷µç×Ó¼òÀú±í
  • 4¡¢WPS±í¸ñ°ì¹«¡ª-±í¸ñÆÀ·ÖÁíÀàÆÀ¼¶
  • 5¡¢WPSexcelÈçºÎÖÆ×÷ÁíÀàºìÉ«ÐDZê±í¸ñ

ÔõÑùÖÆ×÷бÏß±íÍ·

·­¿ªÐèÒªÖÆ×÷±í¸ñ¶Ô½ÇÏßµÄWordÎĵµ¡£ µã»÷ÐèÒªÖÆ×÷¶Ô½ÇÏߵĵ¥Î»¸ñ £¬È»ºóµã»÷±í¸ñÑùʽ £¬Ñ¡Ôñ»ØÖ´Ð±Ïß±íÍ·¡£ Ñ¡ÔñÒ»¸öбÏßµ¥Î»¸ñÀàÐÍ £¬È»ºóµã»÷È·¶¨¡£ ËùÑ¡µÄµ¥Î»¸ñ¾Í±»»æÖƳöÁíÀàÍøÕ¾ÖÆ×÷±í¸ñÁ˶ԽÇÏßÁË¡£ ÒÔÉϾÍÊÇÖÆ×÷word±í¸ñµÄ¶Ô½ÇÏߵĽ̳ÌÁË £¬Ñ§»áÁ˵ÄСͬ°é¿ìÈ¥ÊÔÊÔ°É*¡£(¨@¨A*)*¡£

T±íÍ·ÐèÒªÁ½¸öÉõÖÁ¶à¸öÌâÄ¿ £¬±íÍ·Ì«³¤ÄÚÈÝÓÖÌ«ÉÙ £¬¿Õ°×¹ý¶à £¬¼«¶ËÓ°ÏìÃÀ¹Û£¡J ½â¾öÕâÑùµÄÎÊÌâ £¬Ö»ÐèÒªÒ»ÕÐ¾Í OK~ ÄǾÍÊÇбÏß±íÍ·£¡ ½ñÌì½Ì¸÷ÈË--Ϊ±í¸ñÌí¼Ó¶àÖÖбÏß±íÍ·£¡ 01 µ¥Ð±Ïß±íÍ· µ±ÌâĿֻÓÐÁ½¸öµÄʱºò £¬ÎÒÃÇÖ»ÐèҪΪËüÌí¼ÓÒ»ÌõбÏß¡£

ÖÆ×÷µ¥Ð±Ïß±íÍ·Ìí¼ÓбÏ߱߿ò Ñ¡ÖÐÄ¿±êµ¥Î»¸ñ£¨ÈçA1£© £¬µã»÷¡¾¿ªÊ¼¡¿Ñ¡ÏÏ¡¾×ÖÌå¡¿×éÖеı߿ò°´Å¥ÏÂÀ­Èý½Ç £¬Ñ¡Ôñ¡¾ÆäËü±ß¿ò¡¿¡£ÔÚµ¯³öµÄ¡°ÉèÖõ¥Î»¸ñ»¨Ñù-±ß¿ò¡±¶Ô»°¿òÖÐ £¬µã»÷бÏ߱߿ò°´Å¥ £¬µã»÷¡¾È·¶¨¡¿¡£

ÔÚExcelÖÐÖÆ×÷¶àбÏß±íÍ· £¬¿É°´ÒÔϰ취²Ù×÷ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñ£º»æÖÆÐ±Ïß ·­¿ªExcel±í¸ñ £¬µã»÷²Ëµ¥À¸µÄ²åÈëÑ¡Ïî £¬Ñ¡ÔñÐÎ×´ £¬ÔÚÖ±ÏßÑ¡ÏîÖÐѡȡһÌõÖ±Ïß¡£ÔÚÄ¿±êµ¥Î»¸ñÄÚ»æÖƵÚÒ»ÌõбÏß £¬Íê³Éºó°´Ctrl+C¸´ÖƸÃÖ±Ïß £¬ÔÙ°´Ctrl+VÕ³Ìù £¬Í¨¹ýÍ϶¯µ÷½âµÚ¶þÌõбÏßµÄλÖá£Öظ´´Ë²Ù×÷¿ÉÌí¼Ó¸ü¶àбÏß¡£

ÁíÀàExcelÆÊÎö-PQÊý¾ÝÇåÏ´

PQ £¬¼´Power Query £¬ÊÇExcelÖÐÇ¿´óÁíÀàÍøÕ¾ÖÆ×÷±í¸ñµÄÊý¾ÝÇåÏ´¹¤¾ß¡£Ïà±Èº¯ÊýºÍVBA £¬PQµÄѧϰ±¾Ç®µÍ £¬¼ûЧ¿ì £¬´ó´ó¶¼ÎÊÌâÄÜͨ¹ýͼÐνçÃæ²Ù×÷½â¾ö¡£ÒÔÏÂÊÇͨ¹ýÕÐÆ¸ÍøÕ¾Êý¾Ý½øÐÐPQÊý¾ÝÇåÏ´µÄÏêϸ°ì·¨ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñ£ºÊý¾Ý×¼±¸ Ê×ÏÈ £¬ÎÒÃÇÐèÒª»ñÈ¡²¢¼ì²ìÐèÒªÆÊÎöµÄÕÐÆ¸Êý¾Ý¡£ÕâЩÊý¾Ýͨ³£°üÀ¨Ö°Î»Ãû³Æ¡¢ÊÂÇéËùÔÚ¡¢¹«Ë¾ËùÊôÁìÓò¡¢×îµÍнˮºÍ×î¸ßнˮµÈÐÅÏ¢¡£

ÔÚPQÖÐÍê³ÉÊý¾ÝÇåÏ´ºó £¬µã»÷¡°¹Ø±Õ²¢ÉÏÔØ¡±ÖÁExcel¡£ÀûÓÃPivotTable½øÐиüÉîÈëµÄÊý¾ÝÆÊÎö £¬Í¨¹ý¼òµ¥ÍÏ×§¼´¿ÉʵÏÖ͸ÊÓÆÊÎö¡£PQÒÔÆäÖ±¹ÛµÄ½çÃæºÍÏà¶ÔµÍµÄѧϰ±¾Ç® £¬Ê¹Êý¾Ý´¦Àí±äµÃÇá¶øÒ×¾Ù £¬Äܹ»¿ìËÙ½â¾ö´ó´ó¶¼Êý¾ÝÎÊÌ⡣ͨ¹ýÕÆÎÕPQÊý¾ÝÇåÏ´µÄÃØ¾÷ £¬¿ÉÒÔÔÚÈÕ³£ÊÂÇéÖиü¸ßЧµØ½øÐÐÊý¾ÝÆÊÎö¡£

ÔÚ½øÐÐÊý¾ÝÇåϴʱ £¬Îñ±ØÈ·±£Êý¾ÝÔ´µÄһάÐÔºÍÊý¾ÝµÄ׼ȷÐÔ £¬ÒÔÖÆÖ¹ºóÐøÆÊÎöÖеĹýʧ¡£¹ØÓÚÌØÊâÌõ¼þ»òÅÓ´óÂß¼­ £¬¿ÉÒÔʹÓÃPower QueryµÄ×Ô½ç˵Áй¦Ð§À´±àдMÓïÑÔ´úÂë £¬ÒÔʵÏÖ¸üÁé»îµÄÊý¾Ý´¦Àí¡£Í¨¹ýÒÔÉϰ취 £¬ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñÄã¿ÉÒÔÀûÓÃExcel Power QueryÓÐЧµØ½øÐÐÊý¾ÝÇåÏ´ £¬ÎªºóÐøµÄÊý¾ÝÆÊÎöºÍ¿ÉÊÓ»¯´òϼáʵµÄ»ù´¡¡£

ÔÚÊý¾ÝÇåÏ´Àú³ÌÖÐ £¬³£ÓõÄExcelº¯Êý°üÀ¨£º×Ö·û´®´¦Àíº¯Êý£ºÈçFind()¡¢Left()¡¢Right()¡¢Mid()µÈ £¬ÓÃÓÚ´¦ÀíÎı¾Êý¾Ý¡£ÅÌË㺯Êý£ºÈçAverage()¡¢Sum()¡¢Count()¡¢Countif()¡¢Sumif()µÈ £¬ÓÃÓÚ½øÐлù±¾µÄÊýѧÅÌËãºÍͳ¼Æ¡£

Power Query £¬¼ò³ÆPQ £¬ÊÇÒ»¿îÇ¿´óµÄÊý¾Ý´¦Àí¹¤¾ß £¬ÓÈÆäÔÚExcelÖÐ £¬ËüÄܹ»×ÊÖúÓû§¸ßЧµØ½øÐÐÊý¾ÝÇåÏ´¡¢×ª»»ºÍ¼ÓÔØ¡£ÒÔÏÂÊÇPower QueryµÄ»ù´¡½Ì³Ì £¬×ÊÖúÓû§¿ìËÙÉÏÊÖ¡£Power Query¼ò½é Power Queryͨ³£±»·­ÒëΪ¡°³¬µÈÅÌÎÊ¡±»ò¡°ÅÌÎÊÔöÇ¿°æ¡±¡£

Êý¾ÝÇåÏ´ÊÇÊý¾ÝÆÊÎöÀú³ÌÖеÄÖØÒª»·½Ú £¬ËüÉæ¼°Ê¶±ð¡¢¾ÀÕý»òɾ³ýÊý¾Ý¼¯ÖеĹýʧ¡¢Öظ´»ò·×ÆçÖµÄÊý¾Ý¡£Excel×÷Ϊһ¸öÇ¿´óµÄÊý¾Ý´¦Àí¹¤¾ß £¬ÌṩÁ˶àÖÖ¹¦Ð§À´×ÊÖúÓû§½øÐÐÊý¾ÝÇåÏ´¡£ÒÔÏÂÊÇÓÃExcel½øÐÐÊý¾ÝÇåÏ´µÄÏêϸ°ì·¨£ºÊ¶±ð²¢´¦Àíȱʧֵ ²éÕÒȱʧֵ£ºÊ¹ÓÃExcelµÄ¡°Ìõ¼þ»¨Ñù¡±¹¦Ð§À´¿ìËÙʶ±ðȱʧֵ¡£

ÈçºÎÖÆ×÷µç×Ó¼òÀú±í

1¡¢ÖÆ×÷¸öÈ˵ç×Ó¼òÀú¿Éͨ¹ýµçÄÔ¶Ë¡¢ÊÖ»ú¶Ë½øÐÐ £¬ÒÔÏÂΪÄã½éÉܾßÌåÒªÁì¼°×¢ÒâÊÂÏî¡£µçÄÔ¶ËÖÆ×÷°ì·¨Ñ¡Ôñ¹¤¾ßÓëÄ£°å£º¿ÉʹÓÃMicrosoft Word¡¢Google Docs»òWPSµÈ°ì¹«Èí¼þ £¬Ð½¨ÎĵµºóËÑË÷¡°¼òÀúÄ£°å¡± £¬Ìôѡרҵ¼ò½àµÄÄ£°å £¬Ò²ÄÜ×ÔÐÐÉè¼Æ±í¸ñ½á¹¹¡£

2¡¢ÖÆ×÷¸öÈ˼òÀúµç×Ó°æ £¬ÓÐÒÔÏÂÁ½ÖÖ³£¼û·½·¨£ºÀûÓÃÕÐÆ¸ÍøÕ¾Éú³É¿ÉÒÔǰÍùÖлªÓ¢²ÅÍø»òÊÂÇéÎÞÓÇÍø £¬×¢²áÕËºÅºóÆ¾¾ÝÍøÕ¾ÒªÇóÌîд¸öÈË×ÊÁÏ £¬ÏµÍ³±ã»á×Ô¶¯Éú³Éµç×Ó°æ¼òÀú £¬²Ù×÷½ÏΪ¼ò±ã¡£

3¡¢ÔÚµçÄÔÉÏ·­¿ªWORD¿Õ°×Îĵµ £¬ÏÖÔڸÿհ×ÎļþÖÐÊäÈëºÃ±È¸öÈ˼òÀú¡£È»ºóµã»÷ÉÏ·½²Ëµ¥µÄ²åÈë±í¸ñ £¬ÈçÊäÈë7ÁÐ £¬8ÐÐ £¬¾Í¿ÉÒÔ¿´µ½ÔÚÒ³ÃæÖд´Á¢ÁËÒ»¸ö±í¸ñ¡£ÔÚ±í¸ñÖл®·ÖÊäÈë¸öÈ˵Ļù±¾ÐÅÏ¢²¢µ÷½â±í¸ñµÄ¿í¶ÈµÈ¡£ÔÙÔÚ±í¸ñµÄÏ·½ÊäÈëÅàѵ»òÕß½ÌÓý¾­Àú £¬²¢½«ÏàÓ¦µÄ±í¸ñÓèÒԺϲ¢µÖ´ïÃÀ¹ÛµÄˮƽ¡£

4¡¢¸öÈ˼òÀúµç×Ó°æ£ºÖÆ×÷¿ò¼Ü¡£Ê×ÏÈÔÚµçÄÔÉÏduн¨Ò»¸öWordÎĵµ £¬·­¿ªºóµã»÷¡¾²åÈë¡¿-¡¾±í¸ñ¡¿ £¬Ñ¡Ôñ¡¾2x1¡¿µÄ±í¸ñ £»È»ºó½«±í¸ñÀ­ÖÁµÚÒ»Ò³µ×²¿ £¬ÔÙ°ÑÖмäµÄÀ뿪Ïß £¬Íϵ½×ó±ßÈý·ÖÖ®Ò»´¦¡£ÌîдÌâÄ¿¡£

5¡¢ÔÚµçÄÔÉÏÖÆ×÷µç×Ó°æ¼òÀú²¢ÏÂÔØ·¢Ë͵½Î¢Ðŵİ취ÈçÏ£º ·­¿ªµçÄÔÉϵÄWordÈí¼þ £¬´´Á¢Ò»¸öеÄÎĵµ¡£ ÔÚÐÂÎĵµÖÐ £¬µã»÷¹¤¾ßÀ¹ØÁ¬Ä¡°²åÈ롱ѡÏî £¬Ñ¡Ôñ¡°±í¸ñ¡±À´Ìí¼Ó¼òÀúµÄ»ù±¾½á¹¹¡£ É趨±í¸ñµÄÐÐÊýºÍÁÐÊý £¬µã»÷¡°È·¶¨¡±´´Á¢±í¸ñ¡£

WPS±í¸ñ°ì¹«¡ª-±í¸ñÆÀ·ÖÁíÀàÆÀ¼¶

1¡¢Æô¶¯Èí¼þÁíÀàÍøÕ¾ÖÆ×÷±í¸ñ£º·­¿ª×ÀÃæÉÏÁíÀàÍøÕ¾ÖÆ×÷±í¸ñµÄWPS±í¸ñ£¨»òExcel£©¡£·­¿ªÎĵµ£º½øÈëÐèÒª±à¼­µÄ±í¸ñÎļþ¡£È·ÈÏÊý¾Ý£ºÕÒµ½ÐèÒªÆÀ¼¶µÄÆÀÅÅÁУ¨ÈçʾÀýÖеÄEÁУ©¡£ÊäÈ빫ʽ£ºÔÚÁíÀàÆÀ¼¶Áеĵ¥Î»¸ñÖÐÊäÈ빫ʽ£º=REPT( £¬E2)¹«Ê½ËµÃ÷£ºREPTº¯ÊýÓÃÓÚÖØ¸´ÏÔʾָ¶¨×Ö·û¡£

2¡¢ÔÚExcel±í¸ñÖÐ £¬Ê¹ÓÃIFºÍORº¯Êý¶Ô·ÖÊýÆÀ¼¶µÄ°ì·¨ÈçÏ£ºÈ·¶¨ÆÀ¼¶±ê×¼ÀýÈç £¬É趨¡°Èý´Î¿¼ÊÔ·ÖÊýÖÐÈÎÒâÒ»´Î¡Ý85·Ö £¬ÔòÆÀ¶¨ÎªÓÅÐãÁíÀàÍøÕ¾ÖÆ×÷±í¸ñ £»²»È»ÎªÒ»°ã¡±¡£ÊäÈëORº¯ÊýÔÚÄ¿±êµ¥Î»¸ñÖÐÊäÈë=OR() £¬ÓÃÓÚÅж϶à¸öÌõ¼þÊÇ·ñÂú×ãÆäÒ»¡£

3¡¢Ê×ÏÈ £¬·­¿ªWPS±í¸ñ £¬Ñ¡ÔñÐèÒªÊäÈëIFº¯ÊýµÄµ¥Î»¸ñ¡£É趨Ìõ¼þÈçÏ£º90·ÖÒÔÏÂΪC¼¶ £¬90·Ö£¨º¬90£©ÒÔÉÏ £¬120·ÖÒÔÏÂΪB¼¶ £¬120·Ö£¨º¬£©ÒÔÉÏΪA¼¶¡£

4¡¢ÔÚWPS±í¸ñÖÐÊäÈëÐÕÃû¡¢½á¹û £¬ÐèҪƾ¾Ý½á¹ûÅÌËãÅÅÃûºÍÆ·¼¶¡£Ñ¡Ôñ¡°C2¡±µ¥Î»¸ñ²¢µã»÷¡°fx¡±²åÈë¡°rank¡±º¯Êý¡£°´ÏÂͼÊäÈ뺯Êý²ÎÊý £¬×ª»»³É¹«Ê½Îª£º=RANK(B2 £¬$B$2£º$B$9)¡£µã»÷È·¶¨²¢ÏÂÀ­¹«Ê½¼´¿ÉÉú³É¶ÔÓ¦½á¹ûµÄÅÅÃûÇé¿ö¡£

WPSexcelÈçºÎÖÆ×÷ÁíÀàºìÉ«ÐDZê±í¸ñ

ÖÆ×÷ÁíÀàºìÉ«ÐDZê±í¸ñ Ê×ÏÈ £¬ÎÒÃÇÏÈÖÆ×÷³öÒ»¸öÈËԱƷ¼¶µÄ±í¸ñ £¬¿ÉÒÔ½«ÐDZêµÄµ¥Î»¸ñ×ÖÌå¶¼ÉèÖÃΪºìÉ« £¬ÈçÏÂͼËùʾ¡£È»ºóÔÚÐDZêµÄµ¥Î»¸ñÏÂÊäÈ빫ʽ=REPT(¡°¡ï¡± £¬B2)&REPT(¡°¡î¡± £¬7-B2) £¬ÈçÏÂͼËùʾ¡£µ¥»÷»Ø³µ £¬ÎÒÃÇ¿´µ½Æ·¼¶ÐDZê¾ÍÒѾ­ÏÔʾ³öÀ´ÁË £¬Æ·¼¶Îå¾ÍÏÔʾΪÎå¸öʵÐÄÎå½ÇÐÇ £¬ÈçÏÂͼËùʾ¡£µ¥»÷µ¥Î»¸ñµÄÌî³ä¿ò £¬ÏÂÀ­Ìî³ä¿òÍêÉÆÕû¸ö±í¸ñ £¬ÈçÏÂͼËùʾ¡£

ÔÚWPSÎĵµÖ÷½çÃæÉÏ £¬×ó²àÁгöÁË´óµÄ·ÖÀ๦Ч £¬ºÃ±È×ʹÓõÄ×î½ü¡¢ÐDZêÎļþ¡¢ÎÒµÄÎĵµ¡¢ÓëÎÒ¹²Ïí¡¢ÍÅ¶ÓµÈ £¬ÖмäÇøÓò¾ÍÊÇÄÚÈÝÇø £¬Í¨¹ýÁÐ±í¡¢ÑÕɫͼ±ê¡¢»á¼ûʱ¼äµÈ½øÐÐÅŲ¼ £¬ÇåÎú×ÔÈ»¡£ÓÒ²àÊÇÉÏ´«¡¢Ð½¨Îļþ¼ÐµÈ²Ù×÷ £¬ÓÒϽÇÊÇ¿ì½Ý°´Å¥²Ù×÷ £¬»ÆÉ«¡°+¡±Ê®·ÖÐÑÄ¿ £¬²»»áÔì³ÉÀ§ÈÅ¡£

Ê×ÏÈ £¬ÊÖ»úºÍµçÄÔͬʱµÇ°¶QQ £¬²¢Á¬½ÓÉèÖúá£È»ºóÑ¡ÔñµçÄÔQQÉÏÃæ½çÃæÉϵÄÎÒµÄÊÖ»úÑ¡Ïî £¬µã»÷½øÈë¡£µã»÷µ¼ÍÑÊÖ»úÏà²á»òÕß·­¿ªÎļþÖúÊÖ £¬µã»÷½øÈë¡£ÕÒµ½×Ô¼ºÊÖ»úÀïÃæÒªÉÏ´«µÄ´óÎļþ¡££¨ÈçÊÓÆµµÈ£© £¬ÔÚÎļþÇ°ÃæµÄ·½¿ò¹´Ñ¡ÉÏ¡£×îºóÑ¡ÔñµçÄÔÉÏÃæÉú´æµÄλÖà £¬¾Í¿ÉÒÔÉÏ´«ÁË¡£

ÁíÀàÍøÕ¾ÖÆ×÷±í¸ñÊÇÒ»¼Ò¾ßÓÐÍêÕûÉú̬Á´µÄÆóÒµ £¬ËüΪ¿Í»§Ìṩ×ۺϵġ¢×¨ÒµÏÖ´ú»¯×±ÐÞ½â¾ö¼Æ»®¡£ÎªÏû·ÑÕßÌṩ½ÏÓÅÖʵIJúÆ·¡¢½ÏÌùÇеÄЧÀÍ¡¢½Ï¾ß¾ºÕùÁ¦µÄÓªÏúģʽ¡£

°æÈ¨ËùÓУºÄþÏÄyh818ÒøºÓ»·±£¿Æ¼¼ÓÐÏÞ¹«Ë¾ ×ªÔØÇë×¢Ã÷À´ÓÉ
ÍøÕ¾µØÍ¼