Excel for Project Management

Excel for Project Management

# of Lessons

6

Duration

0:50:53

Skill Level

Basic

MSRP

$30

Instructor(s)

Christina Tankersley

Available Captions

English, Spanish

Also Included

Handout, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

Manage a project from Project Charter and Requirements through Task Management and Stakeholder Communication—all within Excel Many different tools can be used for Project Management, but Excel has the power to cover your Project Management needs. You already have Excel on your computer so instead of purchasing a new software and taking the time to learn how to use it; you can leverage the power of Excel to manage the communication deliverables on your project. The primary deliverables for most projects include a Project Charter, a Requirements Document, an Issues Log, a Work Breakdown Structure, a Risk Register, and a Communications Plan. In this course, Microsoft Certified Trainer, Christina Tankersley, walks you through creating each of these from scratch and catering them to the needs of your project. When all the information about your project is inside one workbook, you can answer any question, and you will always know where to track a new piece of information. Topics covered include:

  • Linking fields for data consistency and efficiency
  • Using Excel tables for formatting and filtering
  • Creating a dropdown list for data consistency
  • Adding conditional formatting or icons to highlight important information
  • Cross-referencing requirements to tasks
  • Using risk probability and impact to prioritize risk response

 Using slicers to quickly create a communications plan based on stakeholder contact information and communication needs. High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

Course Contents:

# Lesson Length
1 Project Charter 8:04
2 Requirements Document / Scope 9:23
3 Issues Log 6:03
4 Work Breakdown Structure 9:22
5 Risk Register 11:51
6 Communications Plan 6:10

Related Course Recommendations:

Project Management Fundamentals
Mastering Microsoft Project Part 1 - Creating a Project (2016)
Mastering Microsoft Project Part 2 - Managing a Project (2016)

Catalog Request

Login Logo