打开App
[王佩丰]Excel 2010系列视频教程：第12讲match+index
[王佩丰]Excel 2010系列视频教程：第12讲match+index
[王佩丰]Excel 2010系列视频教程 全集11/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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=ezbqzf8cRL1g%2BZGo1Yd9A71ca8I%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=IzNHSCPuX%2BO%2BQuHpPN1dpS3s1as%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=0tyRXsHsoP4kv6ksrGA6eft3%2BkA%3D)
App78:21![[王佩丰]Excel 2010系列视频教程：第4讲排序与筛选](http://p3-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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=Iu2A7%2BqFIi%2BSjUo3JbSP3rmgfeQ%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=K1GWPD1r83zluWEYg7bVF9fWmHA%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=h5DxrxIlV%2BY%2BRQKCsxKS%2FkCwawQ%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=1VfA1urogCuJ%2FE7dyoxKsruOOhY%3D)
App67:16![[王佩丰]Excel 2010系列视频教程：第9讲COUNTIF函数](http://p26-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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=N%2FtRYeS5mhr3Bq%2Fyjsw%2F3isS7Xc%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=CYD2acBBv2L7lkrljPVIS2WfO80%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=Gl3Kkc4Si6tVvUGHo0ofzLsUQWw%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=JJeAss55jVZrezC6xVuxUnCujK4%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=mYFwsTXn%2BHaGRclyTCebkmyj%2B8s%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=O5cgGK80T7FkGlNHpSY4O2fVevg%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=mSEtlmceyPfjiMfctSJrXVUlM0I%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=wX%2FdlWRQ7W1g0JIixWXeQk3LmSE%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=V%2FtswcL28zQt43%2B%2BzRl7L8QiI4M%3D)
App82:00![[王佩丰]Excel 2010系列视频教程：第17讲数学函数](http://p26-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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=qpKT1OSy%2Be%2F5LxO%2B95lB%2BoBOHEQ%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=ksExX7OdsGdK7xJa7GmFLVLX40g%3D)
App71:30![[王佩丰]Excel 2010系列视频教程：第20讲图表基础](http://p26-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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=R6ktYgqjmO%2FJnEOmX%2Fn4mFiKS7U%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=tZ6k7aOOn1Q%2F%2BYF5wM7AA5iPT6I%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=O3U8RR%2FQBtzqC87c4ftsXwQUHvI%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=Tyzmb0X%2FFHSPY9ihjY4nA6KVIk4%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=202502011443519E968A11ED56026DFBE9&requestFrom=704&version_code=80402&x-expires=1769928231&x-signature=MWyCKs28zbg3f909rLO7M2c8IXU%3D)
App79:22
