Microsoft Excel for Project Management - Earn 5 PDUs
What you'll learn
- Design reports for your stakeholders
- Create a dashboard with some common project management requirements
- Improve project communications with charts
- Format, change, and edit charts
- Apply conditional formatting to save time and automate reporting
- Implement the Microsoft Excel Camera Tool
- Create a speedometer chart for reporting
- Claim five (5) Professional Development Units with PMI
Requirements
- Basics of project management
- Basics of Microsoft Excel
Description
It’s been said that project management is 90 percent communication – and it can certainly feel that way when you consider all of the people you have to communicate with everyday. Well, did you know that you can use Microsoft Excel to help you communicate more effectively, define your project charter, build out the project scope, and even the work breakdown structure? You sure can!
It’s paramount that project managers work with the project team to plan and define the project scope. Then, when the team is executing the project work, the project manager needs to monitor and control the work. Part of monitoring and controlling is to record what’s happening in the project. Based on this work performance data, you’ll process the project’s successes (and possibly failures) and report to the project stakeholders accordingly.
Microsoft Excel can help you with so much of that! In this course we’re going to explore lots of things that Microsoft Excel can do for project management. We’ll dive into formatting, charting, conditional formatting, and building a custom dashboard and report. If you don’t have a more advanced project management software, that’s okay, you can do much of that business right in Microsoft Excel.
This course is worth five (5) Professional Development Units with the Project Management Institute. Take this course at your leisure, learn more about Microsoft Excel and project management, keep your PMI certification going, and most importantly, manage your projects with better control and communication.
Who this course is for:
- Project managers
- PMPs
- People learning Microsoft Excel for reporting
- New and experienced project managers
- Project team members responsible for reporting
- Don't take this course if you're new to Excel
Course content
Instructor
Joseph Phillips has more than 15 years’ experience as a project management consultant, educator, technology consultant, business owner, and technical writer. He has consulted as a project manager for a range of businesses, including startups, hospitals, architectural firms, and manufacturers. Joseph is passionate about helping students pass the PMP certification exam. He has created and led both in-person and web-based seminars on project management, PMP certification, IT project management, program management, writing, business analysis, technical writing, and related topics. Joseph has written, co-authored, or served as technical editor to more than 35 books on technology, careers, project management, and goal setting for MacMillan, McGraw-Hill, Pearson Education, and AMA Press.
Certifications:
Project Management Professional (PMP)
PMI-Agile Certified Practitioner (PMI-ACP)
CompTIA Project+ Professional
CompTIA Certified Technical Trainer+
Certified ITIL Foundations Professional
Professional Scrum Master I
Author of:
PMP Project Management Professional Study Guide, McGraw-Hill
CAPM/PMP All-in-One Exam Guide, McGraw-Hill
PMI-ACP All-in-One Exam Guide, McGraw-Hill
PMP Project Management Lab Book, McGraw-Hill
The Certified Technical Trainer All-in-One Exam Guide, McGraw-Hill
IT Project Management: On Track from Start to Finish, McGraw-Hill
Project Management for Small Business, American Management Association
Software Project Management for Dummies, For Dummies Publisher
The Lifelong Project, Amazon CreateSpace
Vampire Management: Why Your Job Sucks, Amazon CreateSpace