You can automate your Excel data processing by using it for free.
With just one prompt I have:
→ Generated the macro
→ Sorted the data
→ Automatically calculated important values
Steps and template below:
1. Activate “Think Deeper"
Open Copilot (copilot .microsoft .com) and click on the Think Deeper icon in the text field.
(You can also use the Copilot in Windows 11).
2. Use this prompt template
Prompt:
You're an expert in data processing and writing Excel macros. Using the sample data below from an xlsx file, write a macro that sorts the rows in descending “Profit” order and calculates the average of the “Sales”, “Gross Sales” and “Profit” columns.