2024.6.30~2025.3Office学习视频汇总（抖音目录）

更新日期：2025-4-2

 

学习不停，分享不止。

我一直在做的一件事就是在线答疑，并将其中有代表性的问题制作成视频发布在抖音（抖音号：1175420452）和微信视频号（视频号ID：sphuXyqOUFhiMfw）上，这件事未来还将继续。

截止2025年3月31日，我一共发布了视频198个，浏览19万+。

这每一个视频，我都认真制作。

首先，就视频制作本身来讲，我尽可能做到整体的流畅，避免较大的误操作和口误。

其次，我将每一个提问人的个人信息，以及他们所提供的数据虚化，以免给他人带来困扰。

第三，也就是最重要的，就是视频内容本身。视频太多了，以下是从2024年6月30日开始的全部视频及抖音链接（从2024年4月1日至2024年6月29日之间的视频链接因当时未及时记录而无法提供）。

Learning never stops, and sharing never ends.
One thing I’ve consistently done is provide online Q&A, turning representative questions into tutorial videos published on Douyin (ID: 1175420452) and WeChat Video Channel (ID: sphuXyqOUFhiMfw). This is something I’ll continue doing in the future.

As of March 31, 2025, I’ve released 198 videos with over 190,000 views. Each video is crafted with care.

First, in terms of production, I strive for smooth delivery, minimizing major errors or verbal slip-ups.
Second, I anonymize personal information and data provided by questioners to avoid causing any inconvenience.
Third, and most importantly, is the content itself. With so many videos, below is a complete list of all videos starting from June 30, 2024, along with their Douyin links. (Video links from April 1, 2024, to June 29, 2024, are unavailable as they were not recorded in time.)

 

2024-6-30     表格结构转换（Filter+ToRow） https://v.douyin.com/iMmgnJBM/

2024-6-30     筛选图表       https://v.douyin.com/iMmgsEDD/

2024-7-7       按指定日期重复-传统套路  https://www.douyin.com/video/7390719943710395648

2024-7-7       按指定日期重复-动态数组  https://www.douyin.com/video/7391109931971267874

2024-7-7       Sumif的问题 https://www.douyin.com/video/7390347510104984832

2024-7-7       又是If的问题       https://www.douyin.com/video/7389976408161881379

2024-7-13     查找的问题    https://www.douyin.com/video/7393317566862609704

2024-7-13     重复的第二行前插入一行    https://www.douyin.com/video/7392945042165435682

2024-7-13     重复的第二行前插入一行    https://www.douyin.com/video/7392574211140734248

2024-7-13     按指定日期重复-PQ    https://www.douyin.com/video/7391461000798637352

2024-7-13     按条件不重复计数-PQ https://www.douyin.com/video/7391831577937874191

2024-7-13     计算工作日    https://www.douyin.com/video/7393686290094492962

2024-7-13     又是迪卡尔乘积    https://www.douyin.com/video/7394058416332836096

2024-7-13     总表拆分       https://v.douyin.com/iMfNyd23/

2024-7-13     总表拆分       https://v.douyin.com/iMfNPAYR/

2024-7-20     统计超龄人数       https://v.douyin.com/iM5SD7Pf/

2024-7-20     分品种汇总    https://v.douyin.com/iMmpLuon/

2024-7-27     整理PDF数据-PQ       https://v.douyin.com/iMq4G79W/

2024-7-27     整理考勤数据-PQ https://v.douyin.com/iMpdAVDq/

2024-7-27     整理考勤数据-函数     https://v.douyin.com/iMTuF3m2/

2024-8-3       好像是快递费的计算-函数  https://v.douyin.com/irMf58yC/

2024-8-3       好像是快递费的计算-PQ    https://v.douyin.com/irMPJYEk/

2024-8-3       PQ里也有浮点问题     https://v.douyin.com/irMPLadp/

2024-8-3       多PDF合并   https://v.douyin.com/irMPMYGt/

2024-8-3       工资条结构转为一维表-M版     https://v.douyin.com/irMPjL4p/

2024-8-3       工资条结构转为一维表-无M版 https://v.douyin.com/irkJ5o8R/

2024-8-10     多条件非重复计数-函数     https://v.douyin.com/irxETDeP/

2024-8-10     Cube系列函数     https://v.douyin.com/irxEc5ED/

2024-8-10     LookupYYDS https://v.douyin.com/irxEWY8g/

2024-8-10     又是快递费    https://v.douyin.com/irK3t8kT/

2024-8-17     统一数字位数       https://v.douyin.com/irK3TL6Q/

2024-8-17     统一数字位数       https://v.douyin.com/irK3WC1v/

2024-8-17     统一数字位数       https://v.douyin.com/irK3GREW/

2024-8-17     指定条件下的店铺数量       https://v.douyin.com/irK3g9Gc/

2024-8-17     指定条件下的店铺数量       https://v.douyin.com/ihDocyHt/

2024-8-24     Word表格的垂直对齐 https://v.douyin.com/ihU1LLeB/

2024-8-24     按条件计算余额    https://v.douyin.com/ihU1jfne/

2024-8-24     会计科目的问题    https://v.douyin.com/ihU1oNQf/

2024-8-24     会计科目的问题    https://v.douyin.com/ihG3VJ9S/

2024-8-24     按指定符号拆分多列    https://v.douyin.com/ihG3uYgC/

2024-8-31     邮件合并后总是会变形的日期    https://v.douyin.com/ihG3PpPF/

2024-8-31     税前税后与个税的计算       https://v.douyin.com/ihG3DH6Y/

2024-9-7       每月天数       https://v.douyin.com/ik2R6dGS/

2024-9-7       每月天数       https://v.douyin.com/ik2RST4f/

2024-9-7       判断合格与不合格       https://v.douyin.com/ik2RyTNm/

2024-9-7       无序内容填入对应列    https://v.douyin.com/ik2dowtn/

2024-9-7       无序内容填入对应列    https://v.douyin.com/ikQLcD9u/

2024-9-7       计算时长       https://v.douyin.com/ikQLXT2x/

2024-9-7       排名与比较    https://v.douyin.com/ikQNNboa/

2024-9-14     延时退休       https://v.douyin.com/ikQLT8Fq/

2024-9-14     油腻V的第三参数错误       https://v.douyin.com/ikEYQhxq/

2024-9-21     每51行指定数字出现次数  https://v.douyin.com/ikEYkqLp/

2024-9-21     提取工作表名       https://v.douyin.com/ikEYgHP7/

2024-9-21     提取工作表名       https://v.douyin.com/ikE2R8KY/

2024-9-21     PQ中的动态标题行     https://v.douyin.com/ikE21hyo/

2024-9-28     造成动态数组溢出错误的原因    https://v.douyin.com/iBAm9fND/

2024-9-28     数据透视表中文本型数字强制求和    https://v.douyin.com/iBAmUM5j/

2024-9-28     背锅的Sumifs       https://v.douyin.com/iBAmjCEt/

2024-9-28     账龄回款冲减       https://v.douyin.com/iBAmr3ES/

2024-10-5     计算区间对应值    https://v.douyin.com/iBsJVQYb/

2024-10-5     高亮显示计划大于已检加可检    https://v.douyin.com/iBsJhhco/

2024-10-12    Sumif的条件重叠 https://v.douyin.com/iSNngmWa/

2024-10-12    用数据的连续性作为判断依据    https://v.douyin.com/iSNt7DPf/

2024-10-12    PQ中的筛选与反向筛选     https://v.douyin.com/iSNnhRfF/

2024-10-12    带条件的不重复计数    https://v.douyin.com/iSNtvop3/

2024-10-19    翻着花样的查找    https://v.douyin.com/iSuTY5Fs/

2024-10-19    提取字符串    https://v.douyin.com/iSuT18eC/

2024-10-19    提取字符串    https://v.douyin.com/iSuTNVFC/

2024-10-19    查找对应列的最大值    https://v.douyin.com/iSu3s7Ay/

2024-10-19    排名人数统计       https://v.douyin.com/iSTxBESt/

2024-10-26    表格结构转换       https://v.douyin.com/iSTxyAoG/

2024-10-26    表格结构转换       https://v.douyin.com/iST9WsdK/

2024-10-26    一个工作表里会有两套数据       https://v.douyin.com/iST9EWXJ/

2024-10-26    转换表格结构       https://v.douyin.com/iST9owBv/

2024-10-26    转换表格结构       https://v.douyin.com/iABpxbr3/

2024-10-27    工作表的自动显示与隐藏VBA   https://v.douyin.com/iABpUg5K/

2024-10-27    指定数的位置       https://v.douyin.com/iABp8gGs/

2024-10-27    指定数的位置       https://v.douyin.com/iABpRa5e/

2024-11-2     修剪平均值    https://v.douyin.com/iApvqK7N/

2024-11-2     成绩前40%人数统计     https://v.douyin.com/iApvPVXp/

2024-11-2     一对多查找结果横向显示    https://v.douyin.com/iApvVrTr/

2024-11-2     改变状态显示       https://v.douyin.com/iApv6Q6t/

2024-11-9     计算运费       https://v.douyin.com/iDFHGkK6/

2024-11-9     动态数据源路径    https://v.douyin.com/iDFHnyFP/

2024-11-9     动态筛选时间       https://v.douyin.com/iDFHX8Fq/

2024-11-16    日期的三个问题    https://v.douyin.com/iDFHsL7L/

2024-11-23    重复的自定义列    https://v.douyin.com/iDu9S8Ct/

2024-11-23    待合并的每月数据       https://v.douyin.com/iDu9SUYW/

2024-11-23    多行多列中的唯一值    https://v.douyin.com/iDu9FUd5/

2024-11-23    向下小计       https://v.douyin.com/iDu95mEA/

2024-11-30    两表比对-Vlookup和CountifSumif   https://v.douyin.com/iUM2ow3v/

2024-11-30    中文数字排序       https://v.douyin.com/iUMjBat5/

2024-11-30    根据号箱添加有序编号       https://v.douyin.com/iUM2CWQJ/

2024-12-14    为指定列自适应数据类型    https://v.douyin.com/iUCFv92P/

2024-12-14    展开后指定列不重复    https://v.douyin.com/iUCFEGc8/

2024-12-14    距指定年龄还有多少个月    https://v.douyin.com/iUCYRnqe/

2024-12-21    PQ里的模糊查找  https://v.douyin.com/iUEqJ5Gm/

2024-12-21    文本按数值规则排序    https://v.douyin.com/iUEqR4hq/

2024-12-21    八位数的日期和时间合并    https://v.douyin.com/iUEVtKnt/

2024-12-21    查找同一凭证号的贷方科目       https://v.douyin.com/iUEq83nj/

2024-12-21    PQ中的昨天  https://v.douyin.com/iUEVgECr/

2024-12-21    三张表Vlookup式合并       https://v.douyin.com/iyAuJTcg/

2024-12-28    提取字母及数字    https://v.douyin.com/iyAm7GcC/

2024-12-28    按层级的匹配       https://v.douyin.com/iyAudo4S/

2024-12-28    按层级的匹配       https://v.douyin.com/iyAmtHTk/

2024-12-28    又是万恶的合并单元格       https://v.douyin.com/iysS55Qg/

2025-1-4       提取用冒号分隔的字符串    https://v.douyin.com/iysSHaFp/

2025-1-4       提取用冒号分隔的字符串    https://v.douyin.com/iysSfkLb/

2025-1-4       蛇形排座位    https://v.douyin.com/iysB79Tt/

2025-1-4       两两组合       https://v.douyin.com/ifNwJTvJ/

2025-1-11     最大值对应的内容       https://v.douyin.com/ifNwRonP/

2025-1-18     下拉公式改造成数组公式    https://v.douyin.com/ifmCbHWT/

2025-1-18     为什么会找不到    https://v.douyin.com/ifmCs6ow/

2025-1-18     作乱的样式    https://v.douyin.com/ifmCu8Ap/

2025-1-18     查找的问题    https://v.douyin.com/ifnDYvBQ/

2025-1-25     图表中的动态系列       https://v.douyin.com/ifnD9Fqr/

2025-1-25     只带部分分隔符的合并       https://v.douyin.com/iPCQNh7e/

2025-2-1       每月指定第n周第k日的具体日期    https://v.douyin.com/iPCQ64Y1/

2025-2-15     日期格式的转换    https://v.douyin.com/iPCQRCau/

2025-2-15     1+N式的合并查询       https://v.douyin.com/iPwkePjg/

2025-2-15     判断新增流失与留存    https://v.douyin.com/iPwhokja/

2025-2-15     伪分数转小数       https://v.douyin.com/iPwh7b1E/

2025-2-22     用函数公式删除空行    https://v.douyin.com/i5k7gdHo/

2025-2-22     非连续区域的排名       https://v.douyin.com/i5k7XEMA/

2025-2-22     户主这一家子的人数    https://v.douyin.com/M7uFI3xoqkE/

2025-3-1       又是查找       https://v.douyin.com/i5psC1X3/

2025-3-1       同编号的最后一行       https://v.douyin.com/iD9nRGKDoT4/

2025-3-1       数值不等于文本型数字       https://v.douyin.com/i5ppwnpM/

2025-3-15     设置整列的条件格式    https://v.douyin.com/i5nBgYHF/

2025-3-15     条件统计非假空    https://v.douyin.com/i5WBfLof/

2025-3-15     当带条件计不重遇到空       https://v.douyin.com/i5vX8RBs/

2025-3-15     取开始和结束两个值    https://v.douyin.com/i5cxb1nE/

2025-3-22     合并结果横向排列       https://v.douyin.com/ao-d9ZhA-4M/

2025-3-22     合并结果横向排列       https://v.douyin.com/Fu-npcD6JRA/

2025-3-22     找出为否的    https://v.douyin.com/Vd0r_WuPoSE/