Prepare a Project Management Dashboard based on your PMP – Visualize each KPIs and Metrics

Prepare a Project Management Dashboard based on your PMP – Visualize each KPIs and Metrics

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

Copilot for Excel

Buy nowLearn more

Module 1: Getting Started with Copilot in Excel

  • How to Purchase and activate copilot in 5minutes
  • Enabling Copilot in Excel
  • User interface walkthrough: Copilot pane, chat, and suggestions

Module 2: Excel Essentials with Copilot

  • Introducing Agent Mode in Microsoft Excel
  • Getting Started with XLookup and VLookup in Microsoft Excel with copilot
  • Work with a Project Management Plan – Using App Skills

Module 3: Data Analysis & Visualization

  • Prepare a Project Management Dashboard based on your PMP – Visualize each KPIs and Metrics
  • Produce Ratios from a Balance Sheet
  • Generate Visual Insights on this Balance sheet
  • Revenue Analysis – Visualize data
  • Consolidate data from multiple revenue sheets

Module 4: Predictive Analytics

  • Predict Revenue using Machine Learning Models
  • Use machine learning with Copilot Chat to predict cost and schedule overruns from a Project Management Plan (PMP)

Module 5: Risk Management

  • Perform Qualitative Risk Analysis
  • Produce Heat Maps using Python
  • Apply Decision Tree Modelling on Risk Analysis
  • Generate Mitigation Strategies for Identified Risks

Module 6: Advanced Insights

  • Perform Sentiment Analysis Based on a Survey