|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel101-newprojectmanager/
课程评论：没有评论
**课程名称：** 微软Excel 2010新任项目经理指南 **课程概述：** 本课程旨在为刚入门的项目经理提供Excel 2010的实用性介绍，帮助您更有效地管理和呈现项目信息。即使是经验丰富的项目经理，也能从中获取有用的技巧. Excel作为一款强大的工具，虽然不具备专业的项目管理软件的全部功能，但足以满足大多数项目管理需求。本课程将从基础知识入手，让您充分了解Excel的强大功能，并轻松上手。 **课程内容亮点：** * **Excel 2010用户界面探索：** 熟悉功能区、后台视图、快速访问工具栏等核心组件。 * **工作簿与工作表基础：** 掌握单元格、列、行的基本操作。 * **视图与窗口管理：** 学习使用冻结窗格和拆分窗格等功能优化视图。 * **公式与函数入门：** 了解创建公式和使用常用函数的方法。 * **数据管理与分析：** 学习使用列表、筛选器以及表格功能。 * **图表制作与美化：** 掌握创建各种图表（包括甘特图、帕累托图和时间线图）的技巧，并了解格式设置、样式和文本格式的应用。 * **打印设置与快捷键：** 提升工作效率的打印技巧和键盘快捷键。 **学习目标：** 学完本课程后，您将能够熟练使用Excel进行项目管理，并能够创建基础的项目管理图表，从而自信地应对项目中的信息管理和呈现挑战。
Welcome to the Excel 2010 for the New Project Manager course! This course is meant to be a short but information rich introduction to learn how to use Excel as a new project manager. And if you are an experienced project manager, you may also pick up some tips that could help with your individual projects, but think of it as a primer of Excel for Project Management. You may be running projects that require something to help manage or present information and usually a common tool is Microsoft Excel. Though it may not have the features of Project Management specific software, Excel is robust enough to use for project management. However you may find that once you understand what Excel can do, you'll find out it is a very powerful tool that will probably do the majority of what you want. You just need to figure out how to use it. To really understand Excel you should probably start with the basics (and there is a lot to learn!). This course is a lecture only format that gives just enough information to get you started to feel comfortable using Excel to run projects. This course will cover the following: Explore the Excel 2010 User Interface Understanding the Ribbon A Look at the Backstage view Quick Access Toolbar (QAT) Workbook and Worksheet Basics Primer to Cells, Columns and Rows Exploring different views using Freeze Panes and Split Panes How to Create Formulas and use Functions Using Lists Filters How the Table Feature Works Basics of Charting Formatting Charts Using Styles and Text Formatting Tips on Printing Keyboard Shortcuts How to Create a Gantt Chart How to Create a Pareto Chart How to Create a Timeline Chart There are a lot of things you can do with Excel and this course should give you the tools to really understand how it works. By the end of the course you should feel familiar with using Excel and may also be able to create some charts that you may see in your work.
