How to use Excel LIVE in Teams Meetings - Realtime collaboration
Рет қаралды 115,986
Күн бұрынJoin 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Microsoft is bringing Excel directly into your Teams meetings. Until now, sharing spreadsheets within a Teams meeting has been a rather one-sided experience. With Excel Live your Teams meeting participants can now edit Excel spreadsheets together in real time.
You share a file, and everyone in the meeting can now edit the Excel file directly from the meeting screen in Teams. Participants can follow the presenter, interact, and edit the workbook - without ever leaving the meeting screen.
Everyone can look at the data in their own way - while working together. Excel Live supports custom Sheet Views and flexible zoom levels for each participant.
00:00 Transform Microsoft Teams meetings with Real-Time Collaboration
00:35 Participant View
01:34 Create your Own Sheet View
02:26 Presenter View
03:47 Requirements and Limitations
04:54 Wrap Up
🌍 My Online Courses ► www.xelplus.com/courses/
🎬 LINKS to related videos:
- We FINALLY get the Excel functions we've been Wanting: • Breaking News! We FINA...
- NEW Features in Microsoft Teams (Did you see these?): • New Features in Micros...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #teams
@LeilaGharani 6 ай бұрын
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@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
@drillcream Жыл бұрын
Yeah this is going to be really great once my company updates Office in 18 months time
@geochic2 Жыл бұрын
This will be awesome for my organization, thanks for sharing!!
@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.
@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!
@eduardosato9034 Жыл бұрын
Leila, tks for presenti g this game changing feature!! This will increase productivity way beyond!
@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!
@matthiasheuer Жыл бұрын
I like to watch Leila's videos, she always explains everything very well. 👍👍👍👍
@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 😊
@skerdicerga4939 Жыл бұрын
This is great and yes, certainly will use is GA.
@vihangaoshada1325 Жыл бұрын
This is surely a great feature
@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!
@anwarulhaq5250 Жыл бұрын
Very good feature for tender costing
@normangolden1997 Жыл бұрын
I have a small 5-person firm, and we will definitely start using it when it is released.
@j.ballsdeep420 Жыл бұрын
Cringe
@techcorner2024 Жыл бұрын
Oh this is awesome!
@AndyShelton1 Жыл бұрын
Game changer indeed!
@isaacsomuah Жыл бұрын
This is awesome. Great content as always. This community... WE LOVE YOU ❣️
@user-wy3gw2pw5h Жыл бұрын
Great feature as more meetings become live work meetings on Teams
@a.b.8444 Жыл бұрын
Thank you Leila for sharing this! Good idea to add Excel Live in Teams! :)
@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.
@chrism9037 Жыл бұрын
Great video Leila, as always!! Thanks
@izkamarkizka Жыл бұрын
Great update
@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.
@IsaacTwilly Жыл бұрын
You're this important person in my career growth and improvement in excel knowledge.
@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
@hossamnabil6306 Жыл бұрын
Thank you for the useful information 👍
@GerhardHolzer911 Жыл бұрын
Really a great feature - just in time for the ongoing budget meetings, I will introduce this to some colleagues just tomorrow... ;)
@Stef1955 Жыл бұрын
You are getting close to 2m subscribers!!! I subscribed at 66k!
@LeilaGharani Жыл бұрын
Wow, thank you for staying with us!
@siyabulelatshali1012 Жыл бұрын
Another productive video. Thank you.
@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.
@Alexa_Eordogh Жыл бұрын
It's so great! I'm super happy about this feature.
@MahmudSupplyChain Жыл бұрын
Great one Leila. Thanks
@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.
@abdulsaidmkamara7305 Жыл бұрын
It's a lovely feature that I have used already in my presentations.
@louiselane806 Жыл бұрын
This is excellent, thank you, useful for training, I'm looking at becoming an Excel Tutor so this would be really helpful
@sanketamin4279 Жыл бұрын
This is going to put teams on top for collaborative environment
@SachinGupta-bk8mt Жыл бұрын
That's great, thanks. I'm gonna apply this now and be a Pro ☺️
@rashidbakhsh9781 Жыл бұрын
Cool feature 👏👏👏
@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.
@shyamnarayan6788 Жыл бұрын
Awesome
@Hyopai82 Жыл бұрын
game changer
@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 😁
@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.
@rhoni0830 Жыл бұрын
You had me at being able to zoom in!!
@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
@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.
@nelpono7863 Жыл бұрын
Nice
@janineh5783 9 ай бұрын
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?
@aftabahmed-hc1rn Жыл бұрын
We are using its good fearture.
@yulinliu850 Жыл бұрын
Great for Excel training too.
@j.ballsdeep420 Жыл бұрын
No
@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
@hansklein3649 Жыл бұрын
Excel's live version is booting in MS Teams. ®🌊⛵
@usmaniqbal1836 Жыл бұрын
Perfect! Please share data files for better practice..I hope
@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.
@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?
@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?
@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)?
@naushadahmad5303 Жыл бұрын
Good morning
@hoffness Жыл бұрын
This cool, I'm have to bug IT about this! I'm hoping cross-org functionality comes soon. :)
@chrisp267 Жыл бұрын
Okay, already available in Google sheets and meet.
@roopinderpalsinghrandhawa9846 Жыл бұрын
It is cool. Teams is like the new everything software from Microsoft.
@j.ballsdeep420 Жыл бұрын
Almost like they planned that...
@ExcelAZ Жыл бұрын
👌
@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!
@mikaelgrindbo5883 Жыл бұрын
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.
@waleedibrahim4558 Жыл бұрын
Hi Leila. Thank you for all your informative videos. I have a question which I didn't find any video about it from you or others, If I have a certain number in a cell like for example 20 in cell E2 and I want to increase it either by 0.5 to make it 20.5 or 1 to make it 21, but this increase should be based on either certain text in another cell or based on a number in another cell, how can I do that?. I hope you can find time to answer this very soon. Thanks again
@Sizganov Жыл бұрын
Thx 4 video
@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
@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
@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.
@paulmfti Жыл бұрын
Nice feature….remote collaboration via office just leveled up….
@LeilaGharani Жыл бұрын
👍
@williammorehead3557 Жыл бұрын
Any timeline on when this will be brought out of Beta and integrated into the every day Teams / OneDrive software?
@ranaganguli2892 Жыл бұрын
Hi laila... Please make a video on how to send mail different person with their name with same subject through Outlook
@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.
@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?
@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.
@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"
@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
@menoo94 Жыл бұрын
Please could you advise me which is better for Excel & PowerPoint (office) as laptops intel laptops or AMD laptops ?
@johndorian4078 Жыл бұрын
Hopefully ESPN will pick this up for their championships.................
@kartikeyarora312 Жыл бұрын
The changes made by viewer in the excel file would be saved in the default file or not?
@johneylloyd Жыл бұрын
Hi Leila, How to add st, nd, rd, th in excel and how to include the same in concatenate formula
@tiagodalzotto963 Жыл бұрын
Is it possible to use this with Excel files that have macros?
@georgetovar5976 Жыл бұрын
Dangit I don’t have public preview. When does this get fully released?
@peterroger249 Жыл бұрын
I am new to Exel. Thank you for your KZfaq 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?
@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!) :-(
@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.
@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?
@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!
@RodoElshoff Жыл бұрын
What would be a reason for IT to not want to enable it?
@shahabshoukat5346 Жыл бұрын
How to send salary slips to individual employee once
@stevehall2717 Жыл бұрын
IT isn't ready for our organization to allow Public Preview
@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 ?
@jajwarehouse1 Жыл бұрын
Does UNDO follow each individual's or everyone's actions?
@j.ballsdeep420 Жыл бұрын
Hoof, expensive question
@alvarorodriguezlasso Жыл бұрын
Like
@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
@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
@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
@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 Жыл бұрын
🥰🙌
Leila Gharani
Рет қаралды 198 М.
Leila Gharani
Рет қаралды 1,8 МЛН
Matterhorn Business Development
Рет қаралды 1,4 МЛН
Efficiency 365 by Dr Nitin
Рет қаралды 143 М.