Microsoft Copilot is integrated into Excel and makes it possible to generate formulas, create charts, summarize tables, and detect patterns using natural language, without knowing macros or programming. It is activated through Microsoft 365 Copilot, available in Argentina with a monthly subscription. The most common use cases are finance, marketing, and operations, and there are accessible alternatives for those who don't have access to the full license.

Excel remains the most used data analysis tool in companies in Argentina and LATAM, and it probably will be for a long time. But now it has integrated AI: Microsoft Copilot came to Excel so that anyone can analyze data without knowing how to write a complex formula or build a pivot table from scratch. The problem is that most users don't know it exists or don't know how to use it. This guide explains exactly what Copilot can do in Excel, how to activate it from Argentina, and which use cases are the most useful for your everyday work.

What Copilot can do in Excel

Copilot in Excel is designed for people who need to get insights from data without being analysts. According to TechCrunch, Microsoft expanded Copilot to smaller-scale plans precisely because the demand for accessible AI in productivity grew massively among mid-sized companies and non-technical teams. These are its main features:

• Generate formulas in natural language: you describe what you want to calculate in Spanish and Copilot writes the formula. For example: "calculate the average sales of the last 3 months excluding the highest value" → it generates the correct formula automatically.

• Create charts automatically: you select a range of data and ask it for a chart of the type you need. Copilot chooses the most suitable format and inserts it into your sheet.

• Summarize complex tables: if you have a table with hundreds of rows, you can ask it to identify trends, outliers, or compare columns.

• Detect patterns: it analyzes your data and suggests insights you might not have seen at a glance, like correlations between variables or periods with unusual spikes.

• Answer questions about your data: you can ask it directly "which month had the most sales?" and it responds with the data from your sheet.

How to activate Copilot in Excel from Argentina

To use Copilot in Excel you need:

1. A Microsoft 365 Copilot license: available as an add-on for Microsoft 365 Business Basic, Standard, or Premium plans. The cost is approximately USD 30 per user per month.

2. Updated Excel: make sure you have the most recent version of Microsoft 365 installed.

3. Activation: once you have the license, the Copilot button appears automatically in the Excel toolbar.

4. From Argentina: the purchase can be made directly from microsoft.com/es-ar with a local credit or debit card.

💡 If your company already has Microsoft 365, check with the IT administrator whether Copilot is available in your license before contracting a new one.

Practical use cases by area

The advantage of Copilot in Excel is not only in doing things faster, but in lowering the technical barrier so that non-analytical profiles can work with data autonomously. These are the most concrete cases by area:

Finance and administration

• Generate cash flow projections from historical data with a simple prompt.

• Identify expenses that exceed the monthly budget in seconds.

• Create month-to-month variance reports without building formulas manually.

• Detect anomalies in billing or payments that could go unnoticed in large tables.

Marketing and sales

• Analyze campaign performance by comparing metrics across multiple sheets.

• Calculate the CAC (Customer Acquisition Cost) and ROAS automatically.

• Identify the products or services with the best margin in a few clicks.

• Generate quick visualizations of campaign data for presentations without depending on the data team.

Operations

• Summarize inventories and detect items with critical stock.

• Compare delivery times between suppliers.

• Generate productivity reports by team or period.

• Automate the tracking of operational KPIs with tables that update and analyze themselves.

If you want to see how to combine Excel with other automation tools, review this article about automation with AI in CoderLibrary.

Free alternatives if you don't have Microsoft 365 Copilot

Not all teams in Argentina have access to Microsoft 365 Copilot. The cost per user can be a real barrier for small companies or freelancers. According to data from Statista, AI adoption in the workplace grew significantly but cost remains the main obstacle for SMEs in emerging markets. These are the main alternatives:

• Google Sheets + Gemini: Google integrated Gemini into Sheets progressively. It makes it possible to make natural language queries about your data. See more about Gemini in Google Sheets.

• Basic Excel + ChatGPT: you can copy fragments of your table into ChatGPT and ask it to generate formulas or analyze the data. It's not native, but it works well for one-off queries.

• Power BI with AI: for more complex enterprise-level analysis, Microsoft offers options with AI that don't require the Copilot add-on and make it possible to create interactive dashboards.

Recommended Coderhouse courses

To understand how to analyze data and make decisions based on real information, Coderhouse's Data Analytics Course teaches you the fundamentals of data analysis with real market tools. If your starting point is working with Excel and you want to master it thoroughly before incorporating AI, the Excel Course is the right place to start. And if you want to go beyond analysis and learn to automate complete processes with AI, the AI Automation Course gives you the tools to build flows that work on their own.

Frequently asked questions

Is Copilot in Excel available in Spanish?

Yes. You can interact with Copilot directly in Spanish, both to ask questions and to describe the formulas or charts you need. The quality of the responses in Spanish is good, although for very complex formulas it can be useful to use technical terminology in English.

Does it work with .xlsx files from previous versions of Excel?

Copilot works best with files that are in OneDrive or SharePoint. Local files have limited support depending on the version of the application. To take advantage of all the features, the ideal is to save the files in the Microsoft cloud.

Can I use Copilot in Excel if I'm a freelancer?

Yes, you can contract the Microsoft 365 Copilot add-on as an individual user. The monthly cost can be a valid investment if you analyze client data frequently. Evaluate how many hours per week you dedicate to analysis tasks that Copilot could reduce before deciding whether the cost makes sense for your profile.

How accurate is Copilot at generating formulas?

It's quite accurate for medium-complexity formulas. For complex cases with multiple conditions or nested data, it's always advisable to verify the result before using the formula in critical reports. A good habit is to ask Copilot to explain the formula it generated to understand what it's doing and detect possible errors.

Can Copilot in Excel connect to external databases?

Not directly, but Excel has functions for connecting to external data sources (Power Query, ODBC connections) and once the data is in the sheet, Copilot can work with it. For more complex integrations with databases or APIs, it's advisable to combine Excel with Power BI or automation tools like Power Automate.