|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-office-suite-2016/
课程评论：没有评论
课程名称：微软办公套件（最新版2021）VBA与宏 课程概述：本课程面向初学者和中级用户，涵盖微软办公套件2016（现更新至2021）的多个主题，包括Word、Excel、PowerPoint、Access和Outlook。课程中将详细介绍Excel中的VBA与宏，并承诺在3-6个月内更新其他软件的VBA使用方法。课程每三个月更新一次，确保内容紧跟最新发展。 **Excel部分：** - 从基础到高级掌握Excel - 理解Excel的常用功能 - 管理大型Excel数据集合 - 创建动态报告（如数据透视表） - 开发Excel中的宏和VBA - 完成4个微型VBA项目 **Word部分：** - 最大化使用微软Word的能力 - 学习创建和格式化Word文档的基础知识 - 制作多样化的版面布局 - 文档打印与导出准备 - 使用样式有效格式化文档 - 创建和管理表格布局、邮件合并及模板管理 - 跟踪和处理文档更改 **PowerPoint部分：** - 创建动画丰富的商务演示文稿 - 提升设计技能与工作效率 - 使用图形和图像减少文本量 - 掌握PowerPoint的高级特性 - 制作组织良好的演示文稿 - 自信地向上级展示，达成职业目标 **Access部分：** - 理解Access的构建及主要对象的使用 - 自信运用Access构建有效的数据库解决方案 - 熟悉Access表格、查询、表单和报告的基本知识 - 创建强大的查询并应用于表格修改 - 理解报告的工作原理及表单和子表单的创建 **Outlook部分：** - 理解Outlook的基础使用 - 创建邮件规则与分组 - 消息格式化与撤回 - 日历管理与会议安排 - 任务创建与联系人管理 本课程适合希望深入掌握Microsoft Office套件的用户，无论是初学者还是有一定基础的使用者，都能从中获得实用的技能提升。
Microsoft Office Suite 2016 for beginners and intermediates.This course(MS Office 2021) covers wide range of topics such as Microsoft Word, Excel, Powerpoint , Access, Outlook Using Microsoft Professional 2016 all in one place.Updated VBA and Macro as promised in Excel. I will update the usage of VBA across all the others as well in 3-6 Months. This course will be updated every 3 months.Excel:Master Microsoft Excel from Beginner to AdvancedBuild a solid understanding on the Basics of Microsoft ExcelLearn the most common Excel functions used in the OfficeMaintain large sets of Excel data in a list or tableCreate dynamic reports by mastering one of the most popular tools, Pivot TablesCreation of Macro and VBA in Excel.4 Mini Project in VBA and Macro.Word:You will learn how to take full advantage of Microsoft WordBegin with the basics of creating Microsoft Word documentsVarious techniques to create dynamic layoutsPreparing documents for printing and exportingFormat documents effectively using Microsoft Word StylesControl page formatting and flow with sections and page breaksCreate and Manage Table LayoutsWork with Tab Stops to Align Content ProperlyPerform Mail Merges to create Mailing Labels and Form LettersBuild and Deliver Word FormsManage TemplatesTrack and Accept/Reject Changes to a DocumentPPT:Create a fully-animated and transition-filled business presentationRapidly improve your workflow and design skillsMinimize text quantity on presentations by using graphs and imagesWork comfortably with PowerPoint and many of its advanced featuresBecome one of the top PowerPoint users in your teamCarrying out regular tasks faster than everCreate sophisticated and well-organized PowerPoint presentationsFeel more confident when delivering presentations to superiorsMake an impression at work and achieve your professional goalsAccess:Understand how Access is constructed and how to use the major objects within it.Be confident in moving around within Access and be able to build effective database solutions for their unique data needs.What you'll learnUnderstand the basics of Access tables, queries, forms and reports.Know how to structure tables being imported from Excel.Know how to create powerful queries and use them to create and modify tables.Understand how reports work and how to base them on tables or queries.Know how to create forms and sub-forms.Outlook:Understand the basic usage of Outlook.How to create rules in Outlook and group the mails.How to format message and recall of message.How to manage your calendar.How to create to meetings and handling the participants.How to create tasks using Outlook.How to create contacts and manage groups in Outlook
