Microsoft Copilot: How AI Changed Excel Forever

Подписаться 613 тыс.

Просмотров 38 тыс.

50% 1

Copilot turns your words in Excel (and not only) into the most powerful productivity tool on the planet, according to Microsoft. In this video tutorial, I'm going to show you its strong and weak sides.
👩‍🏫 LEARN MORE about Excel in my courses: bit.ly/excelcoursesyt
LEARN MORE
===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: www.myonlinetraininghub.com/e...
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
==============
0:00 The most powerful productivity tool on the planet
0:39 Free alternative of Copilot
0:46 How to start using Copilot
1:42 I was surprised to find this out...
1:50 How it can save time in a few clicks
2:38 If you don't like working with conditional formatting
3:05 Quickly changing cell formats
3:46 Copilot revealed information it shouldn't have
5:05 How Copilot can help with identifying trends, patterns, and outliers
5:49 Alternative to use for data analysis
5:57 How it outbeats ChatGPT
6:33 The possible feature of Copilot
6:52 This part will make more sense after watching the whole video
#ExcelCopilot #CopilotExcel #MicrosoftCopilot

Наука

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 57

@MyOnlineTrainingHub 6 месяцев назад

❓ What do you think about this tool? Share your thoughts in the comments!

@mcwahaab 6 месяцев назад

Thanks, Myda for the instrumental highlights on Copilot for Excel. I think this will change the way people work, but asking the right questions needs to be learned.

@MyOnlineTrainingHub 6 месяцев назад

Yes, new skills are definitely required to get the most out of it. 👍

@ricos1497 6 месяцев назад

I guess it might be worthwhile if you have 300+ staff, maybe. The problem I find, is that often people don't even know the questions they want to ask or are trying to answer. More often than not, their data is held in some disastrous format and that's where they're spending the wasted effort (because they can't use PQ). Once you've got your data in a table with all the appropriate columns then you're 90% there already, and anyone that can do this with a degree of competence probably doesn't need copilot. If you could ask it to retrieve data from three different sources, clean it, organise it, provide a series of connections and data tables, returning a dynamic interface then it would likely be of some use. I just think it's very limited in its offering.

@MyOnlineTrainingHub 6 месяцев назад

Yeah, it's certainly fairly basic right now, but I expect it will improve dramatically with time. Whether it will ever be able to handle complex messy data 🤔unlikely.

@ricos1497 6 месяцев назад

@@MyOnlineTrainingHub yes, I think it is unlikely. I have absolutely no doubt that bosses across the world will be attracted to the idea for no other reason than it sounds cool!

@ScottLititz 6 месяцев назад

Definitely a time saving tool. But I have concerns if used by Excel users who struggle with pivot tables. People whose skill level is not quite intermediate. It almost feels like cheating. And if you go back to them and ask something more advanced, the blank stare on their face would scare me as a manager. My belief is that you need understand the guts of a machine before you try to maximize it

@dougmphilly 6 месяцев назад

this. you get an answer but nobody knows why.

@MyOnlineTrainingHub 6 месяцев назад

Interesting insights 👍I see it more useful for helping users understand 'how' or 'why' than it actually doing the work for you. It's just too slow to implement your instructions. The data insights will be useful, but again, it's a tool, not a complete solution.

@ugabrew 6 месяцев назад

@@dougmphilly And as anyone who has played with ChatGPT or Bard knows... you will frequently receive the wrong answer.

@michaelwiggins3663 6 месяцев назад

You're absolutely correct. Corporate America is going to think that this software levels the playing field and makes everyone a Data Scientist regardless of skill level since anyone can do it with Copilot. They will think they can replace 5 Data Scientists salaries with a $200k subscription and now everyone is a Data Scientist. Unfortunately, when those less skilled users try to use it, they will either not be able to generate the correct AI prompt to get the desired result or they will not have the ability to check the work of the tool and be left to assume that it is correct. I guarantee that at least one company goes out of business because someone generates executive reports with incorrect formulas, there is no one left in the company capable of finding the error, and they make decisions based on incorrect data.

@dougmphilly 6 месяцев назад

@@michaelwiggins3663 i suggested to our data integrity group that anyone using AI needs to cite it as reference and provide a text history. i have liability concerns.

@theharsh2005 6 месяцев назад

Thank you , this is terrific help.

@MyOnlineTrainingHub 6 месяцев назад

Great to hear!

@Gorman-84 6 месяцев назад

Nicely done. Thank you for sharing.

@MyOnlineTrainingHub 6 месяцев назад

Thanks for watching!

@chrism9037 6 месяцев назад

Very interesting Mynda. I see it's value (in it's current state, which I know will improve constantly) in helping with complex formulas. When you inherit a file from someone else who has written a complex formula, it can take some time to dissect it to understand it better. This can definitely help there. Looking forward to getting it. Thanks!

@MyOnlineTrainingHub 6 месяцев назад

I agree, Chris. I think it will be super useful for those tasks, but having it actually do the work for you is way too slow for every day use. Of course, if you're a complete beginner, then it's helpful, but it's not sustainable to solely use Copilot.

@mogarrett3045 6 месяцев назад

wow....have it write Python is awesome. thank you for sharing

@MyOnlineTrainingHub 6 месяцев назад

You're welcome! It will be a huge help with Python for those of us who don't know it.

@robparker1625 6 месяцев назад

It's good to see sensible, affordable pricing for the everyday user.

@MyOnlineTrainingHub 6 месяцев назад

😁 I know! I think/hope it's coming though 🤞

@mittanuljak4747 4 месяца назад

useful information

@MyOnlineTrainingHub 4 месяца назад

Great to hear 🙏

@IamTheReaper911 6 месяцев назад

Hmmmm, you got me thinking on this one 🤔 😎🤜💥🤛

@MyOnlineTrainingHub 6 месяцев назад

🤔😊 thanks for watching!

@codecaine 17 дней назад

Nice work

@MyOnlineTrainingHub 17 дней назад

Thank you! Cheers!

@dispirted8 6 месяцев назад

I think I might have more use for this in Word 😊

@MyOnlineTrainingHub 6 месяцев назад

Yes, it's definitely better at the language based apps like Word, Outlook and PowerPoint. I can see it being helpful for formulas, but having it actually do the work, is less useful.

@ArturoCamilleri 6 месяцев назад

Nice overview, i have a big concern and its How does it interact with Power Query and Power Pívot?

@MyOnlineTrainingHub 6 месяцев назад

It doesn't interact with Power Query and Power Pivot...yet. Not sure if there are plans for it to in the future or not 🤷‍♀️

@antique-bs8bb 6 месяцев назад

Thanks for splashing out $230k just to show us copilot :) And for talking it through. The conditional format rule is for a cell range: $J$2:$J$701 so I guess that if you add data to the table the new rows won't get the formatting. Strange that copilot demands data in an Excel table format but then doesn't use structured referencing. Personally I am coming to the conclusion that AI is rubbish at doing the things I know how to do already. But pretty good at doing some of the things I can't.

@MyOnlineTrainingHub 6 месяцев назад

It's confusing but the conditional formatting tool doesn't recognise table structured references, but it will automatically expand to include new rows in the table without having to edit the rule.

@antique-bs8bb 6 месяцев назад

@@MyOnlineTrainingHub Aha - so it did get it right and yes you are right too - it is confusing.

@HyzZzz 4 месяца назад

@@MyOnlineTrainingHub Can you make a video (+sample file) about the conditional formatting "Cell Value > 100000"? I can't get it to work. Are there any other inputs for the conditional format-formula wich avoids the current shortcomings?

@leochau_____ 5 месяцев назад

Great content! Is it possible for me to get the sample data?

@MyOnlineTrainingHub 5 месяцев назад

Glad you enjoyed it. I didn't include an example file for this video, sorry.

@BUY_YOUTUB_VIEWS_733 6 месяцев назад

This video blew my mind!

@MyOnlineTrainingHub 6 месяцев назад

Thanks for watching 🙏😊

@janithb1309 6 месяцев назад

Can it create Power Query as well? Based on our requirements!

@MyOnlineTrainingHub 6 месяцев назад

No. Not yet anyway.

@esnutrisari1778 6 месяцев назад

which version of this excel have Copilot? I am a subscribe 365 Enterprise, but I do not look this feature.

@MyOnlineTrainingHub 6 месяцев назад

It's currently only available to corporates willing to purchase 300+ licenses, as explained at the beginning. We are hopeful it will become available to all 365 users once this initial phase is over.

@tiongah7690 6 месяцев назад

How did you get Copilot in the first place?

@MyOnlineTrainingHub 6 месяцев назад

Microsoft gave access to all MVPs to try out 😁

@tiongah7690 5 месяцев назад

@@MyOnlineTrainingHub Wow nice 🤩

@nazarkamal8831 6 месяцев назад

Even the God comes in to excel like add Ins Also , People should learn the Excel Properly & manually, without the manual knowledge and skills in excel , people cant even able to get and confirm the basic benefits of these kind of tools like chatgpt ,copilot , etc!!! What ever the tech comes in !!! Manual Learning & understanding of "EXCEL" is the only way to Survive from the Real Time multi work Tasks & others staff!!

@MyOnlineTrainingHub 6 месяцев назад

Yes, I agree that learning the skills will be way more efficient than asking AI to do it and then waiting for it to do the task. Great if you get stuck, but not sustainable long term.

@user-zv9bm7uj1u 6 месяцев назад

I am underwhelmed. Can do this with GPT 3.5..

@MyOnlineTrainingHub 6 месяцев назад

Well, you can get answers to prompts, but GPT 3.5 can't make changes to your spreadsheet, but it can tell you how to do it, I agree.

@Scenic_Route71 5 месяцев назад

Drop the file Link in the description

@MyOnlineTrainingHub 5 месяцев назад

I didn’t provide a file for this video, sorry.

@Dondriver12345 2 месяца назад

Looks like replacing good old A/C knob in a car with a virtual button in the tablet. Currently I don't see any value in it. May be good for the people who just see the Excel for the 2nd time in their life.

@MyOnlineTrainingHub 2 месяца назад

Yes, definitely aimed at the beginner.