Copilot in Excel Tutorial - Create Formula Columns EASILY

Use Copilot in Excel and create formula columns EASILY.
Copilot is very good at creating formulas such as XLOOKUP, text functions and common maths operations.
This video shows Copilot in Excel being used to write six different formulas. Awesome!
Sample file for download: computergaga.com/_excel/files...
Learn how to get Copilot
www.microsoft.com/en-gb/micro...
No Copilot. No problem.
🔥ChatGPT and AI for Excel course: bit.ly/3NkJyJ8
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📺 Related Videos
Extract from PDF to Excel with Copilot in Bing • Extract from PDF to Ex...
Excel XLOOKUP Function Examples - 8 Useful XLOOKUP Examples • Excel XLOOKUP Function...
⌚ Timestamps
00:00 - Copilot in Excel
00:55 - Introduction to Copilot in Excel
02:57 - Suggested formula column
04:24 - percentage variance formula
05:04 - PROPER and TRIM functions
06:03 - Extract text from between two characters
07:23 - Copilot and XLOOKUP function
09:03 - SUMIF formula with Copilot
👩🏻‍🤝‍👨🏿Connect with us!
LinkedIn ► / alanmurray-computergaga
Instagram ► / computergaga1
Twitter ► / computergaga1
#excel #copilot #ai

[@avitalnevo1521]

Great video Alan, thank you!
Fresh from the oven, the Microsoft Excel team have just released another new capability- generating multiple columns from a single prompt!
You can now ask Copilot to split a column, for example.
And of course, there is more to expect...
We'd love to hear what you think :)

[@Computergaga]

Fantastic! Thank you Avital.
Let's go play with new stuff 🙂

[@sumardjo]

Thanks for your knowledge
thanks very much for simple file
because easy to follow step by step

[@Computergaga]

You are most welcome

[@kebincui]

Very good video. Thanks Alan. I have not used Copilot yet 😊

[@Computergaga]

Thank you, Kebin.

[@IvanCortinas_ES]

Thank you for this tutorial Alan. Great explanation about IA.

[@Computergaga]

Thank you, Ivan.

[@PaulEBrownbill]

Co-pilot looks great and easy to use. Haven't used it yet though.

[@Computergaga]

Thanks, Paul.

[@evertondel]

Good video, as always, there will be many analysts in the future who will find themselves out of work as this AI tool progresses, it's not just Excel but power BI too. At present only Power Query seems to have escaped AI...for now.

[@Computergaga]

Thank you, Derek.

[@totallynotvcool9800]

Alan I love you ❤️

[@Computergaga]

Thank you! I love you too.

[@digivod6897]

Can I use multiple prompts at one time? Will that give multiple pieces of content and analysis in one go?

[@Computergaga]

One prompt at a time but Copilot is capable of producing multiple columns if the prompt requires it. For example, a prompt that splits/extracts the data in a column into three columns can be achieved with Copilot and with a single prompt.

[@digivod6897]

@@Computergaga Thank you!!

[@Alexander_PM]

Nice British accent)