|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-magic-9-building-a-project-tracking-gantt-chart/
课程评论：没有评论
Excel 魔法 9：构建项目跟踪甘特图 本课程分为四个部分，旨在教授如何在 Excel 中从头开始构建项目跟踪甘特图。 **第一部分** 将介绍项目管理中流行的项目跟踪工具——甘特图，并展示如何在 Excel 中快速获取甘特图示例。 **第二部分** 将回顾构建甘特图所需的关键 Excel 基础技能，包括： * `ROUNDDOWN()` 公式 * 条件格式（单元素和多元素） * 下拉列表 **第三部分** 将深入学习如何分步构建甘特图： * 构建基础甘特图 * 构建高级甘特图 * 构建“纯粹”的甘特图 **第四部分** 将介绍两款有助于甘特图数据输入的 Excel 应用： * Excel 365 中的“窗体”功能 * 日历日期选择器 **课程亮点包括：** * 理解甘特图的组成部分 * 掌握单元素和多元素条件格式的设置要点 * 学习构建带有重叠条件格式的高级甘特图 * 探索构建带有重叠条形图的“纯粹”甘特图 * 了解两款实用的 Excel 应用，简化甘特图数据录入 **课程搜索关键词：** 项目跟踪、甘特图、里程碑、任务、负责人、依赖关系、图案样式、边框、数据验证、透明图表、重叠图表、窗体、日历日期选择器。
The course is presented in four parts.First, the course introduces the popular project tracking system in project management - the Gantt Chart, and where we can quickly get a sample of Gantt Chart in Excel.Next, the course will refresh some basic but crucial Excel skills that will help us build a Gantt Chart in Excel. They include:- ROUNDDOWN() formula- Conditional Formatting: both single-element and multi-element conditional formatting- Dropdown listThird, we will learn how to build a Gantt Chart from scratch in three parts:- Building a basic Gantt Chart- Building an advanced Gantt Chart, and- Building a "pure" Gantt ChartLast, we introduce 2 cool Excel apps that will facilitate the data entry of Gantt Chart. They are:- Form in Excel 365, and- Calendar Date PickerCourse Search Keywords- Project tracking- Gantt Chart- Milestones- Tasks- Assignees- Dependents- Pattern style- Border- Data Validation- Transparent chart- Overlapped chart- Form- Calendar Date PickerLearning Objectives● Understand the components of a Gantt Chart● Recognize the basics for setting up both single-element and multi-element conditional formatting● Discover how to build an advanced Gantt Chart with Overlapped Conditional Formatting● Explore how to build a "pure" Gantt Chart with Overlapped Bar Chart● Discover 2 cool apps in Excel that can facilitate data entry into the Gantt Chart
