The Outpost is a comprehensive collection of curated artificial intelligence software tools that cater to the needs of small business owners, bloggers, artists, musicians, entrepreneurs, marketers, writers, and researchers.
© 2025 TheOutpost.AI All rights reserved
Curated by THEOUTPOST
On Tue, 17 Sept, 12:05 AM UTC
3 Sources
[1]
How to Excel in Excel with Copilot
Excel has hundreds of formulas and the struggle is real to remember them. Now, instead of searching online for formulas, one can simply ask Copilot directly within the spreadsheet, making it easier to expand formula usage. Just as many believed MS Excel was becoming obsolete, Microsoft introduced the general availability of Copilot in Excel. This feature enables users to interact with Excel using natural language. Interestingly, this development comes after Microsoft recently released a research paper SpreadSheet LLM, a framework that enables LLMs to effectively process and analyse complex spreadsheet data. "Microsoft released a copilot in Excel, and it has officially caught up with Google in the AI race," posted a user on X. "Fantastic to watch" Meanwhile, Google also recently integrated Gemini into Google Sheets. Its key features include the ability to generate content based on user needs. Whether summarising spreadsheets, creating tables, formulating custom formulas, or simplifying data explanations, Gemini is designed to address a wide range of data analysis needs. The demand for Copilot grew as professionals began shifting away from Excel in favor of alternatives like Equals, Tomat AI, and Julius AI which had AI features. However, Microsoft Excel remains the world's most popular spreadsheet software. As of 2024, over 175,723 companies globally continue to rely on Excel as a key productivity tool. In fact, four out of five Fortune 500 companies use Excel, and more than two billion people around the world work with spreadsheets. Excel has hundreds of formulas and the struggle is real to remember them. Now, instead of searching online for formulas, one can simply ask Copilot directly within the spreadsheet, making it easier to expand formula usage. Moreover, Copilot is now capable of reasoning over structured data, beyond just tables, and can perform tasks like adding filters or splitting text. It also assists in highlighting key data points using formula- based conditional formatting. For instance, Copilot makes it easier to flag important details, such as identifying when spending exceeds revenue in a sales report. Not only that, users can now work with unformatted data, without needing to structure it as a table. The company has also introduced new features to fully utilise Excel's capabilities, including support for more advanced formulas like XLOOKUP and SUMIF, better conditional formatting, and the ability to refine visualisations such as charts and PivotTables with Copilot. With Copilot in Excel, it would be very easy to make data driven decisions. As a part of Copilot analysis, it now suggests the most effective visual formats, such as bar charts, line graphs, or PivotTables, and configures the appropriate fields, layouts, and filters for users. This allows users to make full use of Excel's powerful features without needing deep expertise. For example, a sales consultant can quickly understand the relationship between ad spend and campaign reach, as Copilot generates a PivotTable to assist in planning the budget for the next quarter. "Microsoft demoing Copilot in Excel- basically just an automated version of classic BI," posted a user on X. This feature is likely to challenge popular BI tools such as Tableau, Qlik Sense, Looker, and Zoho Analytics. Not all analysis involves numerical data, and Copilot's capabilities now include text analysis as well. It can process raw text and convert it into actionable insights, enabling detailed examination of both numerical and textual data with the same accuracy and efficiency. For example, Copilot can now analyse all the customer feedback from the past quarter and surface the top three concerns. Excel spreadsheets just got a major overhaul. Microsoft has announced a public preview of Python in Excel. It allows users to perform advanced data analysis directly within Excel by integrating Python. This feature enables users to use natural language to describe the type of analysis they want, and Copilot will automatically generate, explain, and insert the necessary Python code into the spreadsheet. It allows users to carry out complex tasks like forecasting, risk analysis, machine learning, and data visualisation using natural language, eliminating the need for coding. It's as if you have an expert data analyst on hand. To offer a complete experience to users, Microsoft also partnered with enterprise Python repository Anaconda, which includes libraries such as pandas, statsmodels, seaborn, and Matplotlib. Copilot provides transparency by explaining the generated Python code and creating a dedicated analysis sheet. This sheet serves as a sandbox for users to interact with Copilot, while the original data remains untouched. Users can also refresh the analysis as the data changes. In the past, many enterprises that have been hesitant to use ChatGPT for Excel-related tasks can now take advantage of Copilot, which is expected to be more secure and not use enterprise data. Interestingly, when Copilot in Excel with Python was announced last year, there were concerns about its local availability. To address these privacy issues, Microsoft has assured users that they are providing 'enterprise-level security.' This means the code will run in cloud-isolated containers with no network access, though some customers may still find this approach concerning. Copilot in Excel with Python is currently being made available to Windows Insiders, who are users participating in early testing of new software features. To use this feature, a Microsoft 365 Copilot license is required. Once this feature is activated, users can initiate advanced data analysis by either clicking on the 'Advanced analysis' prompt provided by Copilot or by entering a custom prompt asking Copilot to 'analyse with Python.'
[2]
Microsoft's AI Copilot will now help you make pivot tables and write Python code within Excel
Microsoft Excel is the de facto standard for a lot of corporate number crunching, but even some frequent users don't know everything that's possible to do in the spreadsheet program. And many data scientists and machine learning experts still prefer to do some of their work with other tools, including the programming language Python and its popular data science libraries. Now, Microsoft is looking to cater to both of those audiences, making generally available both an AI copilot that can guide your use of Excel and access to a facility for writing and using Python code directly within Excel. The Copilot can create formulas and pivot tables to answer a particular question, add sophisticated conditional formatting to highlight spreadsheet cells and rows with particular properties, and -- in a feature expected to roll out to some users over the next few months -- enter an "Advanced Analysis" mode that uses Python data science libraries to analyze and visualize data. "We see generative AI as a way to revolutionize how people do productivity in spreadsheets," says Catherine Pidgeon, head of product for Excel.
[3]
Microsoft's Office apps are getting more useful Copilot AI features
Microsoft is unveiling new features in its $30 per user Microsoft 365 Copilot monthly subscriptions that are designed to improve AI integration inside of Office apps. Excel is getting Python integration inside of Copilot, PowerPoint has an improved AI-powered narrative builder, Word is getting better at AI-assisted drafts, and Copilot will be able to help you organize your Outlook inbox, too. After bringing Python to Excel last year, Microsoft is now combining its Python support with Copilot to let Excel users easily perform advanced analysis on spreadsheet data. "Now, anyone can work with Copilot to conduct advanced analysis like forecasting, risk analysis, machine learning, and visualizing complex data -- all using natural language, no coding required," says Jared Spataro, corporate vice president of AI at work at Microsoft. "It's like adding a skilled data analyst to the team."
Share
Share
Copy Link
Microsoft introduces AI-powered Copilot to Excel, enhancing data analysis and programming capabilities. The new feature aims to simplify complex tasks and boost productivity for users of all skill levels.
Microsoft has taken a significant leap forward in the world of spreadsheets and data analysis by integrating its AI-powered Copilot into Excel. This groundbreaking move promises to transform how users interact with data, making complex tasks more accessible and boosting productivity across the board 1.
One of the most notable features of Excel's Copilot is its ability to understand and execute commands given in natural language. Users can now simply type requests like "create a pivot table summarizing sales by region" or "show me a chart of monthly revenue trends," and Copilot will generate the desired output. This natural language processing capability significantly lowers the barrier to entry for advanced data analysis techniques 2.
For more advanced users, Copilot introduces the ability to write and execute Python code directly within Excel. This feature opens up a world of possibilities for data scientists and analysts who can now leverage Python's powerful libraries and functions without leaving the familiar Excel environment. The integration allows for seamless transitions between Excel formulas and Python scripts, enhancing the overall data manipulation and analysis capabilities 3.
Copilot also excels in assisting users with formula creation and troubleshooting. By analyzing the context of the data and the user's intent, it can suggest appropriate formulas or help identify and correct errors in existing ones. This feature is particularly beneficial for users who may not be well-versed in Excel's more complex functions, allowing them to perform advanced calculations with greater ease and confidence 1.
Another significant advantage of Copilot in Excel is its ability to automate data cleaning and formatting tasks. Users can instruct Copilot to identify and handle missing values, remove duplicates, or standardize data formats across large datasets. This automation not only saves time but also reduces the likelihood of human error in data preparation processes 2.
The introduction of Copilot to Excel has far-reaching implications for productivity and skill development in the workplace. While it empowers novice users to perform complex tasks, it also challenges experienced Excel users to adapt and expand their skillsets. The AI assistant is not meant to replace human expertise but rather to augment it, potentially leading to a shift in how data analysis skills are valued and developed in professional settings 3.
As with any AI-powered tool handling potentially sensitive data, privacy and security concerns are paramount. Microsoft assures users that Copilot adheres to strict data protection standards, but organizations will need to carefully consider how they implement and use this technology within their existing data governance frameworks 1.
Reference
[1]
[2]
Microsoft is rolling out significant AI-powered updates to its Office applications and Teams, enhancing productivity and collaboration through Copilot integration. This move marks a major step in the company's AI strategy for workplace tools.
5 Sources
Microsoft announces the second wave of Copilot, introducing new AI-powered features and integrations across its 365 product suite. The update aims to boost productivity and collaboration for businesses and individual users.
22 Sources
Microsoft is investing heavily in AI technology to transform Excel, aiming to make spreadsheets more intelligent and user-friendly. This move could significantly impact how businesses and individuals interact with data.
3 Sources
Microsoft introduces significant updates to Microsoft 365 Copilot and AI agents at Ignite 2024, aiming to revolutionize workplace productivity and automation across various applications.
35 Sources
Microsoft introduces Copilot, an AI-powered assistant integrated into Microsoft 365, transforming team collaboration and productivity across various Office applications.
3 Sources
