How to Use Excel’s NEW COPILOT() Function
Learn how to use Excel’s brand-new =COPILOT() function, an AI-powered formula that lets you write natural language prompts directly in your spreadsheet. I'll walk you through its syntax, live examples, and show how it works with existing Excel functions.
🗒 Notes and Resources
Microsoft COPILOT() Support Page: https://support.microsoft.com/en-gb/o...
The formulas that I used in the demos:
=COPILOT("I need a list of the names of the Mac Operating Systems since 2007")
=COPILOT("I need a list of the names of the Mac Operating Systems include the year of release")
=COPILOT("What is the average",E1:E5)
=COPILOT("What is the total expenses for Code ALR",A2:D30)
=COPILOT("What is the total expenses for Code ABC",A2:D30)
=COPILOT("What is the name of the team's stadium?",A2:A11)
=COPILOT("Extract the email address",A1:A20)
=COPILOT("Is the review Positive, Negative or Neutral",B2:B11)
=COPILOT("I need 5 key insights from this data to give to the CEO",'Sales Data'!A1:H51)
=TEXTJOIN(CHAR(10) & CHAR(10),TRUE,COPILOT("I need 5 key insights from this data to give to the CEO",'Sales Data'!A1:H51))
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#Excel #Copilot #AI