NEW: Copilot in Excel | Here's why it's incredible!
Vložit
- čas přidán 2. 07. 2024
- Microsoft Copilot is finally here! Find out how to use it in Excel here.
Take our Excel for Business & Finance course here: www.careerprinciples.com/cour...
Microsoft Copilot is finally here! In this step by step tutorial we'll go over how to use copilot in Excel, copilot in PowerPoint, and copilot in Outlook. In Excel, we'll use copilot to analyze data, add formulas, highlight text, and add visuals. In Powerpoint, we'll use copilot to create a presentation, add new slides, and summarize our slides. In Outlook, we'll use copilot to create new emails for out of office and a meeting summary. We'll also use the copilot coach to draft better emails.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Microsoft Copilot Intro
0:29 - Copilot in Excel
5:28 - Copilot Excel Flaws
6:19 - Copilot in PowerPoint
8:09 - Copilot in Outlook
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
Excellent summary. I look forward when this becomes available to public
thank you!
Thank you for posting this. Exactly what I was looking for. And very well done in my opinion.
Love the F1 name play! Was cracking me up
amazing.....Mr. Kenji ...you are the super hero leader of all help!
Great overview Kenji - thank you.
Thanks so much Kenji, its very helpful......
What an exciting feature!!
Thank you so much Kenji, you are doing a great job. But can this copilot be used for inventory and normal excel functions
Awesome video, thank you Kenji!
thanks for watching :)
good summary sir handsoff♥
Great job. Thank you.
This just makes your life easier
awesome, thank you for sharing
thanks for watching :)
Hey kenji. Please do a video on portfolio project ideas
Really like the F1 play!
nicely explained
Excellent job
Young man u r genius
Either this will make us excel gods or brainless excel zombies
AI is already killing our brains. Imagine some of us working in the Big4 Audit firms being told how to incorporate AI in our work...we have stopped thinking.
It will make excel more accessible but there will still be a major gap between people who understand excel fundamentally vs those who prompt Copilot
It will do both, it's a tool, people who never wanted to learn will be able to access Excel at a deeper level and those who want to learn will accelerate their workflow. Similarly, most people don't need to know how to write code to benefit from accessing information or buying/selling products online.
Dependable creatures
@@unanimousone8973 I'm seeing creatives use it for loaaaads of stuff. Initially I was thinking this would be a time saver and useful but now I'm starting to agree with you. It's making people stop thinking
Hi kenji , can you please make videos on power bi
Thank you for such an informative video... will please guide how we can use copilot without Internet
Heyy kenjii love your videos❤... Please tell me how you got ananlyse data and copilot in your excel plzzz.....
Thank you Kenji. My pivot table doesn’t show negative sales numbers. It just shows 1 in red. I checked the format cell. Still not working. How to fix to show negative numbers in pivot table for cancelled sales?
Hi guys! can I use copilot for doing bank reconciliations?
is the copilot available for developer version too?? because it is not available in the home tab
Is it only available in office 365 or normal student version as well?
Hi kenjy. Great work. Do you perform freelancing work. I need to create a proprietary dynamic table for stock trading?
thanks
When is it coming to public?
Hey! Please can you make a video on global marketing 🥺
When will this be available to the public???
Hi Kenji
How can i setup the copilot on a desktop pc ?
Is it available to the public yet ?
I don't even have the checkbox feature so the copilot button... Still that's interesting to know it exist :)
how we can add the copilot to the excel?
Nice
Just to burst everyone's bubble, MS pay walled it. You need an E3 or E5 enterprise license (be in or own a company of 300 licenses chairs) plus you need to pay an extra monthly fee. Despite how much MS is talking up copilot being integrated across O365... its strategically leaving out the bit where only the ultra rich companies get it. cant be giving powerful, possibly life changing tools that could benefit the smaller peasants now can we.
Well that's incredibly disappointing
thank you - this not the first time an entire video has been dedicated to functions we can't use - unless you pay an additional monthly fee.. I wish this were better explained right at the beginning..
It's $10/mo for O365 Home and $20/mo to enable copilot.
@@readdirfor all? Or just Fortune 500 companies? If a construction company with 30 employees can’t get it… Then that information is useless to 95% of businesses wanting to utilize this.
How to you insert the CoPIlot app into pptx, Excel, Word?
What version of excel support this?
Thanks - but it seems these should all just be native features of Excel. Hopefully, Copilot for Excel aggregates all these requests into future feature changes in the Excel app itself.
is that available on excel 2019?
Can Copilton run Solver, goal seek and breakeven analysis?
I've noticed the f1 pilots for "copilot" review 😂❤
Good explanation, but still, this function doesn't appear in my office 365
Its finally here...if you have an Enterprise license for M365....
I need solutions in excel. I am not an expert but I use excel daily. or google sheets can this help
Do we have to buy it the autopilot?
Oh my God.
Unbelievable.
Thank you so much for explaining how to use it.
I can not wait to test it.
Glad it was helpful!
no copilot function ion excel. how to enable it?
How do I access it?
as of now the copilot in Excel is disabled, I've talked to MS chat support on this
can personal user get this feature or is it still for corporate users only (300 seats minimum)? 😢
the 300 person minimum was removed. You can get however many seats now
How to added to excel ?
i've updated the latest ms office 365, but still don't show copilot button
The Formula 1 names 😂
you can type the freaking formula to merge the name columns then ctrl D faster than typing the process out in copilot
Hi Kenji, can you please ellaborate on how to get access to copilot? I cant seem to find it online
Hey I honestly don’t know they weren’t clear on when it’s coming out. The Microsoft team gave me early access as I’m partnered with them (as I make excel videos). Sorry can’t be of much help!
@@KenjiExplains You get access to it with their best package, which companies with greater than 50 employees often have. Thats what I know. Its not something for everyone atm, that's have I understood it.
I was invited by a company called upwork but you need to be part of the upwork community and be a freelancer.
i saved in onedrive, I enabled autosave. I have the necessary subscriptions. The copilot button is still grey in my app. I can use office and open excel spreadsheets in edge browser and the Copilot button is active. In ALL MY OTHER Microsoft Apps (Word, Note, Powerpoint) the Copilot button is active. I am ONLY having the grey button in excel. WHY? Please help.
If I'm not wrong it is available only for Microsoft 365 subscribers. Please correct me in case I'm wrong.
You have to pay for this Copilot - so if you are an individual - just you using your Microsoft 365 subscription - you will have to pay an additional monthly fee to use it.. If your company has paid for a Microsoft 365 subscription for your company, then you will be able to use Copilot..
Notification gang
haha lets go!
F1 drivers
Version plz?
F1 Drivers name though😝😝😝
do you know co-authoring in Excel
Btw, nice shirt
thank you!
@@KenjiExplains can you pls help me why the pivot table doesn’t show a negative sales(cancels)?
Is it available for all now?
you have to pay an additional monthly fee to use it in most cases
@@jcraft100 that's bad
Who is Lewis Familton?
One thing I love about excel was finding and researching equations! This just makes excel boring :-(
💯💫👍
It's smart enough to be sassy, "do it yourself"
It is not available to the consumer. It is part of a business office license.
It seems Vlookup will not work !!
Hi, im thje 13th comment 😅
oops haha
I’m not knocking this at all, really. There is obviously an audience out there for this. Yet just very plainly, for anyone to be actually considered proficient at excel at a basic minimum level, they should be able to do all of these things without the assistance of CoPilot. Plus then they’d actually understand the underlying formulas and mechanism behind it. Not to say to deter progress as CoPilot is the way forward. Yet just saying these things are fundamentals and actually don’t take that long to do manually via formulas or sheet manipulation vs CoPilot. Hopefully CoPilot is trained well enough to do actual very complex requests which require already prior data cleaning, organizing, and some analysis completed. That’d be the better use case, for CoPilot to further elevate the content fundamentals.
After looking at your table I lost interest in Excel and went to find some Formula One videos to binge watch. :-)
hahaha
Excel reliant professionals are soon gonna be out of office as 1 human would be able to do 4-5 men's work
Hmm...So, eventually, AI is conquering MS Office also.
seems like it!
It is not AI. It is ML.
No, it’s not “here” yet. The average person cannot access it.
Not very useful for excel in my opinion. Game changer for PPT.
Haha, anyone like me who knows basic excel can do it in seconds without CoPilot. It's not what I thought it is. I'm sorry dude
esteban pcon ahahha
XD
AI in excel holy cow
You can delete your old tutorial videos Kenji ahaha just jk
hahaha XD
Stop saying “less than twenty “. It is “fewer than twenty”.
I really do not know why so many are impressed. Everything he did in Excel I can do quicker without copilot. Or at least not significantly slower. Why so much writing. Just do what you want. I would like to see data cleaning, or if you do some pattern it applies it to all, but these features are for me of no value at all, let alone $30. I expected more
Presumably you can just talk to Copilot through your mic, rather than typing. If not, it's garbage in my opinion. Also those "professional" responses generated by AI were seriously awful. For example, it was really obvious that they were written by someone or something that has no individuality. I find overly "professional" comms really irritating.
This is terrible.Massive let down.
Try this on 100k rows, can't even filter. You are better off learning Excel
Can u please do video on macro and vba
I already have. Check my channel for them :)