{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0607\/i109\/1102937476_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0607\/i109\/1102937476_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0607\/i109\/1102937476_3.jpg"}],"Brie":"别再用IF函数了，好土，教你几个简单好用的新函数与 30万 粉丝一起学Excel.这是从VIP群挑选的4个问题，全部都可以用IF函数...","SN":"9","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0501\/i109\/1102859689_1.jpg"}],"Brie":"用M函数求文本中所有数字的和。这里小窝再为大家介绍两种分别运用工作表函数和PQ的M函数对文本中的数字进行求和的方法。今...","SN":"5","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0406\/i109\/1102776667_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0406\/i109\/1102776667_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0406\/i109\/1102776667_3.jpg"}],"Brie":"当前Excel的着色地图（二维地图）和三位地图不可用，怎么在Excel中创建根据数字的大小自动着色的地图呢？选择数据，单击“...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0303\/i109\/1102644581_1.jpg"}],"Brie":"如何从成千上万数据中快速筛选出所有错误值？数据少，一眼就能看到数据中的函数错误值，如#NAME?、#N\/A、#VALUE!等错误。如...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0307\/i109\/1102598724_1.jpg"}],"Brie":"学会这个无敌的函数套路，90%的Excel查找问题都能轻松解决！=LOOKUP(1,0\/(C2:I2<=0),C1:I1)语法：=LOOKUP(1,0\/(查找区域=查...","SN":"27","RN":"0","istop":"0"}

{"imgList":[],"Brie":"ps快速校正构图技巧-自由变换图面左右拉伸拆分变形","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0207\/i109\/1102479036_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0207\/i109\/1102479036_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0207\/i109\/1102479036_3.jpg"}],"Brie":"Excel筛选太low了，试试切片器吧。普通的筛选，需要勾选内容，确定，换个内容，又得取消勾选，再勾选新的内容，确定，操作...","SN":"9","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/11\/0107\/i109\/1102359633_1.jpg"}],"Brie":"密密麻麻的折线图看了头晕，不如换成清爽的Excel迷你图。VIP学员的问题，左边是7~10月4个月的数据，直接创建折线图是1条折...","SN":"8","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3109\/i109\/1102326452_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3109\/i109\/1102326452_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3109\/i109\/1102326452_3.jpg"}],"Brie":"如何保护工作表中的公式不被误删修改？Step 02 不取消选择，按F5或者Ctrl+G，设置定位条件为公式，然后确定即可选中公式所...","SN":"5","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3107\/i109\/1102240730_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3107\/i109\/1102240730_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3107\/i109\/1102240730_3.jpg"}],"Brie":"看了这个表格3遍，终于知道会计老加班的真相。房号，FIND是判断字符的位置，MID是从中间提取字符。固定套路：=MID(A2,FIND(...","SN":"13","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/3010\/i109\/1102214734_1.jpg"}],"Brie":"求没有等号开头的计算式的值。Excel中用等号开头的计算式会自动计算出结果，但没有等号开头的算式就是文本，Excel不会自动...","SN":"4","RN":"0","istop":"0"}

{"imgList":[],"Brie":"今天给大家介绍两种“圆角条形进度完成率”图表的做法。","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"妙用Excel自定义视图，取代重复性筛选工作。在完成需要签长期合同的筛选工作后，单击“视图—自定义视图”，然后添加一个名...","SN":"6","RN":"0","istop":"0"}

{"imgList":[],"Brie":"简单的Excel图标集，居然难倒50%的人。刚好读者提到三向箭头，卢子就来聊条件格式→图标集。默认情况下，类型为百分比，绿...","SN":"8","RN":"0","istop":"0"}

{"imgList":[],"Brie":"excel全年数据汇总-多季度报表合并计算","SN":"4","RN":"0","istop":"0"}

{"imgList":[],"Brie":"怎样把Excel数字变为以万为单位？给老板汇报工作，我们经常需要把数字变为以万为单位，怎样不用公式把Excel数字变为以万为...","SN":"10","RN":"0","istop":"0"}

{"imgList":[],"Brie":"Excel分列的大绝技和小绝技。但它还有两个大小绝技，混乱日期的处理和文本转数字。今天介绍分列的两个大小绝技：混乱日期规...","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"TEXTJOIN函数太强了，轻松解决合并、查找2大Excel难题。于是套上TEXT将数字转变成日期，新的问题又来了，空单元格显示1900\/...","SN":"8","RN":"0","istop":"0"}

{"imgList":[],"Brie":"FILTERXML函数的高阶技巧，建议收藏以备不时之需。新版函数出现后，有了针对性的函数，这类题目变得简单了。PHONETIC($A$2:...","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"领导让我做个统计分析表，半天都想不出，同事3分钟就解决！VIP学员的问题，数据源就只有三列内容，领导要统计分析星期几、...","SN":"9","RN":"0","istop":"0"}

{"imgList":[],"Brie":"VLOOKUP、LOOKUP都解决不了的难题，居然被这个函数轻松解决。其实，还有一个函数，专门解决按行查找，就是HLOOKUP。估计很...","SN":"8","RN":"0","istop":"0"}

{"imgList":[],"Brie":"Excel中的常见对象包括图片、形状、图形（图标）、文本框、图表、3D模型、SmartArt图形等，根据是否受列宽影响又分为受列宽...","SN":"6","RN":"0","istop":"0"}

{"imgList":[],"Brie":"今天来教大家一组简单实用的DSUM函数的用法","SN":"16","RN":"0","istop":"0"}

{"imgList":[],"Brie":"# 打开图片image，并裁剪出左上角为(0,0)，右下角为 (100, 100) 的矩形区域image = cv2.imread(\"image.jpg\")rect = (0, 0, ...","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"修改数据后数据透视表自动刷新的方法。自动用了一句数据透视表自动刷新代码，不管透视表与数据源是否在同一张工作表中都适...","SN":"11","RN":"0","istop":"0"}

{"imgList":[],"Brie":"挺简单的，点几下鼠标就行。很长很长的表格，怎么打印在一页纸上？VIP学员的问题，实际表格有3000多行，只有4列，怎么打印...","SN":"41","RN":"0","istop":"0"}

{"imgList":[],"Brie":"3大微信中不为人知的技能，你非常需要却不知道。微信如何发送大文件：高清视频与图片。你知道怎么使用微信发送不被压缩的图...","SN":"7","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2204\/i109\/1101234427_1.jpg"}],"Brie":"Excel自动做天气预报，给外出的同学一个建议！Excel自动做天气预报？勾选“选择多项”，勾选Table1-Table7的表，再点击转换...","SN":"7","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2207\/i109\/1101247790_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2207\/i109\/1101247790_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2207\/i109\/1101247790_3.jpg"}],"Brie":"你可以找到职业资格考试、公务员企事业单位考试、公安政法考试、医药卫生资格、建筑工程消安考试、特种作业安全生产等职技...","SN":"12","RN":"0","istop":"0"}

{"imgList":[],"Brie":"那些深入骨髓的数据透视表技能！有些技能不管在任何时候都能倒背如流，希望你也拥有这种能力。今天就分享卢子最喜欢的技能...","SN":"16","RN":"0","istop":"0"}

{"imgList":[],"Brie":"在LEFT函数外嵌套第一个IFERROR函数，=IFERROR(LEFT(B2,FIND(\"小学\",B2)-1),LEFT(B2,FIND(\"附小\",B2)-1))。接下来，再为后...","SN":"5","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2002\/i109\/1101001035_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2002\/i109\/1101001035_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2002\/i109\/1101001035_3.jpg"}],"Brie":"案例1： 依据卡号区间生成连续的卡号序列STEP 01 拆分列将数据导入【查询编辑器】，然后选择【卡号区间】字段，单击功能区...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2007\/i109\/1100857908_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2007\/i109\/1100857908_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/2007\/i109\/1100857908_3.jpg"}],"Brie":"LOOKUP函数的一个冷门用法，可以帮财务会计节省大量时间。=LOOKUP(1,0\/((条件区域1=条件1)*(条件区域2=条件2)),返回区域)SE...","SN":"8","RN":"0","istop":"0"}

{"imgList":[],"Brie":"ps眯眼照片修图-镜像复制眼睛内容感知移动眼珠修图技巧","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1907\/i109\/1100732302_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1907\/i109\/1100732302_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1907\/i109\/1100732302_3.jpg"}],"Brie":"一直以为自己擅长Excel，直到遇见这些神奇的公式！隔行填充色，还可以借助条件公式里面设置公式实现。=MOD(ROW(A1),2)选择...","SN":"9","RN":"0","istop":"0"}

{"imgList":[],"Brie":"ps美女精确抠图-一键删除背景调整边缘长发修图技巧","SN":"5","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1807\/i109\/1100605548_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1807\/i109\/1100605548_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1807\/i109\/1100605548_3.jpg"}],"Brie":"编写固定资产编码，同事累到手抽筋，我2分钟就搞定！编码规则：SH（2位）+类别码（2位）+部门(4位编号)+顺序码(流水码4位)...","SN":"12","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1606\/i109\/1100427884_1.jpg"}],"Brie":"Excel生成随机时间详解。在Excel中生成随机日期和时间可以运用随机函数搭配日期格式进行。在Excel中时间实际是小数，日期实...","SN":"23","RN":"0","istop":"0"}

{"imgList":[],"Brie":"今天来教大家，如何将一段长文字转化成漂亮的Excel表","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1508\/i109\/1100321899_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1508\/i109\/1100321899_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1508\/i109\/1100321899_3.jpg"}],"Brie":"3.对于已存在货物移动的工单，如果是修改评估类的物料是工单中的组件，则建议将已发料数262退回，并将工单设为删除状态，对...","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"没关系，INDEX函数也简单！在单元格G3中输入公式“=IF(AND(ROW()=4,OR(COLUMN()={13,14,15})),\"\",INDEX($B$3:$D$10,MATCH($...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1607\/i109\/1100359489_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1607\/i109\/1100359489_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1607\/i109\/1100359489_3.jpg"}],"Brie":"你会统计现金日记账的余额吗？在E172单元格输入公式，下拉。出现这种错误，是单元格存在空格等文本，这里的空格不是指空单...","SN":"11","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1507\/i109\/1100243644_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1507\/i109\/1100243644_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1507\/i109\/1100243644_3.jpg"}],"Brie":"这几个新函数，用了都说好，太方便了与 30万 粉丝一起学Excel今天卢子看到几个很有用的新函数，用起来超级方便。将内容按关...","SN":"14","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1406\/i109\/1100195017_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1406\/i109\/1100195017_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1406\/i109\/1100195017_3.jpg"}],"Brie":"教你如何精准清理、备份、恢复！在手机微信的【聊天】界面中，点击“聊天记录迁移与备份”进入界面，你可以在清理的时候，...","SN":"14","RN":"0","istop":"0"}

{"imgList":[],"Brie":"ps美女墨镜效果-钢笔路径节点调整抠图眼镜变色方法","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1307\/i109\/1100004764_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1307\/i109\/1100004764_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1307\/i109\/1100004764_3.jpg"}],"Brie":"这才是LOOKUP函数最高级的用法，99%的人还不会用！对金额进行分类，只需将区间的对应表列出来，就可以直接LOOKUP。=LOOKUP(...","SN":"10","RN":"0","istop":"0"}

{"imgList":[],"Brie":"excel跨天时长计算-判断夜班下班时间跨度统计","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1208\/i109\/1099878896_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1208\/i109\/1099878896_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1208\/i109\/1099878896_3.jpg"}],"Brie":"2. 更改查询的数据源路径打开保存的10-11-2.xlsx文件，单击“数据—查询和连接”，可以看到查询&连接框中“原始数据”前出...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1207\/i109\/1099874533_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1207\/i109\/1099874533_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1207\/i109\/1099874533_3.jpg"}],"Brie":"银行流水转表格，测试了无数软件，这是识别率最高的方法。银行流水转表格，测试了无数软件，这是识别率最高的方法那就来试...","SN":"5","RN":"0","istop":"0"}

{"imgList":[],"Brie":"ps照片水印去除-差值法混合模式边缘修图","SN":"5","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1001\/i109\/1099668501_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1001\/i109\/1099668501_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1001\/i109\/1099668501_3.jpg"}],"Brie":"喷墨打印机第一种类型的打印机是喷墨打印机。激光打印机第二种类型的打印机是激光打印机。LED\/LCD打印机下一种类型的打印机...","SN":"4","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1110\/i109\/1099765261_1.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1110\/i109\/1099765261_2.jpg"},{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1110\/i109\/1099765261_3.jpg"}],"Brie":"Excel如何按照不同的区间统计数量？","SN":"9","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1110\/i109\/1099763020_1.jpg"}],"Brie":"职场联盟Excel生产挖掘分享Excel基础技能Excel爱好者大本营用1%的Excel基础搞定99%的职场问题做一个超级实用的Excel公众号E...","SN":"7","RN":"0","istop":"0"}

{"imgList":[{"img":"http:\/\/thumbnail1.360doc.com\/DownloadImg\/2023\/10\/1107\/i109\/1099745817_1.jpg"}],"Brie":"网页上的文字需要付费会员才能复制，一招让你想复制什么都可以我们经常会遇到这种情况，好不容易在网上找到一篇文章，想复...","SN":"6","RN":"0","istop":"0"}