打开App
360P
[王佩丰]Excel 2010系列视频教程：第5讲分类汇总、数据有效性
[王佩丰]Excel 2010系列视频教程：第5讲分类汇总、数据有效性
[王佩丰]Excel 2010系列视频教程 全集5/23
![[王佩丰]Excel 2010系列视频教程：第1讲认识excel](http://p3-sign.bdxiguaimg.com/tos-cn-p-0026/454d424d7af18c86729074f006bd6d06~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=EKpkMWh%2Bm4t%2BiCmTHQ8O2rOgB%2Fs%3D)
App71:04![[王佩丰]Excel 2010系列视频教程：第2讲excel单元格格式设置](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/1245c0a4aa3f465097fe55045b117524~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=A7xOXHptG06xxemZJpkbz0kCIRo%3D)
App74:42![[王佩丰]Excel 2010系列视频教程：第3讲查找替换定位](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/8c746023f2084d1d8a40034eca69efaf~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=%2FFA%2Bp0hPXQF19S%2Bvyee4Qje%2B9EU%3D)
App78:21![[王佩丰]Excel 2010系列视频教程：第4讲排序与筛选](http://p26-sign.bdxiguaimg.com/tos-cn-p-0000/79dbab86acd645ffb8599e3844bcc26e~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=eaNGAd4mEhLduFCF17H9ofZwUPM%3D)
App70:28![[王佩丰]Excel 2010系列视频教程：第5讲分类汇总、数据有效性](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/505837550d754451ae991066eba298e0~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=p4OS5ktj9dIYX0DLzRE36JBM4IA%3D)
App64:42![[王佩丰]Excel 2010系列视频教程：第6讲认识数据透视表](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/07a29456da5b48dab6510b43f1d8b5a3~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=i9f0rIUo%2BNURpJnQ9k8jb4xQ%2F98%3D)
App70:41![[王佩丰]Excel 2010系列视频教程：第7讲认识函数与公式](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/f3d683a529364ea19ed7b1f66cd27d91~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=evkc22NxkmMt5aB%2BvufipDnyw9c%3D)
App67:16![[王佩丰]Excel 2010系列视频教程：第9讲COUNTIF函数](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/01566a3386184f89bfe73c2af42e04a0~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=eA1dLtZsahQ9pZU5lm0m%2FcjG%2Bks%3D)
App64:56![[王佩丰]Excel 2010系列视频教程：第10讲SUMIF函数](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/960c148fa1064c83b89ade1adb249133~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=9CUZ9XRmHwOPI7%2BizPQ2iJ8r99U%3D)
App53:41![[王佩丰]Excel 2010系列视频教程：第11讲Vlookup](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/713b31ac4a104789b17f8db1b65fdcf3~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=iS3teYCnNjtnh%2FoJNa0Ocp0C7UI%3D)
App74:22![[王佩丰]Excel 2010系列视频教程：第12讲match+index](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/c6dc6ad4fa894f5497f599efe4098d1d~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=I1qOJjtSss7BvEGXsRGUZW%2BsdYA%3D)
App71:21![[王佩丰]Excel 2010系列视频教程：第13讲邮件合并](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/2ade6bb99eca4084acc3c9591a7667f1~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=jjiwAejo%2B3qam318nfrLZ6YIDgI%3D)
App41:03![[王佩丰]Excel 2010系列视频教程：第14讲日期函数](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/9d725458c7fd46d59d63394c56cdc030~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=eQeOip65TZyYIrk%2Fck%2FdLzrX5IA%3D)
App71:54![[王佩丰]Excel 2010系列视频教程：第15讲条件格式与公式](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/cf4c7a0d47d947dba1d25f71f4ffdd99~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=WN%2B0AqWxt4kQHjaQm0MQZci3pSs%3D)
App89:58![[王佩丰]Excel 2010系列视频教程：第16讲简单文本函数](http://p26-sign.bdxiguaimg.com/tos-cn-p-0000/f4f4a0e886a943afb590a11aa1bda066~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=JUxP%2ByQwNJ8TShYc18ZiUBpLkdY%3D)
App88:13![[王佩丰]Excel 2010系列视频教程：第18讲LOOKUP和数组](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/64426dcdbe834dc2b9f8272514bdb38f~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=YyPt5csi9EPAPemuheOrgGmWBf4%3D)
App82:00![[王佩丰]Excel 2010系列视频教程：第17讲数学函数](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/8972139d3cba4670b78bb7cde9398063~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=myufLkNeMkfa6ELLG8XsfTrpPho%3D)
App81:00![[王佩丰]Excel 2010系列视频教程：第19讲indirect函数](http://p26-sign.bdxiguaimg.com/tos-cn-p-0000/91980d509cce4ff39eff258005c6d8b1~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=uL4X3PWFMBAQuIUH98ULBgkfI5c%3D)
App71:30![[王佩丰]Excel 2010系列视频教程：第20讲图表基础](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/f9064679800b4c829ec97652d3ea20b2~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=YHvvd7F0UanQC2PtpzjJagjPcUE%3D)
App98:40![[王佩丰]Excel 2010系列视频教程：第21讲动态图表](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/5672cd8b40f349eaa42fd73399afe485~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=QRdqUQux%2FhRm3qnbrXwrUHSPOrk%3D)
App103:56![[王佩丰]Excel 2010系列视频教程：第22讲甘特图与动态甘特图](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/feb86aedb86d4b7398e909f5be47098b~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=6lRWaqcTdkY%2FAbkhnHDXU399Mwc%3D)
App83:39![[王佩丰]Excel 2010系列视频教程：第23讲Excel图表与PPT](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/d1f9ac91ca8742659354c535f07bd1f7~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=wXm4iCRmDploiZcMGnQ1vApAIOM%3D)
App73:21![[王佩丰]Excel 2010系列视频教程：第24讲宏表函数](http://p3-sign.bdxiguaimg.com/tos-cn-p-0000/0fc4e17dd4ea42efb6a9599c90d42288~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=2025020114443269085E3D257FB5412885&requestFrom=704&version_code=80402&x-expires=1769928273&x-signature=8i173XhIbPlM0fMCfukNuq8rWcM%3D)
App79:22
