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

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心