课程介绍
微软MVP亲授，完全从实用出发，教学风格清晰简洁、幽默深刻。 以期让更多的朋友了解/掌握VBA技术！
本课程学习之后将会使您掌握VBA一般语法，理解Excel对象体系，并且能够完成多表格数据汇总/多工作簿数据汇总/自定义函数/一般文本处理/表格格式处理等日常办公需求，并具备深入学习高级VBA技术的能力。
需要参加面授小班，请点击链接http://www.withubtraining.org/kecheng/0676.html
课程目标
- 很多人都知道，VBA是提高Excel工作效率的不二利器。但是大家一想到“程式设计”四个字，就不由得对VBA望而却步。没关系，参加这个学习，你就会发现，原来VBA如此易学、如此实用！只要是经常使用Excel的人士，均可通过本课程轻松掌握VBA。
适合人群
- 经常使用Excel的白领、学生和科研人员。希望继续提高，掌握VBA二次开发技巧。
目录
{
"id": "37",
"isDefault": "1",
"learnMode": "freeMode",
"isMember": "",
"status": "published",
"currentTaskId": ""
}
{
"i18nChapterName": "章",
"i18nUnitName": "节",
"i18nTaskName":"任务"
}
[{"itemType":"chapter","number":"1","title":"\u7b2c\u4e00\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"725","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"1","title":"vba-1","result":"","resultStatus":"","lock":false,"status":"published","taskId":"456","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"26:23","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"2","title":"\u7b2c\u4e8c\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"726","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"2","title":"vba-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"457","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"24:29","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"3","title":"\u7b2c\u4e09\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"727","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"3","title":"vba-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"459","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"19:57","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"4","title":"vba-3-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"460","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:56","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"5","title":"vba-3-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"463","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"06:50","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"6","title":"vba-3-4","result":"","resultStatus":"","lock":false,"status":"published","taskId":"464","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"21:43","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"4","title":"\u7b2c\u56db\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"735","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"7","title":"vba-4","result":"","resultStatus":"","lock":false,"status":"published","taskId":"465","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"44:35","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"5","title":"\u7b2c\u4e94\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"737","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"8","title":"vba-5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"466","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"38:16","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"9","title":"vba-5-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"467","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"18:14","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"10","title":"vba-5-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"468","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:36","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"11","title":"vba-5-4","result":"","resultStatus":"","lock":false,"status":"published","taskId":"469","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"18:13","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"12","title":"vba-5-5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"470","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"15:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"13","title":"vba-5-6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"471","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"12:01","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"6","title":"\u7b2c\u516d\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"744","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"14","title":"vba-6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"472","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"21:16","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"7","title":"\u7b2c\u4e03\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"746","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"15","title":"vba-7","result":"","resultStatus":"","lock":false,"status":"published","taskId":"473","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"30:12","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"16","title":"vba-7-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"474","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"18:03","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"17","title":"vba-7-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"475","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"12:23","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"8","title":"\u7b2c\u516b\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"750","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"18","title":"vba-8","result":"","resultStatus":"","lock":false,"status":"published","taskId":"476","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"47:59","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"19","title":"vba-8-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"477","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"23:21","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"20","title":"vba-8-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"478","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"05:00","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"21","title":"vba-8-4","result":"","resultStatus":"","lock":false,"status":"published","taskId":"479","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"24:27","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"22","title":"vba-8-5","result":"","resultStatus":"","lock":false,"status":"published","taskId":"480","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"08:16","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"23","title":"vba-8-6","result":"","resultStatus":"","lock":false,"status":"published","taskId":"481","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"15:42","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"24","title":"vba-8-7","result":"","resultStatus":"","lock":false,"status":"published","taskId":"482","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"17:55","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"9","title":"\u7b2c\u4e5d\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"758","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"25","title":"vba-9","result":"","resultStatus":"","lock":false,"status":"published","taskId":"483","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"27:18","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"26","title":"vba-9-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"484","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"15:20","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"27","title":"vba-9-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"485","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"15:43","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"10","title":"\u7b2c\u5341\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"762","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"28","title":"vba-10","result":"","resultStatus":"","lock":false,"status":"published","taskId":"486","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"18:54","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"11","title":"\u7b2c\u5341\u4e00\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"764","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"29","title":"vba-11","result":"","resultStatus":"","lock":false,"status":"published","taskId":"487","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"25:13","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"30","title":"vba-11-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"488","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"25:50","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"chapter","number":"12","title":"\u7b2c\u5341\u4e8c\u7ae0","result":"","resultStatus":"","lock":"","status":"published","taskId":"767","isOptional":"0","type":"chapter","isTaskFree":"","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"","activityEndTime":"","fileStorage":"","isTaskTryLookable":""},{"itemType":"task","number":"31","title":"vba-12","result":"","resultStatus":"","lock":false,"status":"published","taskId":"489","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"20:52","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"32","title":"vba-12-2","result":"","resultStatus":"","lock":false,"status":"published","taskId":"490","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"11:43","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0},{"itemType":"task","number":"33","title":"vba-12-3","result":"","resultStatus":"","lock":false,"status":"published","taskId":"491","isOptional":"0","type":"video","isTaskFree":"0","watchLimitRemaining":false,"replayStatus":"","activityStartTimeStr":"","activityStartTime":"","activityLength":"10:10","activityEndTime":"","fileStorage":"cloud","isTaskTryLookable":0}]
{
"text": {
"icon": "es-icon es-icon-graphicclass",
"name": "图文"
}
,
"video": {
"icon": "es-icon es-icon-videoclass",
"name": "视频"
}
,
"audio": {
"icon": "es-icon es-icon-audioclass",
"name": "音频"
}
,
"live": {
"icon": "es-icon es-icon-videocam",
"name": "直播"
}
,
"discuss": {
"icon": "es-icon es-icon-comment",
"name": "讨论"
}
,
"flash": {
"icon": "es-icon es-icon-flashclass",
"name": "Flash"
}
,
"doc": {
"icon": "es-icon es-icon-description",
"name": "文档"
}
,
"ppt": {
"icon": "es-icon es-icon-pptclass",
"name": "PPT"
}
,
"testpaper": {
"icon": "es-icon es-icon-kaoshi",
"name": "考试"
}
,
"homework": {
"icon": "es-icon es-icon-zuoye",
"name": "作业"
}
,
"exercise": {
"icon": "es-icon es-icon-mylibrarybooks",
"name": "练习"
}
,
"download": {
"icon": "es-icon es-icon-filedownload",
"name": "下载资料"
}
}
1652847617
