Project Management Certificate Courses, Northwestern University School of Professional Studies - Northwestern School of Professional Studies

Program Courses

To earn a Certificate in Agile Practices from Northwestern University, students must complete the following courses:

1. Agile for Practitioners Core Course (PROJ_PMI 403-0)
2. Any two Agile or project management electives

Tip: Click on "Add to Cart" to register

To limit our community's exposure to COVID-19, the spring quarter will now commence on April 4. Online courses may have adjusted dates, but will otherwise run as usual. On-campus courses will be conducted remotely until April 27; University leaders will decide by April 17 whether to continue remote teaching or to return to in-person instruction on April 27. Updated information for affected courses can be found in the scheduling notes area under the course description.

PROJ_PMI 225-0 : Power Excel Skills for Project Managers

Description

The Executive Team is counting on you to commit a project completion date. Mistakes will be costly due to penalties if there is any delay. Your project team is counting on you to guide their effort so the critical tasks are identified and prioritized. You are buried in a ton of project information arriving to you daily. How do you collect and organize it? How do you make sense of it? How do you use it to make the best decisions for the project?

From committing to a project completion date based on the organization's risk tolerance to creating compelling reports and charts that can drive actions from your organization to address critical issues to keep your project on track, Excel is one of the best and more flexible tools available for Project Managers to simplify tasks related to managing information and also to help on daily decision making on many levels.

Students will learn advanced excel skills through this hands-on workshop that will help them to create analytical tools, formulas, charts, graphs and macros that will support them on making critical project management decisions. Real-world experiences from project initiation to project completion will be used so students will leave each day of the training with the ability to apply what they have learned in their workplace.

Course Objectives

By the end of the course, participants will be able to:

• Manage risks in project schedules and define confidence levels by building a customized analysis model based on your firm’s probabilities and risk tolerance
• Identify potential issues or showstoppers in data and be able to identify potential risk triggers
• Know the ins and outs of pivot table creation; validate, consolidate, convert, sort and filter your data
• Automate your repeatable processes, using macros to create reports and data analysis charts
• Trace Precedents and Dependents to analyze cascading formulas and troubleshoot spreadsheet issues

Total Professional Development Units (PDUs): 18 (Ways of Working: 12; Business Acumen: 5; Power Skills: 1)

Registered students can access their online course site here. An activated NetID and password is required for login. *Please note: It may take up to 24-hours for registered students to be added to the online course platform.

Additional Information:

This course is intended for students with basic to intermediate knowledge of Microsoft Excel®.

Students are required to have a computer (PC or MAC) with Microsoft Excel® installed since they will complete in-class exercises designed to reinforce concepts learned during the course lecture.

Students may also be eligible to purchase software at discounted rates through Northwestern's agreement with Microsoft.