413 PM courses in Liverpool delivered Live Online

Use some of the hidden statistical analysis tools within Excel to build complex data models. Course overview Duration: 1 day (6.5 hours) This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used. This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths. Objectives By the end of the course you will be able to: Use Goal Seek Create and view scenarios Use Forecast Sheet Create single and double input data tables Create models using the solver Install and use the Analysis Toolpak Create and use array formulas Use a range of advanced Financial and Statistical Excel functions Content Using what if analysis options Using Goal Seek Creating, saving and viewing scenarios Generating a Forecast sheet Solver Creating models Projecting scenarios with Solver Using data tables Creating single input data tables Creating double input data tables Projecting with data tables Financial functions PMT FV NPV Analysing data with Analysis ToolPak Installing the Analysis Toolpak Generating statistical analysis Visualising data using Histograms Array formulas Using embedded Excel Array formulas Create an Array formula Multi and single cell Array formula Using TRANSPOSE to flip rows or columns Use the FREQUENCY Function Use an array to count unique entries in a range Dynamic arrays Spilling data Using the new dynamic array functions Advance functions in formulas Statistical functions:MEAN, MEDIAN and MODERANKLARGE and SMALLMODPERCENTILE Use the AGGREGATE function to sum data in ranges with errors

Duration 4 Days 24 CPD hours This course is intended for This course is for people who have on the job experience doing project management activities and running projects, regardless of their job title. It is for those who wish to become certified project managers, or those that want to build or reinforce a foundation in project management. This course is ideal for a person who wants to grow and formalize their project management skills on an industry neutral, global standard, the Project Management Institute. Overview After completing this course, students will be able to: Demonstrate an understanding of the various project life cycles and processes. Distinguish between predictive and adaptive approaches. Demonstrate an understanding of project management planning. Demonstrate an understanding of project roles and responsibilities. Explain the importance of the role the project manager plays. Determine how to follow and execute and respond to planned strategies or frameworks (e.g., communication, risks, etc.). Demonstrate an understanding of common problem-solving tools and techniques. Identify the suitability of a predictive, plan-based approach for the organizational structure (e.g., virtual, colocation, matrix structure, hierarchical, etc.). Determine and give examples of the activities within each process. Demonstrate an understanding of a project management plan schedule. Determine how to document project controls of predictive, plan-based projects. Explain when it is appropriate and sustainable to use an adaptive approach for the organizational structure. Compare the pros and cons of adaptive and predictive, plan-based projects. Identify the suitability of adaptive approaches for the organizational structure (e.g., virtual, colocation, matrix structure, hierarchical, etc.). Identify organizational process assets and environmental factors that facilitate the use of adaptive approaches. Determine how to plan project iterations. Determine how to document project controls for an adaptive project. Distinguish between the components of different adaptive methodologies (e.g., Scrum, Extreme Programming (XP), Scaled Adaptive Framework (SAFe), Kanban, etc.). Determine how to prepare and execute task management steps. Demonstrate an understanding of business analysis (BA) roles and responsibilities. Demonstrate the importance of communication for a business analyst between various teams and stakeholders. Determine how to gather requirements and using the best approach for a situation. Explain the application of a product roadmap. Determine how project methodologies influence business analysis processes. Validate requirements through product delivery. Every career in project management has a beginning and that is the purpose of this course. You will learn the fundamentals of project management. This includes project performance, when to use the predictive or adaptive methodologies, business analysis domains, and frameworks, as well as the proper use of one of the various adaptive frameworks. Every career in project management has a beginning and that is the purpose of this course. You will learn the fundamentals of project management. This includes project performance, when to use the predictive or adaptive methodologies, business analysis domains, and frameworks, as well as the proper use of one of the various adaptive frameworks.

Success = Value + People + Process With innovation happening more than ever, the new agile project economy requires more and more people across organisations to manage projects successfully, leading to many of us quietly slipping into the role of the unofficial project manager! The problem is very few people receive formal training on how to do it. Stakeholders, scope creep, limited training, and a lack of process all combine to raise the probability of project failure costing organisations time, money, and employee morale Is it any wonder 65% of all projects fail* each year! The good news is—unofficial project managers can build confidence to lead high-value projects and engage teams in a way that inspires them to volunteer their best efforts. Source: *Nieto-Rodriguez, A. (2021). “The Project Economy Has Arrived.” Harvard Business Review; Nov/Dec 21. Outcomes Project Management for the Unofficial Project Manager™ combines best practices from agile and waterfall project management to equip learners with the mindset, skillset, and toolset to engage and inspire team members. Success starts with the core agile principle of value—a project must deliver value to Noble! Once value is established, it is people who make projects successful through a consistent process. Project management isn’t just about managing logistics and hoping the project team is ready to play to win. The skills of “informal authority” are more important than ever before, so team members are inspired to contribute to project success! This course will help learners: Build strong informal authority that inspires project teams to consistently volunteer their best efforts. Utilise a consistent process to start and finish high-value projects on time and with quality. Influence and engage others to define a clear project scope, including clear deliverables and risk strategies. Model openness and agility to apply proactive change management and deliver high-value projects. Project Management Framework The Project Management Framework guides you through five distinct elements in the life of any project. Coupled with the foundational behaviours taught in the programme, this framework can help you deliver highly successful projects again and again. Who Should Attend? This programme is for anyone who finds themselves leading projects at work, regardless of whether or not their job title says, Project Manager! It is NOT a deep dive into project management processes, nor is it a qualification based programme. Whilst it would be helpful to either be involved in or to be leading a project, during the programme, this is clearly not essential. However, it is advisable that the participants have had some experience, whether as a project member or as the person who is leading the project (officially or not)! Project Management Institute (PMI) FranklinCovey is a member of the Project Management Institute (PMI) Authorised Training Partners (ATP) Programme and this course has been designed to satisfy the project management education requirement for PMI Certifications as well as Professional Development Education units (PDUs) needed by PMI credential holders.