Create a Project Management Tracker using Microsoft Excel

提供方
Coursera Project Network
在此指导项目中,您将:

C​reate a new workbook in Microsoft Excel and share the document with others.

Design and organize the project management tracker using formatting tools in Microsoft Excel.

A​dd content to the project tracking spreadsheet with dropdown lists and conditional formatting.

Clock2 hours
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

As a small business owner, budgets are often tight for the "extras." Often times, this means that some of those high-value marketing tools cannot be offered. Small business owners should turn to free or low-cost alternatives. An easy-to-use and manageable alternative is a free online version of Microsoft Excel from Microsoft Office 365. In this project, you will learn how to create a simple project management tracking sheet. At the end of this project, you will have the Excel project management tracking template for the next presentation of your development project.

您要培养的技能

  • Project Management
  • Spreadsheet
  • Project Planning

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Log into Microsoft Excel Online and open a blank spreadsheet.

  2. Share a document in Microsoft Excel and organize the sections of the tracker

  3. Use project management skills to develop a project tracking spreadsheet.

  4. Add static content and drop-down menus to the project tracker

  5. Add conditional formatting and hyperlinks to the project tracker

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心