Copilot in Excel examples for the week of August 12th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here's what you can look forward to this week: Monday, 12-Aug - Using Copilot in Excel to split columns Tuesday, 13-Aug - Adding email addresses using Copilot in Excel Wednesday, 14-Aug - Working with date columns using Copilot in Excel Thursday, 15-Aug - Converting text to numbers with Copilot in Excel Friday, 16-Aug - Using Copilot in Excel to show additional units of measure Stay tuned, Microsoft Excel TeamUsing Copilot in Excel to split columns
Hi Everyone, this is the first in a series of posts to show you some of the things that are possible to do with your workbooks using Copilot. Today I will start with this list of employees: I would like to have the names in this list separated into 2 columns for the first and last names. To accomplish this, I'll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt: Split the name column into first and last name Copilot in Excel looks at the content in the list and then suggests inserting 2 new calculated column formulas to split the first and last names from the Name column. formula columns to review and insert in Columns E and F: 1. First name Extracts the first name of each individual by splitting the full name at the space and selecting the first part. =INDEX(TEXTSPLIT([@Name]," ",,TRUE),1,1) Show explanation 2. Last name Extracts the last name of each individual by splitting their full name and selecting the last part. =INDEX(CHOOSECOLS(TEXTSPLIT([@Name]," ",,TRUE),-1),1,1) Hovering the mouse cursor over the "Insert columns" button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted. Clicking on the Insert Columns button will accept the proposed change, inserting 2 new columns with calculated column formulas that split out the first and last names, giving me the result I was looking for! Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel. Thanks for reading, Microsoft Excel Team *Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.Getting help from Copilot in Excel creating a formula to calculate distinct values
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. This week I have a table of event locations, and I’d like to figure out a formula to count up the distinct locations. I would like to find out how many locations are listed, so I ask Copilot: How many distinct locations are there? I analyzed data in B2:C156, and here's what I found: Distinct Count of Location 50 Copilot said: There are 50 distinct locations. Copilot returns an answer of 50, but I would like to have a formula that updates as the list changes. A coworker suggested the formula below, but I don’t understand it. I ask copilot: A coworker gave me this formula to calculate the distinct locations, can you tell me how it works: =SUM(--(FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)) > 0)) This formula calculates the number of distinct locations in column C. Here's how it works: MATCH(C:C, C:C, 0): This part of the formula creates an array of the positions of each value in column C. The 0 indicates an exact match. FREQUENCY(MATCH(C:C, C:C, 0), MATCH(C:C, C:C, 0)): The FREQUENCY function is used to count the number of times each value appears in the array created by the MATCH function. It returns an array where each element represents the frequency of the corresponding value. FREQUENCY(...) > 0: This part of the formula creates a boolean array where each element is TRUE if the corresponding frequency is greater than 0, and FALSE otherwise. --(FREQUENCY(...) > 0): The double unary operator (--) converts the boolean array into an array of 1s and 0s, where TRUE becomes 1 and FALSE becomes 0. SUM(...): Finally, the SUM function adds up the array of 1s and 0s, giving the total count of distinct locations. I understand the formula, but it seems overly complicated. I’d like to see if Copilot can do better. I ask: Can you simplify the formula? Yes, I can simplify the formula. Here is a more straightforward way to count distinct locations using the UNIQUE and COUNTA functions: =COUNTA(UNIQUE(Table19[Location])) That is much simpler! I copy the formula from the copilot pane and copy into my workbook. Now when I make changes to the table, the unique location count updates automatically. Here are some additional examples from the last six weeks if you missed them: Copilot in Excel examples for the week of August 12th Copilot in Excel examples for the week of August 19th Copilot in Excel examples for the week of August 26th Copilot in Excel examples for the week of September 3rd Copilot in Excel examples for the week of September 9th Copilot in Excel examples for the week of September 16th Stay tuned, Microsoft Excel Team *Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.Copilot in Excel examples for the week of September 16th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here's what you can look forward to this week: Monday, 16-Sep - Detecting Palindromes using Copilot for Excel Tuesday, 17-Sep – Generating links to maps using Copilot in Excel Wednesday, 18-Sep – Copilot in Excel riddles Thursday, 19-Sep – Sailing itinerary with Copilot in Excel Friday, 20-Sep – Using Copilot in Excel for my photography hobby Here are some additional examples from the last few weeks if you missed them: Copilot in Excel examples for the week of August 12th Copilot in Excel examples for the week of August 19th Copilot in Excel examples for the week of August 26th Copilot in Excel examples for the week of September 3rd Copilot in Excel examples for the week of September 9th Stay tuned, Microsoft Excel TeamCopilot in Excel examples for the week of August 19th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here's what you can look forward to this week: Monday, 19-Aug – Let Copilot in Excel help you get started Tuesday, 20-Aug - Have Copilot in Excel explain a formula for you Wednesday, 21-Aug - How Copilot in Excel can help you with a formula Thursday, 22-Aug - Get help on a function with Copilot in Excel Friday, 23-Aug – Learn how to use PivotTables using Copilot in Excel Here are some additional examples from last week if you missed them: Copilot in Excel examples for the week of August 12th Stay tuned, Microsoft Excel TeamCopilot in Excel examples for the week of September 9th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here's what you can look forward to this week: Monday, 9-Sep – Using Copilot in Excel to show data insights Tuesday, 10-Sep – Grouping dates by quarter using Copilot in Excel Wednesday, 11-Sep – Getting insights for book sales using Copilot Thursday, 12-Sep – Using Copilot for Excel to create a chart (microsoft.com) Friday, 13-Sep – Analyzing bike sales using Copilot for Excel Here are some additional examples from last few weeks if you missed them: Copilot in Excel examples for the week of August 12th Copilot in Excel examples for the week of August 19th Copilot in Excel examples for the week of August 26th Copilot in Excel examples for the week of September 3rd Stay tuned, Microsoft Excel TeamSummarizing survey results with Copilot in Excel
Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will show you how you can use Copilot to summarize feedback that’s in an Excel workbook. I’ll start with some feedback about a fictional product shown below: I ask Copilot in Excel to: Summarize the Feedback Copilot returns these 5 categories that summarize the feedback received: Here's a summary of column 'Feedback': User-Friendly Interface and Setup: The product is praised for its intuitive and user-friendly interface, clean layout, and easy navigation. Users appreciate the quick and hassle-free setup process, allowing them to start using the product within minutes. Performance and Reliability: The product is noted for its reliable performance, quick response to commands, and ability to work well even in noisy environments. Users rarely experience lag or delays, and the product consistently performs well without major issues. Voice Recognition and Customization: The voice recognition feature is impressive, accurately understanding commands. Users appreciate the ability to customize settings and create routines, enhancing their smart home experience. Sustainability and Energy Efficiency: The product's focus on sustainability and energy efficiency is well-received. Energy-saving features help reduce electricity bills, and the product automatically turns off devices when not in use. Customer Support and Updates: The support team is knowledgeable, friendly, and responsive, quickly resolving any issues. The product receives regular updates that add new features and improve performance, with seamless updates that don't disrupt usage. Copilot provided a great summary of the feedback. I see that there is both positive and negative feedback for this product. I would like to break it down in that way, so I follow-up with another question for Copilot: That's good but please summarize into 2 categories, one for positive feedback and one for negative Copilot returns a summary of the positive and negative feedback for the product which I can use to communicate with my team and provide an overview of feedback received. Here's a summary of column 'Feedback': Positive Feedback: Users appreciate the intuitive and user-friendly interface, seamless integration with smart home setups, and the ability to customize settings and create routines. The voice recognition feature is praised for its accuracy, and the product's performance is noted for being reliable and responsive. Other positive aspects include the focus on sustainability and energy efficiency, sleek and modern design, and the helpful and knowledgeable customer support team. Regular updates that add new features and improve performance are also highlighted. Negative Feedback: Some users encountered compatibility issues with older smart devices and expressed concerns about privacy and data security. There are occasional struggles with accents, and some older devices don't work as well with the assistant. Users also mentioned the desire for the product to support a wider range of devices and the need for transparency about data usage. Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel. Thanks for reading, Microsoft Excel Team *Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.Copilot in Excel examples for the week of August 26th
The Excel team is happy to share some examples of how Copilot in Excel can help you. Here's what you can look forward to this week: Monday, 26-Aug – Using Copilot in Excel to count up rows that meet a criteria Tuesday, 27-Aug - Summarizing survey results Wednesday, 28-Aug – Highlighting empty cells using Copilot for Excel Thursday, 29-Aug – Adding icons to visualize results with Copilot in Excel Friday, 30-Aug – Counting and highlighting duplicate values Here are some additional examples from the last few weeks if you missed them: Copilot in Excel examples for the week of August 12th Copilot in Excel examples for the week of August 19th Stay tuned, Microsoft Excel TeamQuickly estimate sales data using Copilot in Excel
Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. We have transitioned from daily to weekly and we are posting on the Excel blog (https://aka.ms/xlblog). This week's example shows how to estimate book sales for the rest of the fiscal year, starting with this table: and resulting in this: To read how to use Copilot to do this, click here: Quickly estimate sales data using Copilot in Excel Stay Tuned, Microsoft Excel TeamConverting text to numbers with Copilot in Excel
Greetings, This is the fourth in a series of posts that provides examples of what is possible with Copilot in Excel. Today I will use a list of major league baseball ballparks in the United States. ass Milwaukee Brewers 2001 400 feet (122 m) Retractable Angel Stadium 45,517[2] Anaheim, California Grass Los Angeles Angels 1966 396 feet (121 m) Open I would like to fix up the Distance to center field column to remove the metric measurements so that it can be sorted correctly. To accomplish this, I'll start by clicking on the copilot button on the right side of the Home tab, showing the copilot pane and type the prompt: Add a new column for center field distance, converting it to numbers and ignoring the part in parentheses. Copilot in Excel looks at the content in the table and then suggests inserting a new calculated column that uses the Textbefore function to remove the extraneous information. Hovering the mouse cursor over the "Insert column" button in the copilot pane shows a preview of what inserting the new column formulas will look like. From the preview, it looks like it is doing what I wanted. Clicking on the Insert Column button will accept the proposed change, inserting a new calculated column formula that extracts just the distance in feet, allowing me to sort the list correctly. Over the coming weeks I will be sharing more examples of what you can do with Copilot in Excel. Thanks for reading, Microsoft Excel Team *Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.
