打开App
360P
[王佩丰]Excel 2010系列视频教程：第16讲简单文本函数
[王佩丰]Excel 2010系列视频教程：第16讲简单文本函数
[王佩丰]Excel 2010系列视频教程 全集15/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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=zY8Cr7l%2B7%2FNcUfOjMjjXPIBzApM%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=MHBWoRsipzM4G6nf%2FM2ZuDUI92k%3D)
App74:42![[王佩丰]Excel 2010系列视频教程：第3讲查找替换定位](http://p26-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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=0zL5l7tEUD2QNCxkIbcYestdxzg%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=NrDWyxJC5Nj9QtXwaq7KDLF8%2FvI%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=uh8Bf683nS%2FqBDrbC%2FB42UyEkzI%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=CRq%2FjDnOKuQ6zKBBCute6CEamdU%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=xwUl9ea2hnfuKlkcJLbPCQnEbJQ%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=yu4K%2FJYlrK7pUcSVf1Ga8OVBMoo%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=iXAwFJ%2BJ17707uedUZ1tRgbamDw%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=yeP6he4okJqJapvTwXfAEmJaWhw%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=UMFUpnPdo9V3RF6t8x2dVFlUNgw%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=xPG6MJ9bchZWev7FhyZn%2FRoe5vk%3D)
App41:03![[王佩丰]Excel 2010系列视频教程：第14讲日期函数](http://p26-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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=Hj%2BxqkZKtqYmSlSB0gEbAnOMLrI%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=kDYS9XKPzKgPehO2ATAyooDqxu4%3D)
App89:58![[王佩丰]Excel 2010系列视频教程：第16讲简单文本函数](http://p3-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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=%2Fj9c%2BjQcFbZVilUw0HDzokOhiV4%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=P2kplnBYuUivGfq1IOsxxZfpxKk%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=uDadPsA64S7LTQmWp1khkDfiR6Y%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=0LgV2OifAq2KKeGeMWfJnhfX3rk%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=7VyKF9zqt8CR00rlpnvkdEtH7wM%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=%2BV9Cn6nI%2FqZxQABoGSULJD%2BtOY0%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=jxkMhGVXm3oGxl8q%2FNJpvpWWmjY%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=daa9cCjhDW6%2FWpu7chzAq5ihM48%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=20250201144207E39ADA3EEF4B429B4E27&requestFrom=704&version_code=80402&x-expires=1769928127&x-signature=GU%2FwyYyEetnYrONYQ7GWJ%2BFONtE%3D)
App79:22
