打开App
[王佩丰]Excel 2010系列视频教程：第4讲排序与筛选
[王佩丰]Excel 2010系列视频教程：第4讲排序与筛选
[王佩丰]Excel 2010系列视频教程 全集4/23
![[王佩丰]Excel 2010系列视频教程：第1讲认识excel](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=yroMCyv8EHBbsF7%2BFyZIpb1Q9mk%3D)
App71:04![[王佩丰]Excel 2010系列视频教程：第2讲excel单元格格式设置](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=Nhfi8COUV5lV4jlPMuzF6Zi8BNo%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=UBLpILkZXyLlCqHBUFi4fnW9vmo%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=D%2FxCdYDpwHLuY%2F8daOs%2FyOiKAFQ%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=Tgk7R044sejuIDDqbytEcdS5U7s%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=RmWWPIIdytgAKJ1W%2FB3OCjuCZMk%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=KCtR5n0OmT6LsV%2BmlLhqoI%2F6Dzo%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=GsNPQyjLGmaaN%2FT1KWFlLiskHkQ%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=HSFO7nfodHx7t20RKiQJmTmZOhw%3D)
App53:41![[王佩丰]Excel 2010系列视频教程：第11讲Vlookup](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=HzOqx%2F95HIpI4GgUhqF09KS4ejk%3D)
App74:22![[王佩丰]Excel 2010系列视频教程：第12讲match+index](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=VGPjq0TlS8DnZJy6%2BOUfmqjn1p4%3D)
App71:21![[王佩丰]Excel 2010系列视频教程：第13讲邮件合并](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=%2FKCvbwWsBgbU0UrVkG8kBNXn1r4%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=sKtE8QcgTM4aBChHUE51AcP2o04%3D)
App71:54![[王佩丰]Excel 2010系列视频教程：第15讲条件格式与公式](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=ZPG1j491%2F2EQ9oOy7cp6XuRatmo%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=cbA1lyCIBZlsNxywgntxzpZybds%3D)
App88:13![[王佩丰]Excel 2010系列视频教程：第18讲LOOKUP和数组](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=i8aTnH1nYsVDBtvErSVZ9ei3rf0%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=9b72tKD6Aa5pk2bB44xSTZQZQjk%3D)
App81:00![[王佩丰]Excel 2010系列视频教程：第19讲indirect函数](http://p3-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=dCmTXleaKjbRmS8bCgGzYi8ya54%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=36dB1mCayBMcRQF%2FR0jxTwMuHTQ%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=%2FsOP3lejyVR0%2F4aBNJ9itWm3GhQ%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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=AK2nSL1W8WyITVDfTflM%2BE79PKY%3D)
App83:39![[王佩丰]Excel 2010系列视频教程：第23讲Excel图表与PPT](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=BzKOURXWqZStt3joEOlcCa74t00%3D)
App73:21![[王佩丰]Excel 2010系列视频教程：第24讲宏表函数](http://p26-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=20250208105314777C7D804CAD752EFAC9&requestFrom=704&version_code=80402&x-expires=1770519194&x-signature=rZX3kVc2Hr1ZlKVcGVybcPAxX5A%3D)
App79:22
