{"id":23385,"date":"2025-09-01T12:04:18","date_gmt":"2025-09-01T11:04:18","guid":{"rendered":"https:\/\/rosoft.si\/?p=23385"},"modified":"2025-09-01T12:57:36","modified_gmt":"2025-09-01T11:57:36","slug":"excel-can-now-use-copilot-functions","status":"publish","type":"post","link":"https:\/\/rosoft.si\/index.php\/2025\/09\/01\/excel-can-now-use-copilot-functions\/","title":{"rendered":"Excel can now use Copilot functions!"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Microsoft Excel can now use Copilot functions!<\/span><\/h1>

Microsoft Excel Tests New Copilot Function With Ability to Classify Data, Generate Summaries and More<\/strong><\/span><\/p>

Microsoft Excel is now testing a new Copilot() function for its spreadsheet software. The new Copilot function will bring a suite of artificial intelligence (AI)-powered features to Excel, which will allow users to summarise a spreadsheet’s data, whether it belongs to a specific column, row (or the entire table) into paragraphs and sentences. It will be available to both Mac and Windows users. However, it is currently only rolling out to Microsoft Office beta versions and the Microsoft Excel for Mac version 16.101.
\"\"
<\/span><\/p>

Microsoft Excel’s\u00a0Copilot Function\u00a0Can Perform Sentiment Analysis<\/strong><\/span><\/p>

In a blog post, the Redmond-based tech company has announced that it is integrating the\u00a0Copilot() function into Microsoft Excel, bringing AI-enabled features to the software. With the added functionality, the users will now be able to summarise spreadsheet data, presented in tables, into paragraphs and sentences. The features will now be able to do sentiment analysis. For example, the Copilot function will be able to assign specific emojis to specific data points for easier viewing.<\/span><\/p>

How to Use Microsoft Excel’s Copilot Function<\/strong><\/span><\/p>

One can initiate the function by simply typing \u201cCOPILOT\u201d into one of the cells, followed by the code. For example, \u201c=COPILOT(prompt_part1, [context1], [prompt_part2], [context2], …)\u201d. The prompt text describes the task or query for the AI model, context provides reference from the grid, present in a single cell or a range.<\/span><\/p>

The company said that a user’s data, sent through the new Copilot function, is \u201cnever used\u201d to train or improve the large language models (LLM). \u201cThe information you input remains confidential and is used solely to generate your requested output,\u201d the company added.<\/span><\/p>

In addition to generating summaries, Excel’s new Copilot() function will also allow users to generate ideas, classify data, and create lists or tables, according to Microsoft.<\/span><\/p>

Microsoft Excel Working on Known Copilot() Bugs<\/strong><\/span><\/p>

Microsoft also highlighted a few issues that it is working to resolve. The Redmond-based tech giant has found that rows can be omitted when returning arrays, which the company said can be bypassed by restructuring queries to return smaller array results.<\/span><\/p>

In the future, the company could add support for the LLM to work without access to web or enterprise data. As of now, the Copilot function returns dates as text rather than Excel’s date serial format, which Microsoft is looking to fix, too.<\/span><\/p>

The Copilot function is currently rolling out to beta channel users who have a Microsoft 365 Copilot licence. It is available for Excel for Windows version 2509 (build 19212.20000 or later) and Excel for Mac version 16.101 (build 25081334 or later). Web users will also get access to the new functionality soon via the Frontier program.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Microsoft Excel can now use Copilot functions! Microsoft Excel Tests New Copilot Function With Ability to Classify Data, Generate Summaries and More Microsoft Excel is now testing a new Copilot() function for its spreadsheet software. The new Copilot function will bring a suite of artificial intelligence (AI)-powered features to Excel, which will allow users to…<\/p>\n","protected":false},"author":1,"featured_media":23389,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,18],"tags":[],"class_list":["post-23385","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novice_1","category-digital-technology"],"rttpg_featured_image_url":{"full":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025.jpg",1255,728,false],"landscape":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025.jpg",1255,728,false],"portraits":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025.jpg",1255,728,false],"thumbnail":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-150x150.jpg",150,150,true],"medium":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-300x174.jpg",300,174,true],"large":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-1024x594.jpg",640,371,true],"rsaddon-team-round-style":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-500x500.jpg",500,500,true],"1536x1536":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025.jpg",1255,728,false],"2048x2048":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025.jpg",1255,728,false],"trp-custom-language-flag":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-18x10.jpg",18,10,true],"braintech_portfolio-slider":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-520x640.jpg",520,640,true],"braintech_portfolio-full-slider":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-1255x650.jpg",1255,650,true],"braintech_portfolios-slider":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-1000x728.jpg",1000,728,true],"braintech_blog-slider":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-365x243.jpg",365,243,true],"braintech_blog_long_height":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-365x480.jpg",365,480,true],"braintech_latest_blog_small":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-255x157.jpg",255,157,true],"braintech_latest_blog_medium":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-340x270.jpg",340,270,true],"braintech_image_slider_big":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-860x450.jpg",860,450,true],"braintech_blog-footer":["https:\/\/rosoft.si\/wp-content\/uploads\/Copilot_sept_2025-80x68.jpg",80,68,true]},"rttpg_author":{"display_name":"admin","author_link":"https:\/\/rosoft.si\/author\/rosoft_admin\/"},"rttpg_comment":0,"rttpg_category":"Novice<\/a> Digitalne tehnologije<\/a>","rttpg_excerpt":"Microsoft Excel can now use Copilot functions! Microsoft Excel Tests New Copilot Function With Ability to Classify Data, Generate Summaries and More Microsoft Excel is now testing a new Copilot() function for its spreadsheet software. The new Copilot function will bring a suite of artificial intelligence (AI)-powered features to Excel, which will allow users to...","_links":{"self":[{"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/posts\/23385","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/comments?post=23385"}],"version-history":[{"count":8,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/posts\/23385\/revisions"}],"predecessor-version":[{"id":23395,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/posts\/23385\/revisions\/23395"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/media\/23389"}],"wp:attachment":[{"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/media?parent=23385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/categories?post=23385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rosoft.si\/index.php\/wp-json\/wp\/v2\/tags?post=23385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}