师资力量
兑换中心
文章
VIP会员
App端
师资力量
兑换中心
文章
VIP会员
App端
登录
注册
登录
注册
首页
课程
办公软件
Excel
Excel公式与函数-2【推荐新版】
(0人评价)
Excel公式与函数-2【推荐新版】
价格
¥
60.00
学习有效期
长期有效
承诺服务
练
试
问
疑
音频听课
手机端支持一键听课
(试一试)
已收藏
收藏
分享
扫一扫
扫二维码继续学习 二维码时效为半小时
分享
已收藏
收藏
会员免费学
购买课程
目录
试看
笔记
(86)
评价
(0)
介绍
课程介绍
函数与公式
目录
{getChapterName}
{getUnitName}
{getLessonName}
敬请期待
免费
试看
{getTaskName}
剩余观看时长:{watchLimitRemaining}
回放
{activityStartTimeStr}
正在直播中
直播结束
{activityLength}
预览
试看
购买
免费
试看
{getTaskName}
敬请期待
{ "id": "63", "isDefault": "1", "learnMode": "freeMode", "isMember": "", "status": "published", "currentTaskId": "", "isHideUnpublish": "0" }
{ "i18nChapterName": "章", "i18nUnitName": "节", "i18nLessonName": "课时", "i18nTaskName":"任务" }
[{"itemType":"task","number":"1","published_number":"1","title":"0102-\u516c\u5f0f\u7684\u8f93\u5165\u3001\u7f16\u8f91\u4e0e\u4fee\u6539 \u5404\u79cd\u7f16\u8f91\u72b6\u6001","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2374","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:42","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"2","published_number":"2","title":"0103-\u516c\u5f0f\u590d\u5236\u76845\u79cd\u65b9\u6cd5 \u590d\u5236\u5355\u5143\u683c\u4e0e\u590d\u5236\u5355\u5143\u683c\u5185\u5bb9\u7684\u533a\u522b","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2375","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:18","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"3","published_number":"3","title":"0104-Excel\u7684\u8fd0\u7b97\u7b26\u3001\u8fd0\u7b97\u7b26\u4f18\u5148\u987a\u5e8f\u3001\u5229\u7528\u62ec\u53f7\u6539\u53d8\u8fd0\u7b97\u4f18\u5148\u987a\u5e8f","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2376","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:59","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"4","published_number":"4","title":"0105-\u952e\u76d8\u7b26\u53f7\u7684\u6b63\u786e\u8f93\u5165\u65b9\u5f0f \u4e2d\u6587\u6a21\u5f0f\u4e0e\u82f1\u6587\u6a21\u5f0f \u666e\u901a\u952e\u76d8\u4e0e\u7b14\u8bb0\u672c\u952e\u76d8\u7684\u4e0d\u540c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2377","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:04","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"5","published_number":"5","title":"0106-\u903b\u8f91\u503c\uff08TRUE\u548cFALSE\uff09\u4e0e\u6570\u503c\u7684\u5173\u7cfb\u53ca\u8f6c\u6362","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2378","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:32","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"6","published_number":"6","title":"0107-\u6587\u672c\u578b\u6570\u5b57\u4e0e\u6570\u503c\u578b\u6570\u5b57\u8f6c\u6362 \uff08Excel\u4e2d\u975e\u5e38\u91cd\u8981\u7684\u77e5\u8bc6\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2379","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:06","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"7","published_number":"7","title":"0108-\u628a\u516c\u5f0f\u8f6c\u6210\u503c\uff08Excel\u4e2d\u7684\u91cd\u70b9\u64cd\u4f5c\uff09","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2380","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:49","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"8","published_number":"8","title":"0201-\u4ec0\u4e48\u662f\u5355\u5143\u683c\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2381","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:18","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"9","published_number":"9","title":"0202-\u76f8\u5bf9\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2382","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"07:53","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"10","published_number":"10","title":"0203-\u7edd\u5bf9\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2383","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:45","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"11","published_number":"11","title":"0204-\u6df7\u5408\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2384","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"06:20","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"12","published_number":"12","title":"0205-\u4ec0\u4e48\u65f6\u5019\u7528\u76f8\u5bf9\u5f15\u7528\u3001\u7edd\u5bf9\u5f15\u7528\u3001\u6df7\u5408\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2385","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:51","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"13","published_number":"13","title":"0206-\u8de8\u5de5\u4f5c\u8868\u3001\u5de5\u4f5c\u8584\u5f15\u7528 \u7f16\u8f91\u5916\u90e8\u94fe\u63a5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2386","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:47","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"14","published_number":"14","title":"0207-\u5f15\u7528\u76f8\u540c\u5de5\u4f5c\u8868\u533a\u57df","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2387","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:40","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"15","published_number":"15","title":"0208-\u590d\u5236\u516c\u5f0f\u800c\u4e0d\u53d1\u751f\u76f8\u5bf9\u5f15\u7528\u504f\u79fb\u7684\u65b9\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2388","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:42","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"16","published_number":"16","title":"0301-\u4ec0\u4e48\u662fExcel\u51fd\u6570\u3001\u51fd\u6570\u7684\u7ec4\u6210\u5143\u7d20\u53ca\u8f93\u5165\u89c4\u8303","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2389","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:48","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"17","published_number":"17","title":"0302-\u51fd\u6570\u7684\u8f93\u5165\u65b9\u5f0f","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2390","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"06:38","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"18","published_number":"18","title":"0303-\u51fd\u6570\u53c2\u6570 \u53c2\u6570\u7684\u7b80\u5199\u4e0e\u7701\u7565\u7684\u533a\u522b","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2391","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:56","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"19","published_number":"19","title":"0304-\u51fd\u6570\u7684\u5d4c\u5957 \u601d\u8003\u5206\u6790\u51fd\u6570\u6240\u8981\u89e3\u51b3\u95ee\u9898\u7684\u6b65\u9aa4\u65b9\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2392","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"14:01","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"20","published_number":"20","title":"0305-\u5faa\u73af\u5f15\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2393","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:06","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"21","published_number":"21","title":"0306-\u516c\u5f0f\u51fd\u6570\u7684\u9519\u8bef\u7c7b\u578b\u53ca\u89e3\u51b3\u65b9\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2394","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:03","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"22","published_number":"22","title":"0401-\u540d\u79f0\u7684\u4f7f\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2395","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"07:08","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"23","published_number":"23","title":"0501-Sum\u51fd\u6570\u57fa\u672c\u7528\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2396","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:52","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"24","published_number":"24","title":"0502-\u89e3\u51b3Sum\u51fd\u6570\u4e0d\u80fd\u6c42\u548c\u7684\u95ee\u9898","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2397","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:43","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"25","published_number":"25","title":"0503-\u4f7f\u7528\u5feb\u6377\u952e(Ctrl+=)\u5feb\u901f\u6c42\u548c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2399","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:18","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"26","published_number":"26","title":"0504-Sum\u51fd\u6570\u9ad8\u7ea7\u7528\u6cd5 Sum\u51fd\u6570\u591a\u6761\u4ef6\u6c42\u548c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2398","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:22","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"27","published_number":"27","title":"0505-Sumif\u51fd\u6570\u57fa\u672c\u7528\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2400","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:31","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"28","published_number":"28","title":"0506-\u4f7f\u7528\u901a\u914d\u7b26\u8fdb\u884c\u6761\u4ef6\u6c42\u548c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2401","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"29","published_number":"29","title":"0507-Sumif\u9ad8\u7ea7\u7528\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2402","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:59","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"30","published_number":"30","title":"0508-sumifs\u51fd\u6570\u57fa\u7840\u7528\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2403","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"31","published_number":"31","title":"0509-Sumproduct\u51fd\u6570\u539f\u7406\u8bb2\u89e3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2404","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:01","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"32","published_number":"32","title":"0510-Count-Counta-Countblank\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2405","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:49","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"33","published_number":"33","title":"0511-\u5229\u7528Counta\u667a\u80fd\u6392\u5e8f","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2406","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:12","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"34","published_number":"34","title":"0512-Countif\u5355\u6761\u4ef6\u8ba1\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2407","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:49","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"35","published_number":"35","title":"0513-Countifs\u591a\u6761\u4ef6\u8ba1\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2408","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"36","published_number":"36","title":"0514-average-averageif-averageifs\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2409","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:33","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"37","published_number":"37","title":"0515-Product\u8ba1\u7b97\u6570\u5b57\u7684\u4e58\u79ef","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2410","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:06","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"38","published_number":"38","title":"0516-Frequency","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2411","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:23","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"39","published_number":"39","title":"0517-Max\u6700\u5927\u503c\u3001Min\u6700\u5c0f\u503c\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2412","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:47","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"40","published_number":"40","title":"0518-Large-Small\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2413","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:01","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"41","published_number":"41","title":"0601-Round\u56db\u820d\u4e94\u5165\u51fd\u6570 \u53bb\u6389\u91d1\u989d\u4e2d1\u5206\u94b1\u7684\u8bef\u5dee","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2414","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:15","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"42","published_number":"42","title":"0602-Rounddown\u5411\u4e0b\u820d\u5165\u3001Roundup\u5411\u4e0b\u820d\u5165\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2415","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:50","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"43","published_number":"43","title":"0603-Int\u3001Trunc\u53d6\u6574\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2416","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:43","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"44","published_number":"44","title":"0604-Rand\u3001Randbetween\u751f\u6210\u968f\u673a\u6570\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2417","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:02","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"45","published_number":"45","title":"0605-Mod\u53d6\u4f59\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2418","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"46","published_number":"46","title":"0606-Quotient\u53d6\u6574\u7684\u6574\u6570\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2419","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"00:51","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"47","published_number":"47","title":"0701-\u65e5\u671f\u4e0e\u65f6\u95f4\u672c\u8d28\u53ca\u8ba1\u7b97\u539f\u7406","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2420","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"07:06","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"48","published_number":"48","title":"0702-\u63d0\u53d6\u65e5\u671f\u4e0e\u65f6\u95f4\u503c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2421","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:56","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"49","published_number":"49","title":"0703-Weekday\u661f\u671f\u51fd\u6570\u3001Weeknum\u5468\u6570\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2422","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:34","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"50","published_number":"50","title":"0704-Networkdays-Workday\u5de5\u4f5c\u65e5\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2423","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"51","published_number":"51","title":"0705-Eomonth\u3001Edate\u8ba1\u7b97\u6708\u4efd\u65e5\u671f","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2424","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:34","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"52","published_number":"52","title":"0706-Datedif\u8ba1\u7b97\u4e24\u65e5\u671f\u95f4\u9694\u7684\u5e74\u6708\u65e5\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2425","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:38","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"53","published_number":"53","title":"0801-Row\u3001Rows\u3001Column\u3001Columns\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2426","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"07:02","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"54","published_number":"54","title":"0802-indirect\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2427","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"55","published_number":"55","title":"0803-choose\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2428","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:25","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"56","published_number":"56","title":"0804-Vlookup\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2429","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:37","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"57","published_number":"57","title":"0805-Vlookup\u9519\u8bef\u60c5\u5f62","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2430","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:19","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"58","published_number":"58","title":"0806-Vlookup\u7684\u5d4c\u5957\u4f7f\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2431","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"59","published_number":"59","title":"0807-Hlookup\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2432","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:29","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"60","published_number":"60","title":"0808-lookup\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2433","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"61","published_number":"61","title":"0809-Match\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2434","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:21","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"62","published_number":"62","title":"0101-\u516c\u5f0f\u4e0e\u51fd\u6570\u4ecb\u7ecd\u3001\u516c\u5f0f\u4e0e\u51fd\u6570\u7684\u91cd\u8981\u6027","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2373","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:56","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"63","published_number":"63","title":"0810-index\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2435","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:13","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"64","published_number":"64","title":"0811-Index\u4e0eMatch\u51fd\u6570\u7684\u5d4c\u5957\u4f7f\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2436","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:17","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"65","published_number":"65","title":"0812-offset\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2437","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:25","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"66","published_number":"66","title":"0901-\u8ba4\u8bc6\u903b\u8f91\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2438","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:29","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"67","published_number":"67","title":"0902-And-Or-Not\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2439","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:47","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"68","published_number":"68","title":"0903-IF\u4e0eAnd-Or\u51fd\u6570\u7684\u5d4c\u5957\u4f7f\u7528","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2440","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:37","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"69","published_number":"69","title":"0904-\u5229\u7528IF\u51fd\u6570\u6267\u884c\u591a\u91cd\u903b\u8f91\u5224\u65ad","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2441","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:59","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"70","published_number":"70","title":"0905-Is\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2442","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"04:47","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"71","published_number":"71","title":"0906-\u5229\u7528Iferror\u51fd\u6570\u5c4f\u853d\u9519\u8bef\u503c","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2443","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:12","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"72","published_number":"72","title":"1001-\u6587\u672c\u578b\u51fd\u6570\u4e0e\u6570\u503c\u578b\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2444","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"73","published_number":"73","title":"1002-\u7a7a\u6587\u672c\u4e0e\u7a7a\u5355\u5143\u683c\u7684\u533a\u522b","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2445","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:41","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"74","published_number":"74","title":"1003-\u8fde\u63a5\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2446","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:31","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"75","published_number":"75","title":"1004-char-code\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2447","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:58","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"76","published_number":"76","title":"1005-exact","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2448","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"00:55","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"77","published_number":"77","title":"1006-len-lenb","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2449","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:35","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"78","published_number":"78","title":"1007-upper-lower","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2450","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"01:23","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"79","published_number":"79","title":"1008-left-right\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2451","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:39","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"80","published_number":"80","title":"1009-mid\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2452","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:42","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"81","published_number":"81","title":"1010-find-search\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2453","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"03:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"82","published_number":"82","title":"1011-\u66ff\u6362\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2454","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:51","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"83","published_number":"83","title":"1012-text\u51fd\u6570","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2455","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"02:47","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0,"isSingleTaskLesson":true},{"itemType":"task","number":"84","published_number":"84","title":"\u51fd\u6570\u7ec3\u4e60\u6587\u4ef6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"2663","isOptional":"0","type":"download","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":0,"isSingleTaskLesson":true}]
{ "text": { "icon": "es-icon es-icon-graphic", "name": "图文" } , "video": { "icon": "es-icon es-icon-video", "name": "视频" } , "audio": { "icon": "es-icon es-icon-audio", "name": "音频" } , "live": { "icon": "es-icon es-icon-entry-live", "name": "直播" } , "discuss": { "icon": "es-icon es-icon-discuss", "name": "讨论" } , "flash": { "icon": "es-icon es-icon-flash", "name": "Flash" } , "doc": { "icon": "es-icon es-icon-document", "name": "文档" } , "ppt": { "icon": "es-icon es-icon-ppt", "name": "PPT" } , "testpaper": { "icon": "es-icon es-icon-examination", "name": "考试" } , "homework": { "icon": "es-icon es-icon-task", "name": "作业" } , "exercise": { "icon": "es-icon es-icon-exercise", "name": "练习" } , "download": { "icon": "es-icon es-icon-downloadfile", "name": "下载资料" } }
1618124908
查看全部
授课教师
刘伟
则秀管理员
课程特色
视频(83)
下载资料(1)
最新学员
学员动态
从容淡定
开始学习
0104-Excel的运算符、...
从容淡定
完成了
0103-公式复制的5种方法 ...
从容淡定
开始学习
0103-公式复制的5种方法 ...
从容淡定
完成了
0102-公式的输入、编辑与修...
从容淡定
开始学习
0102-公式的输入、编辑与修...