{"code":200,"msg":{"v":2},"time":1684936043,"data":[{"key":"ABS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/172.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"超简单ABS函数 计算绝对值"},"channel":1,"app":"","version":1},{"key":"ACCRINT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/115.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":89,"show_type":"icon","top_cate":"xls","bg_title":"巧用ACCRINT函数 算定期证券利息"},"channel":1,"app":"","version":1},{"key":"ACCRINTM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/136.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":78,"show_type":"icon","top_cate":"xls","bg_title":"ACCRINTM函数 到期一次性证券利息"},"channel":1,"app":"","version":1},{"key":"ACOS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/271.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"ACOS函数 计算反余弦值"},"channel":1,"app":"","version":1},{"key":"ACOSH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/498.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"ACOSH函数 计算反双曲余弦值"},"channel":1,"app":"","version":1},{"key":"ADDRESS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/182.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":122,"show_type":"icon","top_cate":"xls","bg_title":"ADDRESS函数 转化绝对引用"},"channel":1,"app":"","version":1},{"key":"AGGREGATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14092.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":100,"top_cate":"xls","bg_title":"AGGREGATE函数"},"channel":1,"app":"","version":2},{"key":"AMORDEGRC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/137.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":87,"show_type":"icon","top_cate":"xls","bg_title":"AMORDEGRC函数 计算财务常用的折旧值"},"channel":1,"app":"","version":1},{"key":"AMORLINC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/476.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"AMORLINC函数"},"channel":1,"app":"","version":1},{"key":"AND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/205.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"一分钟 掌握AND函数"},"channel":1,"app":"","version":1},{"key":"AREAS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/360.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":134,"show_type":"icon","top_cate":"xls","bg_title":"巧用AREAS函数 计算区域个数"},"channel":1,"app":"","version":1},{"key":"ASC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/261.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"巧用ASC函数将 全角字符转换成半角字符"},"channel":1,"app":"","version":1},{"key":"ASIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/243.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"巧用ASIN函数 计算反正弦值"},"channel":1,"app":"","version":1},{"key":"ASINH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/486.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"巧用ASINH函数 计算反双曲正弦值"},"channel":1,"app":"","version":1},{"key":"ATAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/349.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":74,"show_type":"icon","top_cate":"xls","bg_title":"巧用ATAN函数 求反正切值"},"channel":1,"app":"","version":1},{"key":"ATAN2","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/300.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"ATAN2函数 计算给定坐标反正切值"},"channel":1,"app":"","version":1},{"key":"ATANH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/458.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":77,"show_type":"icon","top_cate":"xls","bg_title":"ATANH函数 计算数值反双曲正切值"},"channel":1,"app":"","version":1},{"key":"AVEDEV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/269.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"AVEDEV函数 计算平均绝对偏差"},"channel":1,"app":"","version":1},{"key":"AVERAGE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/281.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"AVERAGE函数 快速求数据平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/299.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"AVERAGEA函数 计算有文本的数字平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEIF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/317.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"AVERAGEIF函数 指定条件求平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/313.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":84,"show_type":"icon","top_cate":"xls","bg_title":"AVERAGEIFS 计算多条件的平均值"},"channel":1,"app":"","version":1},{"key":"BAHTTEXT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/298.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"BAHTTEXT函数将 数字转换成泰铢"},"channel":1,"app":"","version":1},{"key":"BESSELI","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/99.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":84,"show_type":"icon","top_cate":"xls","bg_title":"BESSELI函数 返回修正贝塞尔函数"},"channel":1,"app":"","version":1},{"key":"BESSELJ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/451.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"BESSELJ函数 返回贝塞尔函数值"},"channel":1,"app":"","version":1},{"key":"BESSELK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/446.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"BESSELK函数计算 贝塞尔Kn(x)的函数"},"channel":1,"app":"","version":1},{"key":"BESSELY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/467.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":64,"show_type":"icon","top_cate":"xls","bg_title":"BESSELY函数 快速计算贝塞尔函数值"},"channel":1,"app":"","version":1},{"key":"BETADIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/380.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":97,"show_type":"icon","top_cate":"xls","bg_title":"BETADIST函数 累积分布函数"},"channel":1,"app":"","version":1},{"key":"BETAINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/365.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":97,"show_type":"icon","top_cate":"xls","bg_title":"BETAINV函数求 分布函数反函数值"},"channel":1,"app":"","version":1},{"key":"BIN2DEC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/454.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"BIN2DEC函数 二进制数转十进制数"},"channel":1,"app":"","version":1},{"key":"BIN2HEX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/350.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"BIN2HEX函数 二进制转换成十六进制"},"channel":1,"app":"","version":1},{"key":"BIN2OCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/422.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"BIN2OCT函数 二进制转八进制数"},"channel":1,"app":"","version":1},{"key":"BINOM.DIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/288.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":92,"show_type":"icon","top_cate":"xls","bg_title":"BINOM.DIST函数"},"channel":1,"app":"","version":1},{"key":"BINOM.DIST.RANGE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/411.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"BINOM.DIST.RANGE函数"},"channel":1,"app":"","version":1},{"key":"BINOM.INV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/499.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"BINOM.INV函数"},"channel":1,"app":"","version":1},{"key":"BINOMDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/507.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":103,"show_type":"icon","top_cate":"xls","bg_title":"BINOMDIST函数"},"channel":1,"app":"","version":1},{"key":"BITAND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/218.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"巧用BITAND函数 求C语言中的按位与"},"channel":1,"app":"","version":1},{"key":"BITLSHIFT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/178.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"BITLSHIFT函数 二进制添零并转换十进制"},"channel":1,"app":"","version":1},{"key":"BITOR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/328.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"BITOR函数计算 两个数值按位运算"},"channel":1,"app":"","version":1},{"key":"BITRSHIFT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/400.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"BITRSHIFT函数 计算数值右移的数值"},"channel":1,"app":"","version":1},{"key":"BITXOR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/399.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"BITXOR函数 返回数值异或值"},"channel":1,"app":"","version":1},{"key":"CEILING","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/216.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"巧用CEILING函数 向上舍入"},"channel":1,"app":"","version":1},{"key":"CELL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/258.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"超级神秘的 CELL函数"},"channel":1,"app":"","version":1},{"key":"CHAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/193.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"巧用CHAR函数 将代码转换为字符"},"channel":1,"app":"","version":1},{"key":"CHIDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/125.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用CHIDIST函数 检验初始假设"},"channel":1,"app":"","version":1},{"key":"CHIINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/431.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"CHIINV函数"},"channel":1,"app":"","version":1},{"key":"CHISQ.DIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/463.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":74,"show_type":"icon","top_cate":"xls","bg_title":"CHISQ.DIST函数"},"channel":1,"app":"","version":1},{"key":"CHISQ.INV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/492.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"CHISQ.INV函数"},"channel":1,"app":"","version":1},{"key":"CHITEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/106.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"求检验假设的 CHITEST函数值"},"channel":1,"app":"","version":1},{"key":"CHOOSE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/196.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"巧用CHOOSE函数 筛选数据"},"channel":1,"app":"","version":1},{"key":"CLEAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/414.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"CLEAN函数删除 文本中不能打印的字符"},"channel":1,"app":"","version":1},{"key":"CODE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/503.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"CODE函数 查询字符编号"},"channel":1,"app":"","version":1},{"key":"COLUMN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/127.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":64,"show_type":"icon","top_cate":"xls","bg_title":"COLUMN函数 标注单元格列号"},"channel":1,"app":"","version":1},{"key":"COLUMNS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/227.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"COLUMNS函数 统计列数项目"},"channel":1,"app":"","version":1},{"key":"COMBIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/381.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"巧用COMBIN函数 求组合数"},"channel":1,"app":"","version":1},{"key":"COMPLEX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/322.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"巧用COMPLEX函数 批量创建复数"},"channel":1,"app":"","version":1},{"key":"CONCAT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/457.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用CONCAT函数 组合文本"},"channel":1,"app":"","version":1},{"key":"CONCATENATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/153.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"CONCATENATE函数"},"channel":1,"app":"","version":1},{"key":"CONFIDENCE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/306.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"CONFIDENCE 计算置信区间"},"channel":1,"app":"","version":1},{"key":"CONVERT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/332.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"CONVERT函数 全能的单位转换器"},"channel":1,"app":"","version":1},{"key":"CORREL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/272.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"CORREL函数 计算数据集相关系数"},"channel":1,"app":"","version":1},{"key":"COS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/318.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"巧用COS函数 求余弦值"},"channel":1,"app":"","version":1},{"key":"COSH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/456.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":52,"show_type":"icon","top_cate":"xls","bg_title":"COSH函数 计算双曲余弦值"},"channel":1,"app":"","version":1},{"key":"COUNT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/147.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"COUNT函数 一键统计有参数的项目"},"channel":1,"app":"","version":1},{"key":"COUNTA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/282.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"巧用COUNTA函数 计算非空单元格个数"},"channel":1,"app":"","version":1},{"key":"COUNTBLANK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/228.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"COUNTBLANK函数"},"channel":1,"app":"","version":1},{"key":"COUNTIF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/55.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":123,"show_type":"icon","top_cate":"xls","bg_title":"用COUNTIF 统计字符出现次数"},"channel":1,"app":"","version":1},{"key":"COUNTIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/133.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"COUNTIFS函数统计 满足不同条件数据"},"channel":1,"app":"","version":1},{"key":"COUPDAYBS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/415.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"COUPDAYBS函数 计算付息期到结算日天数"},"channel":1,"app":"","version":1},{"key":"COUPDAYS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14095.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"COUPDAYS函数 计算结算日付息期天数"},"channel":1,"app":"","version":2},{"key":"COUPDAYSNC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/477.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":88,"show_type":"icon","top_cate":"xls","bg_title":"COUPDAYSNC函数"},"channel":1,"app":"","version":1},{"key":"COUPNCD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14096.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":128,"top_cate":"xls","bg_title":"COUPNCD函数"},"channel":1,"app":"","version":2},{"key":"COUPNUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14097.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":96,"top_cate":"xls","bg_title":"COUPNUM函数"},"channel":1,"app":"","version":2},{"key":"COUPPCD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14098.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":126,"top_cate":"xls","bg_title":"COUPPCD函数"},"channel":1,"app":"","version":2},{"key":"COVAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/367.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":52,"show_type":"icon","top_cate":"xls","bg_title":"COVAR函数 计算协方差"},"channel":1,"app":"","version":1},{"key":"COVARIANCE.P","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14102.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"Covariance.P函数"},"channel":1,"app":"","version":2},{"key":"COVARIANCE.S","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14103.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"Covariance.S函数"},"channel":1,"app":"","version":2},{"key":"CRITBINOM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/420.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"CRITBINOM函数"},"channel":1,"app":"","version":1},{"key":"CUMIPMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/500.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"CUMIPMT函数 两个付款期之间累计利息"},"channel":1,"app":"","version":1},{"key":"CUMPRINC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/98.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":148,"show_type":"icon","top_cate":"xls","bg_title":"CUMPRINC 快速计算应还贷款本金"},"channel":1,"app":"","version":1},{"key":"DATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/152.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"巧用DATE函数 转换日期格式"},"channel":1,"app":"","version":1},{"key":"DATEDIF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/154.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":95,"show_type":"icon","top_cate":"xls","bg_title":"DATEDIF函数 计算日期间隔数"},"channel":1,"app":"","version":1},{"key":"DATEVALUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/244.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":88,"show_type":"icon","top_cate":"xls","bg_title":"DATEVALUE 日期转换成序列号"},"channel":1,"app":"","version":1},{"key":"DAVERAGE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/217.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"巧用DAVERAGE函数 求平均值"},"channel":1,"app":"","version":1},{"key":"DAY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/323.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":57,"show_type":"icon","top_cate":"xls","bg_title":"巧用DAY函数 显示日期天数"},"channel":1,"app":"","version":1},{"key":"DAYS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/392.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":102,"top_cate":"xls","bg_title":"DAYS函数"},"channel":1,"app":"","version":1},{"key":"DAYS360","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/220.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":87,"show_type":"icon","top_cate":"xls","bg_title":"DAYS360函数 计算相差天数"},"channel":1,"app":"","version":1},{"key":"DB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/334.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":101,"show_type":"icon","top_cate":"xls","bg_title":"DB函数计算 给定期间内折旧值"},"channel":1,"app":"","version":1},{"key":"DCOUNT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/189.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"DCOUNT函数统计 符合条件的数据个数"},"channel":1,"app":"","version":1},{"key":"DCOUNTA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/279.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"Dcounta函数统计 满足指定条件的个数"},"channel":1,"app":"","version":1},{"key":"DDB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/301.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"DDB函数双倍余额 递减计算折旧额"},"channel":1,"app":"","version":1},{"key":"DEC2BIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/489.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"DEC2BIN函数 将十进制转换二进制数"},"channel":1,"app":"","version":1},{"key":"DEC2HEX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/168.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"十进制数如何 转换成十六进制数"},"channel":1,"app":"","version":1},{"key":"DEC2OCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/102.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":130,"show_type":"icon","top_cate":"xls","bg_title":"如何将十进制数 转换成八进制数"},"channel":1,"app":"","version":1},{"key":"DEGREES","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/333.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"DEGREES函数 弧度值转换角度值"},"channel":1,"app":"","version":1},{"key":"DELTA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/461.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"巧用DELTA函数 判断两数值是否相等"},"channel":1,"app":"","version":1},{"key":"DEVSQ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/297.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"DEVSQ函数 计算偏差平方和"},"channel":1,"app":"","version":1},{"key":"DGET","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/229.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":105,"show_type":"icon","top_cate":"xls","bg_title":"DGET函数快速 按条件查找个值"},"channel":1,"app":"","version":1},{"key":"DISC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14099.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"DISC函数"},"channel":1,"app":"","version":2},{"key":"DMAX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/278.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":52,"show_type":"icon","top_cate":"xls","bg_title":"DMAX函数筛选 满足条件的最大数值"},"channel":1,"app":"","version":1},{"key":"DMIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/296.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"DMIN函数筛选 满足条件的最小数值"},"channel":1,"app":"","version":1},{"key":"DOLLAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/357.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":81,"show_type":"icon","top_cate":"xls","bg_title":"DOLLAR函数 将数值转换货币格式"},"channel":1,"app":"","version":1},{"key":"DOLLARDE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14100.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"DOLLARDE函数"},"channel":1,"app":"","version":2},{"key":"DOLLARFR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14101.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":47,"top_cate":"xls","bg_title":"DOLLARFR函数"},"channel":1,"app":"","version":2},{"key":"DPRODUCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/166.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":92,"show_type":"icon","top_cate":"xls","bg_title":"DPRODUCT函数 计算利润乘积"},"channel":1,"app":"","version":1},{"key":"DSTDEV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/484.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"DSTDEV函数计算 条件样本估算标准偏差"},"channel":1,"app":"","version":1},{"key":"DSTDEVP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/474.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"DSTDEVP函数 计算满足条件标准偏差"},"channel":1,"app":"","version":1},{"key":"DSUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/263.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":71,"show_type":"icon","top_cate":"xls","bg_title":"巧用DSUM函数 快速条件求和"},"channel":1,"app":"","version":1},{"key":"DURATION","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14105.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":115,"top_cate":"xls","bg_title":"DURATION函数"},"channel":1,"app":"","version":2},{"key":"DVAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/468.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":88,"show_type":"icon","top_cate":"xls","bg_title":"DVAR函数计算 数据库样本总体方差"},"channel":1,"app":"","version":1},{"key":"DVARP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/450.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"DVARP函数计算满足 条件样本的总体方差"},"channel":1,"app":"","version":1},{"key":"EDATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/190.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用EDATE函数 批量计算到期日"},"channel":1,"app":"","version":1},{"key":"ENCODEURL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/377.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"ENCODEURL函数"},"channel":1,"app":"","version":1},{"key":"EOMONTH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/211.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"EOMONTH函数 计算到期日"},"channel":1,"app":"","version":1},{"key":"ERF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/488.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"巧用ERF函数 计算误差函数值"},"channel":1,"app":"","version":1},{"key":"ERFC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/368.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"ERFC函数 计算数值余误差"},"channel":1,"app":"","version":1},{"key":"ERROR.TYPE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/478.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"ERROR.TYPE函数"},"channel":1,"app":"","version":1},{"key":"EVALUATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/162.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"强大的计算器 EVALUATE函数"},"channel":1,"app":"","version":1},{"key":"EVEN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/351.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"EVEN函数将数值 向上舍入最接近偶数"},"channel":1,"app":"","version":1},{"key":"EXACT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/144.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"巧用EXACT函数 两项字符串是否一致"},"channel":1,"app":"","version":1},{"key":"EXP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/417.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":58,"show_type":"icon","top_cate":"xls","bg_title":"EXP函数计算e的n次幂"},"channel":1,"app":"","version":1},{"key":"EXPONDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/410.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"EXPONDIST函数 计算指数函数"},"channel":1,"app":"","version":1},{"key":"FACT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/470.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"巧用FACT函数 快速计算数字的阶乘"},"channel":1,"app":"","version":1},{"key":"FACTDOUBLE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/469.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"FACTDOUBLE函数"},"channel":1,"app":"","version":1},{"key":"FALSE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/165.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"逻辑函数FALSE的 实例运用"},"channel":1,"app":"","version":1},{"key":"FDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/111.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":84,"show_type":"icon","top_cate":"xls","bg_title":"快速求出 FDIST函数值"},"channel":1,"app":"","version":1},{"key":"FIELDVALUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14334.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":88,"top_cate":"xls","bg_title":"利用FIELDVALUE 函数查询股票或基金信息"},"channel":1,"app":"","version":2},{"key":"FILTER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330371.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":249,"top_cate":"xls","bg_title":"如何使用FILTER函数"},"channel":1,"app":"et","version":2},{"key":"FIND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/339.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":85,"show_type":"icon","top_cate":"xls","bg_title":"FIND函数定位某值 首次出现的字符数"},"channel":1,"app":"","version":1},{"key":"FINDB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/292.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"FINDB函数定位 某值首次出现的字节数"},"channel":1,"app":"","version":1},{"key":"FINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/113.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":84,"show_type":"icon","top_cate":"xls","bg_title":"不到0.1秒 算出FINV函数值"},"channel":1,"app":"","version":1},{"key":"FISHER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/305.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"FISHER函数转换数值FISHER变换值"},"channel":1,"app":"","version":1},{"key":"FISHERINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/459.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"FISHERINV函数"},"channel":1,"app":"","version":1},{"key":"FIXED","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/335.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"巧用FIXED函数 指定小数位数取整"},"channel":1,"app":"","version":1},{"key":"FLOOR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/352.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":90,"show_type":"icon","top_cate":"xls","bg_title":"巧用FLOOR函数 向下舍入"},"channel":1,"app":"","version":1},{"key":"FORECAST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/145.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"Forecast函数 预测数据走向"},"channel":1,"app":"","version":1},{"key":"FORMULATEXT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/273.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":46,"show_type":"icon","top_cate":"xls","bg_title":"FORMULATEXT函数"},"channel":1,"app":"","version":1},{"key":"FREQUENCY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/276.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"FREQUENCY函数 进行分段统计"},"channel":1,"app":"","version":1},{"key":"FTEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/374.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":45,"show_type":"icon","top_cate":"xls","bg_title":"FTEST函数 计算数值双尾概率"},"channel":1,"app":"","version":1},{"key":"FV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/253.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":78,"show_type":"icon","top_cate":"xls","bg_title":"FV函数计算投资未来值"},"channel":1,"app":"","version":1},{"key":"GAMMADIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/409.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"GAMMADIST函数 返回伽玛分布值"},"channel":1,"app":"","version":1},{"key":"GAMMAINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/408.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"GAMMAINV函数"},"channel":1,"app":"","version":1},{"key":"GAMMALN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/464.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"GAMMALN函数 伽玛函数自然对数"},"channel":1,"app":"","version":1},{"key":"GAMMALN.PRECISE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/448.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"GAMMALN.PRECISE函数"},"channel":1,"app":"","version":1},{"key":"GCD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/466.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":48,"show_type":"icon","top_cate":"xls","bg_title":"GCD函数 计算整数的最大公约数"},"channel":1,"app":"","version":1},{"key":"GEOMEAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/336.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"GEOMEAN函数 求几何平均值"},"channel":1,"app":"","version":1},{"key":"GESTEP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/105.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":100,"show_type":"icon","top_cate":"xls","bg_title":"巧用GESTEP函数 快速查看是否及格"},"channel":1,"app":"","version":1},{"key":"GETPIVOTDATA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/231.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"GETPIVOTDATA函数"},"channel":1,"app":"","version":1},{"key":"GROWTH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/369.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"GROWTH函数 预测未来等比数值"},"channel":1,"app":"","version":1},{"key":"HARMEAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/382.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"HARMEAN函数 求调和平均值"},"channel":1,"app":"","version":1},{"key":"HEX2BIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/270.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"HEX2BIN函数 十六进制转换成二进制"},"channel":1,"app":"","version":1},{"key":"HEX2DEC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/210.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"HEX2DEC函数 十六进制转换十进制"},"channel":1,"app":"","version":1},{"key":"HEX2OCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/445.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"HEX2OCT函数 十六进制转八进制"},"channel":1,"app":"","version":1},{"key":"HLOOKUP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/482.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":123,"show_type":"icon","top_cate":"xls","bg_title":"巧用HLOOKUP 横向查找数据"},"channel":1,"app":"","version":1},{"key":"HOUR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/221.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"巧用HOUR函数 计算小时时差"},"channel":1,"app":"","version":1},{"key":"HYPERLINK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/159.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"HYPERLINK函数"},"channel":1,"app":"","version":1},{"key":"HYPGEOMDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/407.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":57,"show_type":"icon","top_cate":"xls","bg_title":"HYPGEOMDIST函数"},"channel":1,"app":"","version":1},{"key":"IF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/110.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"巧用IF函数 判断数据"},"channel":1,"app":"","version":1},{"key":"IFERROR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/128.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"IFERROR函数 自定义报错结果"},"channel":1,"app":"","version":1},{"key":"IFNA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/148.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":71,"show_type":"icon","top_cate":"xls","bg_title":"IFNA函数 改变错误值#N\/A"},"channel":1,"app":"","version":1},{"key":"IFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/222.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":89,"show_type":"icon","top_cate":"xls","bg_title":"如何用IFS函数 实现多条件判断"},"channel":1,"app":"","version":1},{"key":"IMABS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/109.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":62,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMABS函数 1秒求复数绝对值"},"channel":1,"app":"","version":1},{"key":"IMAGINARY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/319.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"IMAGINARY函数 提取复数的虚系数"},"channel":1,"app":"","version":1},{"key":"IMARGUMENT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/337.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"IMARGUMENT 快速计算复数对应角度"},"channel":1,"app":"","version":1},{"key":"IMCONJUGATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/418.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":74,"show_type":"icon","top_cate":"xls","bg_title":"IMCONJUGATE函数计算共轭复数"},"channel":1,"app":"","version":1},{"key":"IMCOS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/416.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"IMCOS函数 快速计算复数余弦值"},"channel":1,"app":"","version":1},{"key":"IMDIV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/471.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMDIV函数 快速计算复数的商"},"channel":1,"app":"","version":1},{"key":"IMEXP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/103.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":77,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMEXP函数 1秒求复数的指数"},"channel":1,"app":"","version":1},{"key":"IMLN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/423.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":42,"show_type":"icon","top_cate":"xls","bg_title":"IMLN函数 计算自然对数"},"channel":1,"app":"","version":1},{"key":"IMLOG10","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/452.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":58,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMLOG10函数 计算复数的常用对数"},"channel":1,"app":"","version":1},{"key":"IMLOG2","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/475.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"IMLOG2函数 以2位底数复数对数"},"channel":1,"app":"","version":1},{"key":"IMPOWER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/104.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":98,"show_type":"icon","top_cate":"xls","bg_title":"IMPOWER函数 1秒求复数的整数幂"},"channel":1,"app":"","version":1},{"key":"IMPRODUCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/398.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"IMPRODUCT函数 计算复数乘积"},"channel":1,"app":"","version":1},{"key":"IMREAL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/432.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMREAL函数 提取复数的实系数"},"channel":1,"app":"","version":1},{"key":"IMSIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/419.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"IMSIN函数 快速计算复数正弦值"},"channel":1,"app":"","version":1},{"key":"IMSQRT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/453.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":58,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMSQRT函数 计算复数的平方根"},"channel":1,"app":"","version":1},{"key":"IMSUB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/118.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":62,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMSUB函数 1秒求复数的差"},"channel":1,"app":"","version":1},{"key":"IMSUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/107.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"巧用IMSUM函数 1秒求复数的和"},"channel":1,"app":"","version":1},{"key":"INDEX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/116.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":141,"show_type":"icon","top_cate":"xls","bg_title":"INDEX函数的用法"},"channel":1,"app":"","version":1},{"key":"INDIRECT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/129.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"INDIRECT函数 引用单元格内容"},"channel":1,"app":"","version":1},{"key":"INFO","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/373.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":58,"show_type":"icon","top_cate":"xls","bg_title":"INFO函数 查询操作环境信息"},"channel":1,"app":"","version":1},{"key":"INT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/157.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":52,"show_type":"icon","top_cate":"xls","bg_title":"巧用INT函数 一秒求整"},"channel":1,"app":"","version":1},{"key":"INTERCEPT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/307.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"INTERCEPT函数"},"channel":1,"app":"","version":1},{"key":"IPMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/324.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":124,"show_type":"icon","top_cate":"xls","bg_title":"巧用IPMT函数计算贷款利息"},"channel":1,"app":"","version":1},{"key":"IRR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/149.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":91,"show_type":"icon","top_cate":"xls","bg_title":"巧用IRR函数 算内部收益率"},"channel":1,"app":"","version":1},{"key":"ISBLANK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/209.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":62,"show_type":"icon","top_cate":"xls","bg_title":"ISBLANK函数 快速查看单元格空格"},"channel":1,"app":"","version":1},{"key":"ISERR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/397.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"ISERR与IF 一步去除错误字符"},"channel":1,"app":"","version":1},{"key":"ISERROR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/135.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"ISERROR函数 判断数值是否错误"},"channel":1,"app":"","version":1},{"key":"ISEVEN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/325.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"巧用ISEVEN函数 判断数值是否偶数"},"channel":1,"app":"","version":1},{"key":"ISFORMULA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14104.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"ISFORMULA函数"},"channel":1,"app":"","version":2},{"key":"ISLOGICAL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/433.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"ISLOGICAL函数 检验逻辑值"},"channel":1,"app":"","version":1},{"key":"ISNA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/160.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"巧用ISNA函数 处理错误值#N\/A"},"channel":1,"app":"","version":1},{"key":"ISNONTEXT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/383.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"ISNONTEXT函数 检验值是否为非文本"},"channel":1,"app":"","version":1},{"key":"ISNUMBER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/155.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":64,"show_type":"icon","top_cate":"xls","bg_title":"ISNUMBER 一秒判断是否是数值"},"channel":1,"app":"","version":1},{"key":"ISODD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/274.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"ISODD函数判断数值奇偶 "},"channel":1,"app":"","version":1},{"key":"ISPMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/487.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"ISPMT函数计算 特定投资期要支付利息"},"channel":1,"app":"","version":1},{"key":"ISREF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/327.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"ISREF函数判断 值是否为单元格引用"},"channel":1,"app":"","version":1},{"key":"ISTEXT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/308.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"ISTEXT函数 检测参数是否为文本"},"channel":1,"app":"","version":1},{"key":"KURT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/314.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":46,"show_type":"icon","top_cate":"xls","bg_title":"KURT函数 计算数值峰值"},"channel":1,"app":"","version":1},{"key":"LARGE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/267.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":112,"show_type":"icon","top_cate":"xls","bg_title":"LARGE函数"},"channel":1,"app":"","version":1},{"key":"LCM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/425.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"LCM函数 计算最小公倍数"},"channel":1,"app":"","version":1},{"key":"LEFT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/119.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"LEFT函数 一秒提取地址信息"},"channel":1,"app":"","version":1},{"key":"LEFTB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/126.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"巧用LEFTB函数 提取字节个数"},"channel":1,"app":"","version":1},{"key":"LEN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/251.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":54,"show_type":"icon","top_cate":"xls","bg_title":"LEN函数 计算文本字符"},"channel":1,"app":"","version":1},{"key":"LENB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/252.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":64,"show_type":"icon","top_cate":"xls","bg_title":"LENB函数 计算文本字节数"},"channel":1,"app":"","version":1},{"key":"LINEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/212.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":79,"show_type":"icon","top_cate":"xls","bg_title":"LINEST函数 求斜率和截距"},"channel":1,"app":"","version":1},{"key":"LN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/315.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"LN函数 计算指定数值的自然对数"},"channel":1,"app":"","version":1},{"key":"LOG","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/412.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"巧用LOG函数 按指定底数返回对数"},"channel":1,"app":"","version":1},{"key":"LOG10","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/438.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"巧用LOG10函数 求数值以10为底的对数"},"channel":1,"app":"","version":1},{"key":"LOGEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/370.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"LOGEST函数 计算回归拟合曲线值"},"channel":1,"app":"","version":1},{"key":"LOGINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/175.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"巧用LOGINV函数 求反函数值"},"channel":1,"app":"","version":1},{"key":"LOGNORMDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/406.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"LOGNORMDIST函数"},"channel":1,"app":"","version":1},{"key":"LOOKUP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/130.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":142,"show_type":"icon","top_cate":"xls","bg_title":"巧用LOOKUP函数 快速查找数据"},"channel":1,"app":"","version":1},{"key":"LOWER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/491.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"巧用LOWER函数 一键转换英文大小写"},"channel":1,"app":"","version":1},{"key":"MATCH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/123.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":153,"show_type":"icon","top_cate":"xls","bg_title":"MATCH函数的作用"},"channel":1,"app":"","version":1},{"key":"MAX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/146.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":57,"show_type":"icon","top_cate":"xls","bg_title":"巧用MAX函数 一秒找到最大数值"},"channel":1,"app":"","version":1},{"key":"MAXA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/509.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"MAXA函数 计算数值的最大值"},"channel":1,"app":"","version":1},{"key":"MAXIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/449.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"巧用MAXIFS函数 按条件求最大值"},"channel":1,"app":"","version":1},{"key":"MDETERM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/320.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"MDETERM函数 快速求矩阵行列式的值"},"channel":1,"app":"","version":1},{"key":"MDURATION","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14106.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":107,"top_cate":"xls","bg_title":"MDURATION函数"},"channel":1,"app":"","version":2},{"key":"MEDIAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/245.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":52,"show_type":"icon","top_cate":"xls","bg_title":"MEDIAN函数 快速找到中位数"},"channel":1,"app":"","version":1},{"key":"MID","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/124.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"巧用MID函数 一秒提取身份证年月日"},"channel":1,"app":"","version":1},{"key":"MIDB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/266.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"巧用文本函数MIDB 截取指定字符"},"channel":1,"app":"","version":1},{"key":"MIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/289.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":43,"show_type":"icon","top_cate":"xls","bg_title":"MIN函数 一秒查找最小值"},"channel":1,"app":"","version":1},{"key":"MINA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/508.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":93,"show_type":"icon","top_cate":"xls","bg_title":"MINA函数 计算数值的最小值"},"channel":1,"app":"","version":1},{"key":"MINIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/421.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"巧用MINIFS函数 按条件求最小值"},"channel":1,"app":"","version":1},{"key":"MINUTE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/208.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"MINUTE函数 两个时间段分钟时长"},"channel":1,"app":"","version":1},{"key":"MINVERSE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/264.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":74,"show_type":"icon","top_cate":"xls","bg_title":"MINVERSE函数 求逆矩阵行列式"},"channel":1,"app":"","version":1},{"key":"MIRR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/309.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"MIRR函数计算 再投资的收益率"},"channel":1,"app":"","version":1},{"key":"MMULT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/179.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":88,"show_type":"icon","top_cate":"xls","bg_title":"MMULT函数 计算矩阵乘积"},"channel":1,"app":"","version":1},{"key":"MOD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/173.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":79,"show_type":"icon","top_cate":"xls","bg_title":"巧用MOD函数 求除法余数"},"channel":1,"app":"","version":1},{"key":"MODE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/384.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"巧用MODE函数 快速求众数"},"channel":1,"app":"","version":1},{"key":"MONTH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/163.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"MONTH函数 提取日期的月份值"},"channel":1,"app":"","version":1},{"key":"MROUND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/290.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"MROUND函数 舍入数值最近倍数"},"channel":1,"app":"","version":1},{"key":"MULTINOMIAL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/393.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"MULTINOMIAL函数"},"channel":1,"app":"","version":1},{"key":"N","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/514.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":64,"top_cate":"xls","bg_title":"N函数将非数值 转换成数值"},"channel":1,"app":"","version":1},{"key":"NA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/310.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"NA函数美化折线图 "},"channel":1,"app":"","version":1},{"key":"NEGBINOMDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/481.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":62,"show_type":"icon","top_cate":"xls","bg_title":"NEGBINOMDIST函数"},"channel":1,"app":"","version":1},{"key":"NETWORKDAYS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/167.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"NETWORKDAYS函数"},"channel":1,"app":"","version":1},{"key":"NETWORKDAYS.INTL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/242.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":90,"show_type":"icon","top_cate":"xls","bg_title":"NETWORKDAYS.INTL函数"},"channel":1,"app":"","version":1},{"key":"NORM.DIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/390.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"NORM.DIST函数"},"channel":1,"app":"","version":1},{"key":"NORM.INV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/389.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"NORM.INV函数"},"channel":1,"app":"","version":1},{"key":"NORM.S.DIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/388.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"NORM.S.DIST函数"},"channel":1,"app":"","version":1},{"key":"NORM.S.INV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/379.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"NORM.S.INV函数"},"channel":1,"app":"","version":1},{"key":"NORMDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/232.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":93,"show_type":"icon","top_cate":"xls","bg_title":"NORMDIST函数"},"channel":1,"app":"","version":1},{"key":"NORMINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/191.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用NORMINV函数 求反函数值"},"channel":1,"app":"","version":1},{"key":"NORMSDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/405.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":58,"show_type":"icon","top_cate":"xls","bg_title":"NORMSDIST函数"},"channel":1,"app":"","version":1},{"key":"NORMSINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/404.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"NORMSINV函数计算"},"channel":1,"app":"","version":1},{"key":"NOT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/501.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":81,"show_type":"icon","top_cate":"xls","bg_title":"NOT函数反向判断 事物是否满足条件"},"channel":1,"app":"","version":1},{"key":"NOW","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/326.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":55,"show_type":"icon","top_cate":"xls","bg_title":"NOW函数插入 实时时间并自动更新"},"channel":1,"app":"","version":1},{"key":"NPER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/311.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"NPER函数计算贷款总期数"},"channel":1,"app":"","version":1},{"key":"NPV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/134.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"巧用NPV函数 一秒计算收支净额"},"channel":1,"app":"","version":1},{"key":"NUMBERSTRING","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/340.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":98,"show_type":"icon","top_cate":"xls","bg_title":"NUMBERSTRING函数"},"channel":1,"app":"","version":1},{"key":"NUMBERVALUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14093.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"NUMBERVALUE函数"},"channel":1,"app":"","version":2},{"key":"OCT2BIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/138.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":103,"show_type":"icon","top_cate":"xls","bg_title":"如何将八进制数 快捷转换成二进制数"},"channel":1,"app":"","version":1},{"key":"OCT2DEC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/455.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":53,"show_type":"icon","top_cate":"xls","bg_title":"OCT2DEC函数 八进制数转换十进制数"},"channel":1,"app":"","version":1},{"key":"OCT2HEX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/444.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"OCT2HEX函数 八进制转十六进制"},"channel":1,"app":"","version":1},{"key":"ODD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/353.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"ODD函数将数值 向上舍入为最接近的奇数"},"channel":1,"app":"","version":1},{"key":"OFFSET","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/122.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":176,"show_type":"icon","top_cate":"xls","bg_title":"如何使用OFFSET函数"},"channel":1,"app":"","version":1},{"key":"OR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/139.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":100,"show_type":"icon","top_cate":"xls","bg_title":"帮助你快速进行 逻辑判断的OR函数"},"channel":1,"app":"","version":1},{"key":"PEARSON","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/312.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"PEARSON函数 自变量因变量相关系数"},"channel":1,"app":"","version":1},{"key":"PERCENTILE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/213.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"PERCENTILE 求数组百分点"},"channel":1,"app":"","version":1},{"key":"PERCENTRANK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/403.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":85,"top_cate":"xls","bg_title":"PERCENTRANK函数"},"channel":1,"app":"","version":1},{"key":"PERMUT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/385.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"巧用PERMUT函数 计算排列数"},"channel":1,"app":"","version":1},{"key":"PHONETIC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/143.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"PHONETIC函数 链接非连贯的文本"},"channel":1,"app":"","version":1},{"key":"PI","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/321.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":78,"show_type":"icon","top_cate":"xls","bg_title":"巧用PI函数 计算圆周长和圆面积"},"channel":1,"app":"","version":1},{"key":"PMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/180.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":96,"show_type":"icon","top_cate":"xls","bg_title":"PMT函数计算分期还款 每期额度"},"channel":1,"app":"","version":1},{"key":"POISSON","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/402.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":83,"top_cate":"xls","bg_title":"POISSON函数 泊松累积分布函数值"},"channel":1,"app":"","version":1},{"key":"POWER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/240.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"POWER函数 如何进行乘幂计算"},"channel":1,"app":"","version":1},{"key":"PPMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/254.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":109,"show_type":"icon","top_cate":"xls","bg_title":"PPMT函数计算 规定期间本金偿还额"},"channel":1,"app":"","version":1},{"key":"PRICE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/302.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"PRICE函数 计算债券发行价格"},"channel":1,"app":"","version":1},{"key":"PROB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/490.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":91,"show_type":"icon","top_cate":"xls","bg_title":"PROB函数计算 数值指定区间的概率"},"channel":1,"app":"","version":1},{"key":"PRODUCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/286.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"巧用PRODUCT函数 进行乘积计算"},"channel":1,"app":"","version":1},{"key":"PROPER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/303.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":64,"show_type":"icon","top_cate":"xls","bg_title":"PROPER函数转换 首字母大写其余小写"},"channel":1,"app":"","version":1},{"key":"PV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/246.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":78,"show_type":"icon","top_cate":"xls","bg_title":"巧用PV函数计算投资现值"},"channel":1,"app":"","version":1},{"key":"QUARTILE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/199.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":105,"show_type":"icon","top_cate":"xls","bg_title":"QUARTILE函数 求四分位数"},"channel":1,"app":"","version":1},{"key":"QUOTIENT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/287.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"舍去商小数的除法运算 QUOTIENT函数"},"channel":1,"app":"","version":1},{"key":"RADIANS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/284.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":51,"show_type":"icon","top_cate":"xls","bg_title":"RADIANS函数 将角度转换弧度"},"channel":1,"app":"","version":1},{"key":"RAND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/112.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":122,"show_type":"icon","top_cate":"xls","bg_title":"巧用RAND函数 自动生成随机数据"},"channel":1,"app":"","version":1},{"key":"RANDARRAY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330368.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":147,"top_cate":"xls","bg_title":"用RANDARRAY函数 生成随机数组"},"channel":1,"app":"et","version":2},{"key":"RANDBETWEEN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/181.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":65,"show_type":"icon","top_cate":"xls","bg_title":"RANDBETWEEN函数"},"channel":1,"app":"","version":1},{"key":"RANK","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/108.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":130,"show_type":"icon","top_cate":"xls","bg_title":"RANK函数使用方法"},"channel":1,"app":"","version":1},{"key":"RANK.AVG","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/447.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":100,"show_type":"icon","top_cate":"xls","bg_title":"RANK.AVG函数的 使用方法"},"channel":1,"app":"","version":1},{"key":"RANK.EQ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/506.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":98,"show_type":"icon","top_cate":"xls","bg_title":"RANK.EQ函数的 使用方法"},"channel":1,"app":"","version":1},{"key":"RATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/214.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":95,"show_type":"icon","top_cate":"xls","bg_title":"巧用RATE函数求利率"},"channel":1,"app":"","version":1},{"key":"REPLACE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/608.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":74,"top_cate":"xls","bg_title":"REPLACE函数 替换新旧字符"},"channel":1,"app":"","version":1},{"key":"REPLACEB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/338.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":113,"top_cate":"xls","bg_title":"REPLACEB函数 批量更正错误数据"},"channel":1,"app":"","version":1},{"key":"REPT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/265.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":77,"show_type":"icon","top_cate":"xls","bg_title":"巧用REPT函数复制文本"},"channel":1,"app":"","version":1},{"key":"RIGHT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/247.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":49,"show_type":"icon","top_cate":"xls","bg_title":"巧用RIGHT函数 截取后段字符"},"channel":1,"app":"","version":1},{"key":"RIGHTB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/346.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":81,"show_type":"icon","top_cate":"xls","bg_title":"巧用RIGHTB函数 截取后段字符"},"channel":1,"app":"","version":1},{"key":"RMB ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/513.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"RMB函数将数值 转换成货币"},"channel":1,"app":"","version":1},{"key":"ROMAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/375.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":62,"show_type":"icon","top_cate":"xls","bg_title":"ROMAN函数 将数值转换成罗马数字"},"channel":1,"app":"","version":1},{"key":"ROUND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/120.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":124,"show_type":"icon","top_cate":"xls","bg_title":"如何快捷对小数 进行四舍五入"},"channel":1,"app":"","version":1},{"key":"ROUNDDOWN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/329.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":92,"show_type":"icon","top_cate":"xls","bg_title":"ROUNDDOWN函数"},"channel":1,"app":"","version":1},{"key":"ROUNDUP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/184.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"ROUNDUP函数 向上舍入小数"},"channel":1,"app":"","version":1},{"key":"ROW","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/132.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":123,"show_type":"icon","top_cate":"xls","bg_title":"巧用ROW函数 快速标注序数"},"channel":1,"app":"","version":1},{"key":"ROWS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/250.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":50,"show_type":"icon","top_cate":"xls","bg_title":"ROWS函数 计算单元格行数"},"channel":1,"app":"","version":1},{"key":"RSQ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/386.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"RSQ函数计算 乘积矩相关系数平方"},"channel":1,"app":"","version":1},{"key":"RTD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/364.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":108,"show_type":"icon","top_cate":"xls","bg_title":"巧用RTD函数 获取实时数据"},"channel":1,"app":"","version":1},{"key":"SEARCH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/174.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":94,"show_type":"icon","top_cate":"xls","bg_title":"SEARCH函数 查找字符首次出现位置"},"channel":1,"app":"","version":1},{"key":"SEARCHB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/275.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"SEARCHB函数查找 指定字节所在位置"},"channel":1,"app":"","version":1},{"key":"SECOND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/354.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"SECOND函数 提取时间秒数"},"channel":1,"app":"","version":1},{"key":"SEQUENCE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330372.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":126,"top_cate":"xls","bg_title":"如何使用 SEQUENCE函数"},"channel":1,"app":"et","version":2},{"key":"SERIESSUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/293.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":92,"show_type":"icon","top_cate":"xls","bg_title":"SERIESSUM函数 计算幂级数之和"},"channel":1,"app":"","version":1},{"key":"SIGN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/472.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"巧用SIGN函数 检验数值正负性"},"channel":1,"app":"","version":1},{"key":"SIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/156.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"SIN函数 一秒计算正弦值"},"channel":1,"app":"","version":1},{"key":"SINH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/485.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"SINH函数 快速计算双曲正弦值"},"channel":1,"app":"","version":1},{"key":"SKEW","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/347.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":53,"show_type":"icon","top_cate":"xls","bg_title":"SKEW函数 快速计算偏斜度"},"channel":1,"app":"","version":1},{"key":"SLN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"巧用SLN函数计算 线性折旧值"},"channel":1,"app":"","version":1},{"key":"SLOPE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/241.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":53,"show_type":"icon","top_cate":"xls","bg_title":"SLOPE函数 计算线性回归线斜率"},"channel":1,"app":"","version":1},{"key":"SMALL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/176.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用SMALL函数 查找数据集的最小值"},"channel":1,"app":"","version":1},{"key":"SORT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330394.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":206,"top_cate":"xls","bg_title":"SORT函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"SORTBY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330395.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":125,"top_cate":"xls","bg_title":"SORTBY函数 多条件排序"},"channel":1,"app":"et","version":2},{"key":"SQRT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/177.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"巧用SQRT函数 求平方根值"},"channel":1,"app":"","version":1},{"key":"SQRTPI","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/366.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"巧用SQRTPI函数 求乘以π后的平方根"},"channel":1,"app":"","version":1},{"key":"STANDARDIZE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/465.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"STANDARDIZE函数"},"channel":1,"app":"","version":1},{"key":"STDEV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/230.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":93,"show_type":"icon","top_cate":"xls","bg_title":"巧用STDEV函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEV.S","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/505.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":85,"show_type":"icon","top_cate":"xls","bg_title":"STDEV.S函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/316.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"STDEVA函数估算 文本逻辑的标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/277.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"STDEVP函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVPA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/434.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"STDEVPA函数 计算样本总体标准偏差"},"channel":1,"app":"","version":1},{"key":"STEYX","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/387.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":75,"show_type":"icon","top_cate":"xls","bg_title":"巧用STEYX函数 估算标准误差值"},"channel":1,"app":"","version":1},{"key":"SUBSTITUTE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/161.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":94,"show_type":"icon","top_cate":"xls","bg_title":"SUBSTITUTE函数"},"channel":1,"app":"","version":1},{"key":"SUBTOTAL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/158.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":107,"show_type":"icon","top_cate":"xls","bg_title":"SUBTOTAL函数计算 包含或忽略隐藏的数值"},"channel":1,"app":"","version":1},{"key":"SUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/151.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":145,"show_type":"icon","top_cate":"xls","bg_title":"常用求和函数 SUM函数"},"channel":1,"app":"","version":1},{"key":"SUMIF","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/44.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":262,"show_type":"icon","top_cate":"xls","bg_title":"常用条件求和函数 SUMIF函数"},"channel":1,"app":"","version":1},{"key":"SUMIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/150.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用SUMIFS函数 多条件求和"},"channel":1,"app":"","version":1},{"key":"SUMPRODUCT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/121.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":122,"show_type":"icon","top_cate":"xls","bg_title":"快速统计产品 销售总额以及总量"},"channel":1,"app":"","version":1},{"key":"SUMSQ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/391.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"SUMSQ函数 计算数值平方和"},"channel":1,"app":"","version":1},{"key":"SUMX2MY2","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/479.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"SUMX2MY2函数 两数组对应值平方差之和"},"channel":1,"app":"","version":1},{"key":"SUMX2PY2","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/460.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":79,"show_type":"icon","top_cate":"xls","bg_title":"SUMX2PY2函数"},"channel":1,"app":"","version":1},{"key":"SUMXMY2","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/437.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":82,"show_type":"icon","top_cate":"xls","bg_title":"SUMXMY2函数"},"channel":1,"app":"","version":1},{"key":"SWITCH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/396.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":108,"top_cate":"xls","bg_title":"SWITCH函数 定义某个值匹配对应结果"},"channel":1,"app":"","version":1},{"key":"SYD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/355.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":98,"show_type":"icon","top_cate":"xls","bg_title":"SYD函数计算折旧值 （年数总和法）"},"channel":1,"app":"","version":1},{"key":"T","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/285.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"巧用T函数 提取文本数据"},"channel":1,"app":"","version":1},{"key":"TAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/248.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":69,"show_type":"icon","top_cate":"xls","bg_title":"巧用TAN函数 求正切值"},"channel":1,"app":"","version":1},{"key":"TANH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/480.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"TANH函数 快速计算双曲正切值"},"channel":1,"app":"","version":1},{"key":"TDIST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/401.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"TDIST函数 计算学生T分布的概率"},"channel":1,"app":"","version":1},{"key":"TEXT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/140.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":146,"show_type":"icon","top_cate":"xls","bg_title":"一定要学 强大的转换函数TEXT"},"channel":1,"app":"","version":1},{"key":"TEXTJOIN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/280.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":74,"show_type":"icon","top_cate":"xls","bg_title":"TEXTJOIN函数 更强大的合并文本函数"},"channel":1,"app":"","version":1},{"key":"TIME","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/249.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":56,"show_type":"icon","top_cate":"xls","bg_title":"巧用TIME函数表示时间"},"channel":1,"app":"","version":1},{"key":"TIMEVALUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/331.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":101,"show_type":"icon","top_cate":"xls","bg_title":"TIMEVALUE函数 计算员工加班时间"},"channel":1,"app":"","version":1},{"key":"TINV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/358.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"TINV函数计算 自由度双尾概率区间点"},"channel":1,"app":"","version":1},{"key":"TODAY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/183.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":61,"show_type":"icon","top_cate":"xls","bg_title":"TODAY函数快速 计算间隔天数"},"channel":1,"app":"","version":1},{"key":"TRANSPOSE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/424.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"TRANSPOSE函数 转置表格横行竖列"},"channel":1,"app":"","version":1},{"key":"TREND","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/257.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":87,"show_type":"icon","top_cate":"xls","bg_title":"TREND函数 预测线性增长值"},"channel":1,"app":"","version":1},{"key":"TRIM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/192.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"巧用TRIM函数清除 字符首尾空格"},"channel":1,"app":"","version":1},{"key":"TRIMMEAN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/219.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":87,"show_type":"icon","top_cate":"xls","bg_title":"TRIMMEAN函数 求平均值"},"channel":1,"app":"","version":1},{"key":"TRUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/304.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":45,"show_type":"icon","top_cate":"xls","bg_title":"TRUE函数 判断条件是否成立"},"channel":1,"app":"","version":1},{"key":"TRUNC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/215.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"TRUNC函数 截去数字小数部分"},"channel":1,"app":"","version":1},{"key":"TTEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/164.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":85,"show_type":"icon","top_cate":"xls","bg_title":"巧用TTEST函数 运算T检验"},"channel":1,"app":"","version":1},{"key":"TYPE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/348.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":66,"show_type":"icon","top_cate":"xls","bg_title":"巧用TYPE函数 检验数值类型"},"channel":1,"app":"","version":1},{"key":"UNIQUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330370.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":178,"top_cate":"xls","bg_title":"使用UNIQUE函数 去除重复项"},"channel":1,"app":"et","version":2},{"key":"UPPER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/462.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":73,"show_type":"icon","top_cate":"xls","bg_title":"巧用UPPER函数 一键转换英文大小写"},"channel":1,"app":"","version":1},{"key":"VALUE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/395.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"VALUE函数将 数字文本转换成数值"},"channel":1,"app":"","version":1},{"key":"VAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/362.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":77,"show_type":"icon","top_cate":"xls","bg_title":"VAR函数 计算样本数据的方差"},"channel":1,"app":"","version":1},{"key":"VAR.P","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/372.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"VAR.P函数"},"channel":1,"app":"","version":1},{"key":"VAR.S","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/371.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"VAR.S函数"},"channel":1,"app":"","version":1},{"key":"VARA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/504.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"VARA函数 计算样本方差"},"channel":1,"app":"","version":1},{"key":"VARP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/361.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":76,"show_type":"icon","top_cate":"xls","bg_title":"VARP函数 计算总体样本数据方差"},"channel":1,"app":"","version":1},{"key":"VARPA","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/473.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":44,"show_type":"icon","top_cate":"xls","bg_title":"VARPA函数 计算样本总体方差"},"channel":1,"app":"","version":1},{"key":"VDB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/376.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":68,"show_type":"icon","top_cate":"xls","bg_title":"VDB函数计算 给定期间的折旧值"},"channel":1,"app":"","version":1},{"key":"VLOOKUP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/46.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":103,"show_type":"icon","top_cate":"xls","bg_title":"VLOOKUP函数 查询指定条件的结果"},"channel":1,"app":"","version":1},{"key":"WEEKDAY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/483.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":101,"show_type":"icon","top_cate":"xls","bg_title":"WEEKDAY函数 判断星期几"},"channel":1,"app":"","version":1},{"key":"WEEKNUM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/171.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":96,"show_type":"icon","top_cate":"xls","bg_title":"WEEKNUM函数 计算学期周数"},"channel":1,"app":"","version":1},{"key":"WEIBULL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/494.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":107,"show_type":"icon","top_cate":"xls","bg_title":"WEIBULL函数 快速计算韦布尔分布"},"channel":1,"app":"","version":1},{"key":"WIDECHAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/443.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"WIDECHAR函数 半角字符转全角字符"},"channel":1,"app":"","version":1},{"key":"WORKDAY","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/207.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"WORKDAY函数 统计员工离岗日期"},"channel":1,"app":"","version":1},{"key":"WORKDAY.INTL","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/14094.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"WORKDAY.INTL函数"},"channel":1,"app":"","version":2},{"key":"XIRR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/294.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":59,"show_type":"icon","top_cate":"xls","bg_title":"XIRR函数计算基金收益率"},"channel":1,"app":"","version":1},{"key":"XLOOKUP","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330330.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":551,"top_cate":"xls","bg_title":"XLOOKUP函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"XMATCH","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/330373.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":331,"top_cate":"xls","bg_title":"XMATCH函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"XNPV","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/363.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":81,"show_type":"icon","top_cate":"xls","bg_title":"XNPV函数计算 不定期收益项目净现值"},"channel":1,"app":"","version":1},{"key":"XOR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/378.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"XOR函数"},"channel":1,"app":"","version":1},{"key":"YEAR","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/206.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"巧用YEAR函数 一秒提取年份"},"channel":1,"app":"","version":1},{"key":"YEARFRAC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/268.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":63,"show_type":"icon","top_cate":"xls","bg_title":"YEARFRAC函数 一段日期占全年日期比例"},"channel":1,"app":"","version":1},{"key":"YIELD","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/413.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":115,"show_type":"icon","top_cate":"xls","bg_title":"YIELD函数计算 定期支付利息债券收益率"},"channel":1,"app":"","version":1},{"key":"ZTEST","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/114.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":70,"show_type":"icon","top_cate":"xls","bg_title":"巧用WPS 快速算出ZTEST函数值"},"channel":1,"app":"","version":1}]}