PLANIFICACION Y CONTROL DE PROYECTOS CON MS PROJECT Y EXCEL

Project Management Essentials: Plan, Execute & Control with PMI® & Microsoft Tools

Master the art of project planning and execution with this comprehensive course designed to equip you with the skills to deliver projects successfully. Learn to systematically manage project processes, allocate resources effectively, and achieve your project goals using industry-standard methodologies and powerful software.

Who Should Attend?

This course is ideal for any professional involved in project development, regardless of their role. Whether you're a project manager, team member, or aspiring leader, you'll gain valuable insights and practical skills.

Course Objectives:

Upon completion of this course, you will be able to:

• Understand Project Fundamentals: Gain a clear, objective understanding of what constitutes a project, grounded in PMI® guidelines.
• Master Microsoft Project 2016, Excel 2016 & Visio: Develop proficiency in using these essential tools for project organization and management. Become familiar with key project terminology including tasks, resources, Work Packages, WBS (Work Breakdown Structure), Deliverables, and Critical Path.
• Create Project Schedules: Effectively manage task calendars and build a robust work structure from individual tasks.
• Reporting & Data Visualization: Utilize Excel and Visio to create insightful reports for stakeholders.
• Power BI Dashboards: Build interactive project dashboards using Power BI for Excel to monitor project performance.

Course Content:

This course covers a wide range of topics essential for effective project management.

• Introduction to Project Management:
  • Core concepts of project management.
  • PMI® framework and the PMBOK® Guide (6th Edition).
  • Understanding the relationship between projects and organizational goals.
  • Project processes and knowledge areas according to the latest PMBOK® Guide.
• Project Initiation:
  • Creating a compelling Project Charter.
• Microsoft Project 2016 Essentials:
  • Setting up a new project.
  • Defining a project calendar.
• Scope Management:
  • Understanding the Work Breakdown Structure (WBS).
  • Defining Deliverables and Work Packages.
  • Creating a detailed WBS using WBS Schedule Pro.
  • Implementing the WBS in Microsoft Project 2016 and Visio.
  • Task types and the Work Breakdown Structure Dictionary.
  • Detailed task definition and breakdown.
• Schedule Development:
  • Creating a realistic project schedule.
  • Task sequencing using the PDME methodology.
  • Estimating resource and time requirements.
  • Managing resource costs and constraints.
  • Understanding task dependencies and the critical path.
  • CPM (Critical Path Method) calculations.
  • Resource leveling techniques.
• Cost & Budget Management:
  • Project cost management principles.
  • Entering and managing project costs.
  • Understanding different rate types and resource usage profiles.
  • Analyzing cost variances.
  • Budget management and cost rate tables.
  • Generating project cost reports in Microsoft Project and Excel.
  • Multi-currency budgeting.
• Monitoring & Control:
  • Establishing a project baseline.
  • Tracking project progress and updating the schedule.
  • Calculating Earned Value Management (EVM) metrics.
  • Understanding EVM indicators.
  • Generating progress reports using Project 2016 and Power BI for Excel.
• Change Management & Replanning:
  • Analyzing project variances.
  • Implementing change control processes.
  • Replanning project schedules in response to changes.
• Advanced Project Management Techniques:
  • Views, Filters & Reports in MS Project.
  • Advanced filtering, sorting, and grouping techniques.
  • Customizing views and fields.
  • Formatting and printing reports.
  • Managing multiple projects and shared resources.

Get ready to take your project management skills to the next level!