课程背景Microsoft365是由微软公司提供的一套基于云端技术的办公软件解决方案，其中包含Office、Calendar、Teams、OneDrive和SharePoint等多个部分。Microsoft365拥有丰富的功能和工具，为用户提供更加高效、智能、安全的办公环境。通过Microsoft 365，用户可以轻松地处理文档、电子邮件、日程安排、文件共享和协作等方面的工作。本课程旨在为学习者提供全面的Microsoft365培训，帮助学习者学习如何使用Microsoft 365中的主要应用程序，包括Office、Calendar、Teams、OneDrive和SharePoint。课程将涵盖各种主题，包括应用程序的基本操作、高级功能、数据分析和报告，以及协作和沟通工具。Office的部分包括Word、Excel和PPT三个常用的应用程序，本课程将介绍各个程序的基本操作和格式设计、段落和文字处理、大纲和辅助功能、版面设计和排版技巧、单元格格式和公式、统计分析和数据可视化、数据分析和报表、幻灯片设计和制作技巧、视觉效果和动画效果、幻灯片演讲和分享技巧、PPT模板和主题选择等方面内容。Calendar的部分将介绍如何管理Outlook中的日历和联系人、安排约会、会议和事件以及掌握日程安排的其他高级功能，并提供时间规划和生产效率的最佳实践。Teams的部分将介绍如何设置和自定义团队、在Teams和Channels中协作、使用SharePoint LibrariesinTeams、改善团队沟通和协作以及主持Teams会议，同时还将深入介绍Teams和SharePoint的整合概述。OneDrive的部分将介绍如何登录OneDrive、上传和保存文件和文件夹到OneDrive、OneDrive中的文件和文件夹管理以及在OneDrive中进行协作、共享和访问控制，同时提供OneDrive的高级功能和使用外部应用集成OneDrive。SharePoint的部分将介绍如何登录SharePoint、创建和访问SharePoint网站、添加清单或文档库、添加网站成员、共享和协作、版本历史和恢复，以及与OneDrive同步。本课程的目标是提供Microsoft365应用程序基础知识和高级技巧。这些技能有助于提高用户在工作中的生产力、进行更高效的协作和有效的沟通，并帮助用户更好地处理数据和文档。Microsoft365 is a cloud-based office software solution offered by Microsoft Corporation which includes Office, Calendar, Teams, OneDrive, and SharePoint, among others. Microsoft365 provides rich functionality and tools that offer users a more efficient, intelligent, and secure working environment. With Microsoft 365, users can easily deal with documents, email, scheduling, file sharing, and collaboration.This course aims to provide comprehensive Microsoft365 training to learners, helping learners to learn how to use the main applications in Microsoft 365, including Office, Calendar, Teams, OneDrive, and SharePoint. The course will cover various topics, including basic operations of applications, advanced features, data analysis and reporting, and collaboration and communication tools.The Office section includes the three commonly used applications: Word, Excel, and PPT. This course will introduce each program's basic operations and format design, paragraph and text processing, outline and assistive functions, layout design and typesetting skills, cell formatting and formulas, statistical analysis and data visualization, data analysis and reporting, slide design and production skills, visual effects, and animation effects, presentation skills, PPT templates, and theme selection.The Calendar section will introduce how to manage calendars and contacts in Outlook, arrange appointments, meetings, and events, and master other advanced features of scheduling while providing best practices for time planning and productivity.The Teams section will introduce how to set up and customize teams, collaborate in Teams and Channels, use SharePoint Libraries in Teams, improve team communication and collaboration, and host Teams meetings, while providing an overview of Teams and SharePoint integration.The OneDrive section will cover how to sign in to OneDrive, upload and save files and folders to OneDrive, file and folder management in OneDrive, and collaboration, sharing, and access control in OneDrive, while providing advanced features of OneDrive and using external application integrations with OneDrive.The SharePoint section will cover how to log in to SharePoint, create and access SharePoint sites, add lists or document libraries, add site members, collaborate and share, version history and recovery, and synchronization with OneDrive.The goal of this course is to provide foundational knowledge and advanced skills for Microsoft365 applications. These skills help increase user productivity, enable more efficient collaboration and effective communication, and help users better manage data and documents in their work. 课程大纲OfficeWord基本操作格式设计段落和文字处理大纲和辅助功能版面设计和排版技巧Excel基本操作单元格格式和公式统计分析和数据可视化数据分析和报表数据处理和图表制作PPT基本操作幻灯片设计和制作技巧视觉效果和动画效果幻灯片演讲和分享技巧PPT模板和主题选择Outlook管理Outlook中的日历和联系人操作 Outlook 日历查看联系人和组织联系人Outlook 中联系人分组创建任务并设置提醒安排约会、会议和事件Outlook 日历术语介绍安排约会、会议和事件管理日历预约使用日历共享Outlook日历查看和使用Outlook日历查看所有时间表协作功能快速记录事件安排约会创建单个日历约会创建重复约会添加提前提醒追踪响应和确认约会安排会议手动创建会议邀请使用自动会议邀请管理会议邀请和响应确认和取消会议安排 Teams 会议计划 Teams 会议创建 Teams 会议和通话Outlook 日历和 Teams 整合添加 Teams 会议到日历中CalendarOutlook日历概述-了解Outlook日历界面-导航您的日历-自定义日历视图首次设置日程安排创建和编辑个人日历选择和调整日历视图添加和编辑日程安排了解如何使用分类来帮助组织日程日程安排邀请邀请他人参与日程安排和会议规划会议并创建会议安排确定参与者的可用时间发送邀请并管理回复掌握日程安排的其他高级功能创建重复的日程安排和异常日期将其他人拥有的日程安排和会议添加到您的日历中将日程安排导出或导入到其他日历应用程序中为日程安排设置提醒和警报时间规划和生产效率的最佳实践制定时间管理策略阐述时间规划的最佳实践优化日程的时间安排和会议工作流程讨论其他相关的生产效率工具和建议Teams设置和自定义团队创建团队管理团队设置自定义团队外观向团队添加应用程序和功能使用团队模板在Teams和Channels中协作发送消息并了解 chat 和 meeting标记和筛选消息在 channel 内部协作设置 channel （公开或私人）使用SharePoint LibrariesinTeams将 SharePoint site 添加到Teams使用 SharePoint document library in Teams单击即弹出 Teams conversation改善团队沟通和协作使用 Teams 的通讯工具协作工具 (协作编辑，文件共享)版本控制和历史记录整合 Planner or ToDo for task management了解Teams外部邀请主持Teams会议创建 Teams 会议加入和结束 Teams 会议使用会议控制和共享屏幕外部成员访问Teams 和 SharePoint 整合概述将 SharePoint 内容显示在 Teams 中在 Teams中管理 SharePoint文档库和文件中央化和简化管理联合Teams和SharePoint解决方案Onedrive登录OneDrive访问OneDrive登录OneDrive账号OneDrive个人主页上传和保存文件和文件夹到OneDrive上传单个文件批量上传文件和文件夹保存文件到OneDrive自动备份文件OneDrive中的文件和文件夹管理在OneDrive网页中管理文件和文件夹在本地计算机上管理文件和文件夹在移动设备上管理文件和文件夹同步OneDrive文件和文件夹在OneDrive中进行协作在Microsoft Office中编辑文件在Web浏览器中编辑文件视频会议和聊天功能同时编辑文件文件共享和访问控制OneDrive的高级功能版本控制和历史记录自动化任务和流程利用搜索快速查找文件使用外部应用集成 OneDriveOneDrive中的数据分析和报告SharePoint登录SharePoint访问SharePoint网站登录SharePoint网站SharePoint网站主页创建和访问SharePoint网站创建SharePoint网站导航到SharePoint网站删除SharePoint网站访问SharePoint网站使用SharePoint网站添加清单或文档库创建清单或文档库修改清单或文档库删除清单或文档库添加网站成员添加成员删除成员分配权限共享和协作共享文件和链接协作工具版本历史和恢复与OneDrive同步浏览库或列表并选择同步同步文件和文件夹显示同步状态文件离线使用English version outlineMicrosoft OfficeWordBasic operationsFormattingParagraph and text processingOutline and assistive featuresLayout design and typesetting techniquesExcelBasic operationsCell formatting and formulasStatistical analysis and data visualizationData analysis and reportingData processing and chart makingPowerPointBasic operationsSlide design and production techniquesVisual effects and animation effectsSlide presentation and sharing techniquesPPT template and theme selectionOutlookManage calendars and contacts in OutlookOutlook calendar operationView contacts and organize contactsContact grouping in OutlookCreate tasks and set remindersSchedule appointments, meetings, and eventsOutlook calendar terminologyShare calendarsView and use Outlook calendarView all schedulesCollaborative functionalityQuick event recordingCalendarOverview of Outlook calendarUnderstand the Outlook calendar interfaceNavigate your calendarCustomize calendar viewsSet up schedule for the first timeCreate and edit personal calendarSelect and adjust calendar viewsAdd and edit schedulesLearn how to use categories to help organize your scheduleSchedule invitationsInvite others to participate in schedules and meetingsPlan meetings and create schedulingDetermine participants' available timeSend invitations and manage responsesMaster other advanced features of the scheduleCreate repeating schedules and exceptional datesAdd schedules and meetings owned by others to your calendarExport or import schedules to other calendar applicationsSet reminders and alerts for schedulesBest Practices for Time Planning and ProductivityDevelop time management strategiesElaborate on best practices for time planningOptimize schedule timing and meeting workflowDiscuss other related productivity tools and recommendationsTeamsSet up and customize teamsCreate a teamManage team settingsCustomize the appearance of the teamAdd apps and features to the teamUse team templatesCollaborate in Teams and ChannelsSend messages and learn chat and meeting functionsLabel and filter messagesCollaborate within the channelSet up channels (public or private)Use SharePoint Libraries in TeamsAdd a SharePoint site to TeamsUse SharePoint document library in TeamsClick to pop up Teams conversationImprove team communication and collaborationUse Teams communications toolsCollaboration tools (collaborative editing, file sharing)Version control and historyIntegrate Planner or ToDo for task managementLearn Teams external invitationsHost Teams meetingsCreate Teams meetingsJoin and end Teams meetingsUse meeting control and screen sharingExternal member accessOverview of Teams and SharePoint integrationShow SharePoint content in TeamsManage SharePoint document libraries and files in TeamsCentralize and simplify management
羽素