How to use Excel LIVE in Teams Meetings - Realtime collaboration

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@VladoMitkov]

And just as I'm about to do a crash course for my team. Couldn't have asked for better timing! I also couldn't have asked for better tutolage, after some years away from Excel - both for dusting-off the old skillset, as well as getting up to speed on recently added features. After spending more time than I'd like to admit browsing aimlessly with no insight in sight, your videos on Dynamic Arrays are what finally brought the topic into focus for me. Thank you, Leila, and keep up the exceptional work!

[@andrecoetzee6982]

I love this! We often have to collaborate and work together in a workbook during a workshop meeting and only one person gets to type and the rest of us just watch... THIS IS SO MUCH BETTER! Thanks Leila 😊

[@Supersean0001]

Oh, yes, this would be wonderful! We have a variety of different Excel knowledge levels, and this would be absolutely amazing for small-scale training. We also have folks with vision issues, and the ability to zoom in for those folks would be a Godsend for them.

[@GarthShaner]

Oh wow! The times I’ve done Excel training and could have used this!!! I am very excited to see this roll out to everyone. Thanks as always, Leila, for giving us the how-to in a super easy way and including the requirements and limitations - I hate discovering those on my own (usually when showing someone a new feature and then something goes wrong)!

[@evinharrelson]

Good point about training. This does seem like a GREAT way to train people especially for those in remote positions. That’s probably why they’ve come out with feature specifically due to the working remotely demand now. I know that was a huge factor when I changed positions 2 months ago from a 14 year job, is if they offered remote work. So the demand is there and the big companies are giving us what we need. I think it’s a great feature!

[@vijayarjunwadkar]

Cool feature, but will have to wait till it becomes commonly available. It's going to be surely useful for 'live' collaborative work, which is becoming regular now. Thanks Leila for covering it in detail!

[@djfmate]

This is gonna be a game changer in my workplace as we still ran into sync conflicts when co-authoring files. Great stuff again Leila! Cheers from Australia! 😉👍

[@j.ballsdeep420]

Yeah, almost like they should work on fixing that in the first place before moving on

[@eduardosato9034]

Leila, tks for presenti g this game changing feature!! This will increase productivity way beyond!

[@MarkFreemanYVR]

Love the statement, "... if you are on good terms with your IT and can get them to change their mind..." Funny how often we do have to have that built up trust with IT to allow us to mess around with the new features.

[@stelioslogo8493]

Great news! It is always welcome to see improvements in our powerful tools ! 👏 However, if we want to be honest Google Sheet is using all this features the last year and is a more DYNAMIC and collaborative tool in comparison with MS Excel.

[@normangolden1997]

I have a small 5-person firm, and we will definitely start using it when it is released.

[@j.ballsdeep420]

Cringe

[@ArmandoReportes]

II was very excited when I saw the title of your video. I use Teams and Excel most of the time. Unfortunately I don't think it will help me much because I want them to do it themselves. There are four features from Zoom that 'dI love to have on TEAMS when helping people remotely:: A) the ability to draw on someone else's screen (I use Zoom It, but only works on my computer) B) being able to use TAB and Ctrl + or Ctrl - on someone else' s computer (it would be great to disable Teams shortcuts) C) the way I see a black box when something is not shared is in the way. I try to use the field list and they tell me I'm clicking on something else. D) the ability of both people to use the mouse at the same time. People tell me they can't point something for me and I have to release control and request it again. I hope there are ways to do these things already that I don't know about.

[@matthiasheuer]

I like to watch Leila's videos, she always explains everything very well. 👍👍👍👍

[@aytviewer2421]

I've been using Excel in Teams for close to two years now. It is a frustrating experience, despite how it is being hyped. Many of Excel's capabilities are handicapped, and we have lost work several times. Sure it is fine for someone to share during a Teams meeting and even allow a few people to make simple updates --but if you have serious work to do you must open it in a desktop app. Even that has it's issues as sometimes you save back your work and your updates disappear. When it works, it is handy. When it does not work, you lose work.

[@drillcream]

Yeah this is going to be really great once my company updates Office in 18 months time

[@a.b.8444]

Thank you Leila for sharing this! Good idea to add Excel Live in Teams! :)

[@FareyFraction]

The "new" sheet function is very useful, especially for filtering. I used to support a team of 6 category managers, and we had to work on the file one at a time because of filtering.

[@j.ballsdeep420]

Hoof, sounds like no one on your team of "managers" was aware of PowerQuery to merge 6 different modifications assuming no one added new columns to a table or anything _stupid_ like that, though if they were -managers- unable or illeducated in advanced functions like PowerQuery I would suspect they'd be the same type to ignorantly start manipulating a table if y'all even worked on a table rather than worksheet levels. Sigh.

[@j.ballsdeep420]

Would have been *_extremely_* simple to have a network drive location as your data source they'd drop their file into and a master file would dynamically add all their data from each file, smh. Still blows my mind how rudimentary much of even fortune 100 companies can be in their analytical skillets.

[@varunpanday2494]

Thks so much Leila !! ....yes, this is something that I can use at work BUT did not know about until now ... thanks to you

[@angorali06]

Thanks for this great content. Is this live collaboration available for other Microsoft documents (i.e. Word, PowerPoint, etc.) as well?

[@j.ballsdeep420]

God I hope not for PowerPoint as peoples attention is hard enough to keep without them aimlessly poking around during a meeting.

[@janineh5783]

I love your videos. Even though I'm quite a novice when it comes to Excel etc I'm learning loads. Do you have a brief tutorial on Sharepoint? Or any tips and tricks I can use?

[@IsaacSomuah]

This is awesome. Great content as always. This community... WE LOVE YOU ❣️

[@IsaacTwilly]

You're this important person in my career growth and improvement in excel knowledge.

[@chh8860]

"I'm curious ... is this something you can use at work?..." VERY intriguing technology ... could quite possibly be useful. I'm not sure if I want someone wandering away from the main presentation to do their 'own thing' ... but if I am an attendee (and not presenter), I might love it! PS Happy Thursday ... Happy Thursday ... Leila's back ... 😍😍😍😍

[@j.ballsdeep420]

Thank you! This was my immediate thought process but I assume the intent is more of a collaboration like I'm asking you how I can take the data I have on one worksheet and let's say create a pivot for (x) reporting and I don't know how to do so seeing as Teams allowing a participant controls to your computer results in a verrrry notable latency and thus an extreme attention to detail and patience such as writing a formula on someone elses' side as the remote connection side is needed where you'd write one condition, wait for it to fully write on the person you're connected to, add your seperator, wait to confirm it is in the formula, then write your next condition. Been there and done that --it's _terrible_ but $5 says so is this seeing as collaboration on 365 still causes kernel panics with your most basic functions in a formula. Shit, I've caused it to crash and recover from 15 to 20 minutes prior which is useless just by using an & and not even concat. Might be the absolute best but Microsoft still shits the bed, CONSTANTLY

[@דיוידמיולגאי]

Great feature as more meetings become live work meetings on Teams

[@GerhardHolzer911]

Really a great feature - just in time for the ongoing budget meetings, I will introduce this to some colleagues just tomorrow... ;)

[@geochic2]

This will be awesome for my organization, thanks for sharing!!

[@sanketamin4279]

This is going to put teams on top for collaborative environment

[@chrism9037]

Great video Leila, as always!! Thanks

[@connclissmann6514]

Looks exciting! I can see many unexpected changes ahead so I imagine it may be best to retain a separate backup copy of your workbook.

[@j.ballsdeep420]

That should just be expected and a habit you already have or you haven't been burned enough 😁

[@esthercraft]

Interesting feature... the only setback i have with working on WEB version excel, that alot of keyboard shortcut keys or format options not available in Excel Web version, which slows down productivity. But is good progress towards collaboration virtually in meetings. Looking forward to it

[@LeilaGharani]

Thanks for your feedback, Esther!

[@TLE65]

Thank you for the excellent explanation. I like your demonstration style. I believe this new feature will be very efficient in our business meetings.

[@siyabulelatshali1012]

Another productive video. Thank you.

[@Alexa_Eordogh]

It's so great! I'm super happy about this feature.

[@skerdicerga4939]

This is great and yes, certainly will use is GA.

[@DanielFlores-os9fr]

Would you use this feature for a brainstorming session in teams? Or there is a better app or option for a brainstorming session in teams?

[@vihangaoshada1325]

This is surely a great feature

[@gwendalyntolentino8260]

Quite exciting! Hope they get to add recording the presenter view at least.

[@j.ballsdeep420]

What do you mean? That's how it defaults now if you as the presenter enable the recording unless I'm not grasping what you mean

[@hossamnabil6306]

Thank you for the useful information 👍

[@abdulsaidmkamara7305]

It's a lovely feature that I have used already in my presentations.

[@usmaniqbal1836]

Perfect! Please share data files for better practice..I hope

[@dilekdemir2704]

Very crazy but I proposed this exactly 3-2 years before. But cool that this exists now....still you can optimize it more but that first step is good.

[@mikaele2x]

Creating an own view is available today, in excel online. View menu, click on the "eye" to create a temporary view. Someone presenting using the online version might be a workaround. My experience is that using the online version creates fewer sync issues, than involving the desktop program.

[@Stef1955]

You are getting close to 2m subscribers!!! I subscribed at 66k!

[@LeilaGharani]

Wow, thank you for staying with us!

[@MahmudSupplyChain]

Great one Leila. Thanks

[@AndyShelton1]

Game changer indeed!

[@techcornerNG]

Oh this is awesome!

[@rashidbakhsh9781]

Cool feature 👏👏👏

[@menoo94]

Please could you advise me which is better for Excel & PowerPoint (office) as laptops intel laptops or AMD laptops ?

[@yogibearstie]

My company’s IT group that is managing O365 seems to have concluded they will have less problems by disabling as many features as possible. I had a meeting this week where it would have been helpful to have others exploring my Excel while we discussed the issues.

[@GarthShaner]

I’ve dealt with a lot of IT departments that subscribe to the idea that all the systems run perfectly until you let users in.

[@KimHongTan]

Me too!

[@j.ballsdeep420]

This is actually beneficial: Collaboration has been an absolute shit-show since its introduction unless you're doing the most absolute basic shit. I've caused 365 online to kernel panic and force a refresh, God

[@rhoni0830]

You had me at being able to zoom in!!

[@kartikeyarora312]

The changes made by viewer in the excel file would be saved in the default file or not?

[@izkamarkizka]

Great update

[@anwarulhaq5250]

Very good feature for tender costing

[@epidermistw]

This is great and would be very helpful! Sine you said it’s web technology, I am wondering if Macro I made locally on my laptop with VB would work?

[@fotioskafantaris2608]

what is the difference between this and the share screen along with a shared spreadsheet? thanks in advance and thank you for your video

[@berndeckenfels]

Can you track who changed what and will it save without your content (I.e. should you open a copy of your file if you want to keep track?)

[@samuelstatham8342]

Am I right in saying that there's little to no benefit to this if you're on an internal call looking at a file on SharePoint? (i.e. able to still see all cameras if you're working off one screen and that's it?)

[@nathalieflake3673]

Same thought here. If the file is in SharePoint and I'm collaborating with people who also have access to that same SharePoint, the benefit is limited.

[@fahadali3882]

Hey Leila, great feature. Can you tell me whether sharing, viewing excel in Teams screen renders slicer filters, pivots correctly? What about if the xlsx sheet had built-in queries on it? Will other users be able to refresh queries or get same Ux in Teams, like they would in Excel (local client)?

[@chrisp267]

Okay, already available in Google sheets and meet.

[@williammorehead3557]

Any timeline on when this will be brought out of Beta and integrated into the every day Teams / OneDrive software?

[@louiselane806]

This is excellent, thank you, useful for training, I'm looking at becoming an Excel Tutor so this would be really helpful

[@Randhawa-in-USA]

It is cool. Teams is like the new everything software from Microsoft.

[@j.ballsdeep420]

Almost like they planned that...

[@Powys902]

This looks great, but our IT have the option disabled for now. I wonder will it be standard once out of beta.

[@j.ballsdeep420]

Your IT is very wise to keep it disabled

[@Powys902]

@@j.ballsdeep420 why?

[@SuryaAvantsaTheAwesomeThree]

Hi Leila...I like your videos on excel and other office products. Do you have a video on how to generate a crosstab report based on excel data? Where one of the columns with multiple values turn into multiple columns, one for each value.

[@5_Stripe_Gunner]

Look up text-to-columns

[@j.ballsdeep420]

For one dabble with PowerPivot, but trying to understand your short description you'd need to do a transformation and create new columns based on unique values or non-repeating values, unless you're simply talking about merging all worksheets (tabs) to then take one single column out of each and merge to a new table where you transpose the column in each to become a header row, all again done in PowerQuery but your source would be tables/worksheets under GetData rather than PowerPivot. Either way your question is extremely expansive to answer with one single catch all you're looking for but best of luck searching said functions that exist or leveraging your resources that know how to do so rather than you hunting and pecking as I promise it won't be a small endeavor if you're not familiar with M and PowerQuery

[@momforone7946]

Power query will effortless do it for you in a minute. Index match may work but will slow down your file.

[@hoffness]

This cool, I'm have to bug IT about this! I'm hoping cross-org functionality comes soon. :)

[@ranaganguli2892]

Hi laila... Please make a video on how to send mail different person with their name with same subject through Outlook

[@SachinGupta-bk8mt]

That's great, thanks. I'm gonna apply this now and be a Pro ☺️

[@rolandgarcia644]

Hi Leila, does excel has a function that lets you check tracking status on the internet? Let's say I have a long list of tracking numbers that I want to check.

[@johneylloyd]

Hi Leila, How to add st, nd, rd, th in excel and how to include the same in concatenate formula

[@dilekdemir2704]

....no....some companies I worked for you can not even share Fotos via Teams. But I found a "open loop" to transport picture/screenshots even, if you are forced to use a "light disabled Teams version"

[@simeonpayne4247]

Note this is only available at present to corporate 365 subscriptions, whereas PowerPoint live is available under the free teams offering. Do you think this will follow suit when it comes out of beta. It would be a major plus for me but can't afford this at present.

[@birasafabrice]

where are the editings for meeting participants saved? in the original document being presented or everyone in the meeting will remain with a copy the original document presented? also, does this feature require to have a subscription plan? thanks a lot!

[@yulinliu850]

Great for Excel training too.

[@j.ballsdeep420]

No

[@hansklein3649]

Excel's live version is booting in MS Teams. ®🌊⛵

[@peterroger249]

I am new to Exel. Thank you for your KZbin training. I have so much trouble importing Excel from Microsoft Azure Chatbot into (Amazon, Alexa) AWS Chatbot Excel format (both are totally different from the other). Please help. or would you refer me for help?

[@jajwarehouse1]

Does UNDO follow each individual's or everyone's actions?

[@j.ballsdeep420]

Hoof, expensive question

[@justsurfin5013]

So, this is within Teams (Excel embedded in Teams interface)? Not simply a shared OneDrive file and a screen-share?

[@j.ballsdeep420]

Here's a secret: A Teams embedded file is actually a OneDrive/SharePoint file once it's on Teams like if I send you a file or anything. This was a part of their integration bringing everything together and how it works in the backend. Go to any file you have in a channel or chat, click the 3 dots and you'll see an option to view in SharePoint 😘

[@j.ballsdeep420]

They are one and the same, buddy

[@georgetovar5976]

Dangit I don’t have public preview. When does this get fully released?

[@annt6361]

Hi, I love your videos, thanks for your hard work. We use excel at work on Teams sharepoint, but beacause of fear of losing data, each employee has their own database file in excel :(. We should merge it, but I'm afraid that several people working at the same time on views offered by Teams - they may lose some data, something will not save and we will not even know what and when.... We use filters a lot and Teams always is asking if it should change the view other users, or create the private view. We are afraid of it... Could you tell more about saving changes/data, when sharing views, please?

[@paulmfti]

Nice feature….remote collaboration via office just leveled up….

[@LeilaGharani]

👍

[@Hyopai82]

game changer

[@Sizganov]

Thx 4 video

[@shyamnarayan6788]

Awesome

[@jessicadelaflor7901]

Hello, I am wondering if that file stays shared and is it a copy or the original? Tks!

[@j.ballsdeep420]

Great question, though, cause if you're sharing something from a local copy, the permissions Teams is given would be very interesting cause I'd be really annoyed if it overwrites even local, but then if it creates a SharePoint/365 version on your cloud drive then people need to be aware to clear a shit ton of unnecessary files utilizing their cloud storage. Great question

[@clarisilwelch3242]

question on excel file in teams, how do you put dropdown or do conditional formatting to highlight a row? It works on my desktop but not in teams. hope somebody can answer my question. thanks in advance

[@RodoElshoff]

What would be a reason for IT to not want to enable it?

[@aftabahmed-hc1rn]

We are using its good fearture.

[@leanneattwood8003]

Hi there, when I am sharing a live Excel it is only capturing my screen and not the tool bar ribbon... please help how do I increase the capture area ?

[@nelpono7863]

Nice

[@stevehall2717]

IT isn't ready for our organization to allow Public Preview

[@tiagodalzotto963]

Is it possible to use this with Excel files that have macros?

[@naushadahmad5303]

Good morning

[@Sqauklog]

This is great but you can't argue that Google Sheets does it better. How do I ask my company to convert back to Microsoft Excel when we are hosting everything on Google, it's simple and easy to use.

[@j.ballsdeep420]

It's also far less robust or able to integrate with a huge variety of big data sets: If your company can operate off Sheets then kudos but you're also not utilizing professional data analytics so idk what you're so proud of.

[@j.ballsdeep420]

Don't bring a knife to a gun party

[@shahabshoukat5346]

How to send salary slips to individual employee once

[@ExcelAZ]

👌

[@johndorian4078]

Hopefully ESPN will pick this up for their championships.................

[@007KrausBean]

Sounds good in theory, but I can totally see people poking around all over the file rather than watching the presenter. I could see so many problems with this. Stuff like "Um, I don't remember that being talked about during the meeting." because they were messing around on their side and totally zoned out from the speaker.

[@j.ballsdeep420]

🥰🙌

[@GeertDelmulle]

L: “Is this something you can use at work?“ Me: “Are you kidding me? Of course!”… checking… Doh! So, we are not good friends with ICT (and there’s no way we can get a waiver!) :-(

[@gotbordercollies]

Interesting, but not useful for me

[@alvarorodriguezlasso]

Like