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.
So a friendly reminder that OpenAI has released a guide to writing prompts for them.
Few important points and example:
The most important thing is to use delimiters, for example XML tags that look like this:
<context>
Your text...
</context>
You should also nest tags, for example: <outer><inner></inner></outer>
A concrete example below:
Prompt example:
I'm building a simple Python calculator application. It's a command-line interface (CLI) application for now, focusing on basic arithmetic operations. I'm using standard Python libraries and haven't implemented any complex error handling or UI yet.
When I perform a simple addition, like '2 + 2', the calculator sometimes returns '5' instead of '4'. This doesn't happen consistently, but it's reproducible after a few calculations. It seems to be more frequent after performing a division operation.
Identify the cause of this incorrect addition result and ensure that basic arithmetic operations, specifically addition, always return the correct value. I need to find the bug in my logic that's causing this intermittent incorrect calculation, possibly after a division.
Google has just launched an AI feature capable of planning, reasoning and searching the web.
All this is done in a single prompt using Deep Research.
This is literally the first reasoning model that has access to the internet. Game-changer.
How to use it below 🧵
1. Select model
Open Gemini Advanced and select “Deep Research” from the list at the top.
Then type your prompt. Example:
“Research all the possibilities for running a small AI model (LLM/SLM) locally on a Chromebook, without an internet connection.”
2. Edit the plan
You can adapt the plan before launching the research.
Just ask Gemini to delete, add, or modify steps. E.g:
“Add a step after the 3rd one: “Find out if it is possible to install an Android app on a Chromebook and run AI models locally within that environment”.