Excel for Project Management - Online Training Course - CPDUK Certified
The Mandatory Training Group
Delivery Method: eLearning
Excel for Project Management – Online Training Course - CPDUK Accredited.
Welcome to The Mandatory Training Group's online Excel for Project Management training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Excel for Project Management
Teacher - Christina Tankersley
Learner - Barbara Evers
This online Excel for Project Management training course will teach you to manage your projects entirely in Excel. Christina will train you to use the different tools used for Project Management.
Course content
This online Excel for Project Management training course includes the following:
Unit 1: Project charter
Unit 2: Requirements document or scope
Unit 3: Issues log
Unit 4: Work breakdown structure
Unit 5: Risk register
Unit 6: Communications plan.
Who is the course for?
This online Excel for Project Management training course is suitable for project managers who want to leverage the power of Excel to manage the communication deliverables on your project.
Course aims
This Excel for Project Management eLearning course aims to:
Assist you in realising the need for effective project management
Make you understand the role of excel in running a successful project
Develop an appreciation of the need for effective communication with stakeholders of a project you would be managing
Help you know how to meet the requirements of a project through the effective use of excel.
Learning objectives
On completion of this Excel for Project Management e-learning course, the learner will be able to:
Describe the elements of a Project Charter
Create a drop-down list for data consistency
Identify the best tools for use for project management through excel
Create a pivot table to summarise your task data
Relate requirements to tasks using cross-references
Outline the process to identify and manage project risks
Track stakeholder contact information and their communication needs and preferences.
Learning outcomes
Once you have completed this online Excel for Project Management training course, the learner will be able to:
Manage multiple worksheets within one workbook
Describe parts of a clear and concise requirement
Create summary data at the top of a spreadsheet
Define Work Breakdown Structure (WBS)
Create a dropdown list for data consistency
Identify the different primary deliverables for projects at stake
Filter stakeholder data with slicers to create a project communication plan.