Consolidate data from multiple revenue sheets
Consolidate data from multiple revenue sheets
Copilot for Excel
Buy now
Learn 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
Preview unavailable
You must log in or sign up to view this lesson.
Login
Sign up
Copilot for Excel
Buy now
Learn 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