Getting insights for book sales using Copilot
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. Today I will once again use this table of book sales, using Copilot to find more insights. I ask Copilot: Which category has the best user ratings I would also like to know which author is best, so I ask Copilot: Which author has the highest average user rating? After getting that response, I would like to know more than just the top author, so I ask: Show me the top 5 authors by user rating With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation. 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.
Remove "Ghost" Excel sheet object from VBA
Hello, I am unable to remove these "Ghost" excel objects left behind after deleting the sheet. I have tried multiple methods that I found on the internet to remove these objects, but nothing works. The sheets are not hidden. The sheets do not existing. That is the "hard coded" name created when the file is created from copying the "CAD" or "CAD_Template". The "remove" button is grayed out. I tried basically everything CoPilot could tell me to remove this. This is what it looks like below. When I run the program, the program creates "CAD4" as the next hard coded name.Urgent for geography Coursework help (due tonight)
I compared 2 different areas using a visual housing survey and used 4 different categories - including exterior appearance, noise level, cleanliness and house plot size - I want to use statistical test to help my conclusion but i don't know which one and howUsing Copilot in Excel to show additional units of measure
Greetings, This is the fifth in a series of posts that provides examples of what is possible with Copilot in Excel. Today I will continue with the list of major league baseball ballparks from yesterday. Since I previously created a new center field distance column, measured in feet, I’d like to add a separate column that shows the distance in meters. 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 that shows the center field distance in meters Copilot in Excel looks at the content in the table and then suggests inserting a new calculated column that multiples the center field distance by 0.3048 to calculate the distance in meters. 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 Column button will accept the proposed change, inserting a new calculated column formula that converts the center field distance from feet to meters. 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.Using Copilot in Excel to show data insights
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. Today I will show you how Copilot can show you insights about your data. I’ll start with some sample data showing sales information for a biking company: In the Copilot Pane, I use the prompt: Show Data Insights The data insights show the Sales by 'Product. For example, the sales for “Tires and Tubes” are $86,200, and for “Locks” are $74,800. See the PivotChart above for more details. I would like to see more insights, so I click on the “Add all insights to grid" button Looking at the new sheet that was inserted, I see 6 charts and 4 PivotTables that show insights about my data: bles below. The charts show “Sales by Product”, “Rating by year and category”, “Sales increases over time”, “Category Accessories has noticeably higher sales”, “Frequency of sales”, and “Field Sales and Field Rating appear highly correlated with 1 outlier”. The PivotTables show “Sales by Product”, “Average sales by Category and Year”, “Sum of sales by year” and “Sum of sales by category” 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.Analyzing bike sales using Copilot for 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. Today I want to do some further analysis of bikes for my (fictional) company. At the request of some, I have attached the workbook I used for this and previous posts. I’d like to dive deeper into the ratings for bike products. I ask copilot: chart ratings by year for bikes The ratings are poor and I’d like to expand to the product level, so I ask Copilot: now show ratings by year by product for the bikes category I click on the Add to a new sheet button in the pane and the following is inserted into a new sheet: All products improved for 2017, but ratings for Touring bikes are very low. 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 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 TeamDetecting Palindromes using Copilot for 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. Today I have a list of words and would like to detect which ones are Palindromes. What is a Palindrome? A Palindrome is a word or sequence of characters that is the same backwards and forwards. To get started, I ask Copilot: Add a column to indicate whether the words are palindromes Looking at B2:B88, here's 1 formula column to review and insert in Column C: Is Palindrome Determines whether each word is a palindrome by checking if the word reads the same backward as forward, and returns "Yes" or "No" accordingly. =IF([@Words]=TEXTJOIN("",,MID([@Words],SEQUENCE(LEN([@Words]),1,LEN([@Words]),-1),1)),"Yes","No") I’m not sure what the formula is doing, so I click on the “Show explanation” dropdown and it says: Determines whether each word in the "Words" column is a palindrome by using the following steps: Uses the SEQUENCE function to generate a sequence of numbers from the length of the word down to 1. Uses the MID function to extract each character of the word in reverse order based on the sequence generated. Uses the TEXTJOIN function to concatenate the reversed characters into a single string. Compares the original word with the reversed string using the IF function. Returns "Yes" if the word is a palindrome and "No" otherwise. The suggested formula column sounds like it is doing the right thing, so I click on the button to insert the column: 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.Sailing itinerary with 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. Today we have an itinerary for a sailing trip in the Caribbean. I’d like to be able to filter on which days have snorkeling. I ask Copilot to: Add a column with Aye/Nay for which ports will include snorkeling Looking at B2:E12, here's 1 formula column to review and insert in Column F: Identifies whether snorkeling is mentioned in the highlights for each day by checking for the presence of the word "snorkel" and marking it as "Aye" if found or "Nay" if not. =IF(ISNUMBER(SEARCH("snorkel",[@Highlights])),"Aye","Nay") Hovering over the Insert Column button, I see the proposed column. After clicking on Insert column, I see the new column added. Today we were just having a bit of fun with talk like a pirate day in showing what Copilot can do in Excel. 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.
