How to compare two tables for ex. Demand and Supply sheets using Excel Copilot and highlight the difference with Skill type, Primary Skill, Grade and Location being the common columns?

Question

We have a demand sheet of resource requirements and a supply sheet of available profiles, we need to find the deficit for each skill family, Primary Skill, grade and location wise.

for ex.

From Demand Sheet

MS Azure

Azure Security Center 

                           Manager 

                                  Bangalore , the demand is 2 

From Supply Sheet

MS Azure

    Azure Security Center 

                              Manager 

                                  Bangalore , the supply is 1 

The output expected is

Skill type Primary Skill Grade Location

MS Azure Azure Security Center Manager Bangalore

Demand Supply Deficit

2 1 1

Answer 1

To compare two tables, such as Demand and Supply sheets, using Excel Copilot and highlight the differences with Skill type, Primary Skill, Grade, and Location as the common columns, you can follow these steps:

1. Prepare Your Data: Ensure that both the Demand and Supply sheets are formatted as tables in Excel. This will make it easier for Excel Copilot to analyze the data.
2. Open Excel Copilot: In your Excel workbook, go to the Home tab and click on the Copilot button to open the Copilot chat pane.
3. Ask Copilot to Compare Tables: In the Copilot chat pane, type a query like "Compare the Demand and Supply sheets and highlight the differences with Skill type, Primary Skill, Grade, and Location as the common columns."
4. Review the Results: Copilot will analyze the tables and highlight the differences based on the specified columns. It will show you the discrepancies between the Demand and Supply sheets, such as the deficit for each skill family, primary skill, grade, and location

For example, if the Demand sheet shows a requirement for 2 resources with the skill "MS Azure" and the primary skill "Azure Security Center" at the grade "Manager" in "Bangalore," and the Supply sheet shows only 1 resource available with the same criteria, Copilot will highlight this difference.