NEW: Copilot in Excel | Here's why it's incredible!

[@Wucky28]

Love the F1 name play! Was cracking me up

[@mcwahaab]

Excellent summary. I look forward when this becomes available to public

[@KenjiExplains]

thank you!

[@danielk9540]

When will this be available to the public???

[@neilknightley4703]

Either this will make us excel gods or brainless excel zombies

[@unanimousone8973]

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.

[@Grand_Edict]

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

[@mrjjwilson]

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.

[@danialkhan1294]

Dependable creatures

[@sheshd]

​@@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

[@christinachristoforou138]

Great overview Kenji - thank you.

[@tuhairweronnie7385]

agree

[@GeronimoPrado-h8k]

When is it coming to public?

[@PaulCKaale]

Hi guys! can I use copilot for doing bank reconciliations?

[@Nitishjha12]

Hi kenji , can you please make videos on power bi

[@shuvamsky]

Is it only available in office 365 or normal student version as well?

[@yohannaagbanaji8012]

Thank you so much Kenji, you are doing a great job. But can this copilot be used for inventory and normal excel functions

[@binurashaaminda3782]

how we can add the copilot to the excel?

[@Tofuistasty123]

please give video with pivot with dashboard and how we apply filter,formatting with tips

[@dr.cherhanlau7251]

Is it available to the public yet ?

[@Bob-lw8bg]

Thank you for posting this. Exactly what I was looking for. And very well done in my opinion.

[@saurabhsingh2890]

is the copilot available for developer version too?? because it is not available in the home tab

[@himanshugoswami3256]

Heyy kenjii love your videos❤... Please tell me how you got ananlyse data and copilot in your excel plzzz.....

[@justmakeitviral4733]

This just makes your life easier

[@ruchikarathore8175]

Hi Kenji. I wanted to check your opinion on this: When copilot in excel will be released to the wider public, will it be a cause of threat/concern to Power BI? Since copilot excel will be able to do data analysis & visualisation.

[@abelbrioso5856]

Hi kenjy. Great work. Do you perform freelancing work. I need to create a proprietary dynamic table for stock trading?

[@priyavr98]

Hey kenji. Please do a video on portfolio project ideas

[@aspectoflife]

amazing.....Mr. Kenji ...you are the super hero leader of all help!

[@muddasar3060]

Thank you for such an informative video... will please guide how we can use copilot without Internet

[@hnbastro]

That camera feature is insane - Wow

[@lexhuang3495]

can personal user get this feature or is it still for corporate users only (300 seats minimum)? 😢

[@poorboysadventures4636]

the 300 person minimum was removed. You can get however many seats now

[@mohamedtalaat5836]

Good explanation, but still, this function doesn't appear in my office 365

[@difteen9714]

Hi Kenji How can i setup the copilot on a desktop pc ?

[@mattgreene5888]

Really like the F1 play!

[@mushtaqali267]

Young man u r genius

[@joezink881]

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.

[@danielcolt5542]

Well that's incredibly disappointing

[@jcraft100]

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..

[@readdir]

It's $10/mo for O365 Home and $20/mo to enable copilot.

[@joezink881]

@@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.

[@joydboy1382]

What version of excel support this?

[@hans-martinjack9609]

How to you insert the CoPIlot app into pptx, Excel, Word?

[@unknownKnownunknowns]

Can Copilton run Solver, goal seek and breakeven analysis?

[@dedanielVD]

Hi Kenji, can you please ellaborate on how to get access to copilot? I cant seem to find it online

[@KenjiExplains]

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!

[@Tehrafi]

@@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.

[@chicagomike]

I was invited by a company called upwork but you need to be part of the upwork community and be a freelancer.

[@hopeemmanuel]

How do I access it?

[@allanlopez3850]

is that available on excel 2019?

[@EXCELWORLD-ez8xy]

good summary sir handsoff♥

[@Tofuistasty123]

excellent tips

[@clarkalbritton4071]

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.

[@unnikrishnansanthosh]

awesome, thank you for sharing

[@KenjiExplains]

thanks for watching :)

[@asonganyidenis2379]

Thanks so much Kenji, its very helpful......

[@goldendice2254]

Excellent job

[@ybwang7124]

as of now the copilot in Excel is disabled, I've talked to MS chat support on this

[@camlex6310]

What an exciting feature!!

[@anuragvaidya9947]

If I'm not wrong it is available only for Microsoft 365 subscribers. Please correct me in case I'm wrong.

[@jcraft100]

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..

[@latiffesa]

Do we have to buy it the autopilot?

[@sallyho146]

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?

[@running4fun863]

Why are the Icon different I have one that looks an area chart two colours green and blue bottom , it also does not give me the same options to do things like yours. thanks. I have done all the things, created a table and now wanting to do an average rate but it is doing a reconciliation . " Ready to Explore - Select suggestion below to get started. Does not give me an option to let it what I want to do.

[@christiancoronado]

Awesome video, thank you Kenji!

[@KenjiExplains]

thanks for watching :)

[@MrChu2010]

no copilot function ion excel. how to enable it?

[@RMGTech]

nicely explained

[@assiabouhadouza1927]

I don't even have the checkbox feature so the copilot button... Still that's interesting to know it exist :)

[@amgonegaming9515]

I've noticed the f1 pilots for "copilot" review 😂❤

[@jeminesokoturoh]

Hey! Please can you make a video on global marketing 🥺

[@deedeeakk2050]

How to added to excel ?

[@Freeflier1978]

Its finally here...if you have an Enterprise license for M365....

[@andresoares2110]

Is it available for all now?

[@jcraft100]

you have to pay an additional monthly fee to use it in most cases

[@andresoares2110]

@@jcraft100 that's bad

[@davidvega1087]

The Formula 1 names 😂

[@jasonlattier5274]

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.

[@kahfibonboy]

i've updated the latest ms office 365, but still don't show copilot button

[@mauvehawaii]

you can type the freaking formula to merge the name columns then ctrl D faster than typing the process out in copilot

[@leeching1]

do you know co-authoring in Excel

[@sarahshah4298]

F1 drivers

[@sasavienne]

Oh my God. Unbelievable. Thank you so much for explaining how to use it. I can not wait to test it.

[@KenjiExplains]

Glad it was helpful!

[@syedikramullah1114]

Version plz?

[@DanielMederich]

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.

[@husb4nd]

F1 Drivers name though😝😝😝

[@abdelazizallam]

thanks

[@syedikramullah1114]

Nice

[@sallyho146]

Btw, nice shirt

[@KenjiExplains]

thank you!

[@sallyho146]

@@KenjiExplains can you pls help me why the pivot table doesn’t show a negative sales(cancels)?

[@Dexter101x]

Who is Lewis Familton?

[@mohamedeassa]

Notification gang

[@KenjiExplains]

haha lets go!

[@Hes_Joe]

Hi, im thje 13th comment 😅

[@KenjiExplains]

oops haha

[@DjPrimeberry]

One thing I love about excel was finding and researching equations! This just makes excel boring :-(

[@abdulrashid3689]

It seems Vlookup will not work !!

[@dbsql6238]

It is not available to the consumer. It is part of a business office license.

[@JeffersonMartinSynfluent]

After looking at your table I lost interest in Excel and went to find some Formula One videos to binge watch. :-)

[@KenjiExplains]

hahaha

[@Tom37323]

It's smart enough to be sassy, "do it yourself"

[@gvinodnair]

Hmm...So, eventually, AI is conquering MS Office also.

[@KenjiExplains]

seems like it!

[@MR-vj8dn]

It is not AI. It is ML.

[@Sventa-x6g]

💯💫👍

[@kaibaing4288]

Excel reliant professionals are soon gonna be out of office as 1 human would be able to do 4-5 men's work

[@magicsmoke0]

No, it’s not “here” yet. The average person cannot access it.

[@panksimus]

Not very useful for excel in my opinion. Game changer for PPT.

[@petercrossley1069]

Stop saying “less than twenty “. It is “fewer than twenty”.

[@urduadabkaynaam]

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

[@jonathan-6948]

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

[@btf1287]

AI in excel holy cow You can delete your old tutorial videos Kenji ahaha just jk

[@KenjiExplains]

hahaha XD

[@ProfoundFamiliarity]

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.

[@ronanhughes8506]

This is terrible.Massive let down.

[@willzinner8813]

esteban pcon ahahha

[@KenjiExplains]

XD

[@de_da_oo]

Try this on 100k rows, can't even filter. You are better off learning Excel

[@pareshprajapati3282]

Can u please do video on macro and vba

[@KenjiExplains]

I already have. Check my channel for them :)

[@dcasuto]

Great job. Thank you.