Surprisingly comprehensive. I assumed 'what more could I learn about this topic?'.

@MyOnlineTrainingHub

Жыл бұрын

Glad it was worth your while David!

This was amazing video. Everything is perfect. Your voice is really easy to listen and i found all the anserws that i tought i need to search for days! Thank you so much🙏

@MyOnlineTrainingHub

2 жыл бұрын

So glad you enjoyed it!

Thanks Myanda for sharing this. May God bless you!

@MyOnlineTrainingHub

Жыл бұрын

You are most welcome!

Hi Mynda. Interesting collaboration features. Thanks for sharing them :)) Thumbs up!!

@MyOnlineTrainingHub

3 жыл бұрын

Thanks for watching, Wayne!

Excellent explanation Mynda!!! Thank you.

@MyOnlineTrainingHub

3 жыл бұрын

Glad you liked it, Ivan!

I am deeply appreciating your hard work and useful tips)

@MyOnlineTrainingHub

3 жыл бұрын

Thanks so much! 😊

Very concise and informative - thank Mynda

@MyOnlineTrainingHub

3 жыл бұрын

Cheers, Tony!

Thank you so much for this tip I am starting to learn Excel more i had a very good experience by learning this thank you 🥰

@MyOnlineTrainingHub

Жыл бұрын

That's wonderful to hear!

Hola Mynda, excelente video, muy claro todo

@MyOnlineTrainingHub

3 жыл бұрын

Thanks, Leonidas!

Hi, You are one of the best on Excel!

@MyOnlineTrainingHub

Жыл бұрын

Wow, thanks so much 🙏

Really great video Mynda!

@MyOnlineTrainingHub

3 жыл бұрын

Thanks so much, Chris!

Wow great features i am really excited thanks for your training

@MyOnlineTrainingHub

3 жыл бұрын

Great to hear!

Hi Mynda!Great Explanation, Trying to Persuade My Office Manager To Try Co-Authoring...Thank You :)

@MyOnlineTrainingHub

3 жыл бұрын

Good luck with that, Darryl. It’s awesome!

Excelente aula, parabéns

@MyOnlineTrainingHub

3 жыл бұрын

Obrigado!

Very well explained.. Thanks..

@MyOnlineTrainingHub

3 жыл бұрын

So nice of you :-)

Sheet views is amazing !

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it 😊

Very useful. Thank you :-)

@MyOnlineTrainingHub

3 жыл бұрын

Great to hear 😊

awesome many thanks ❤❤❤

@MyOnlineTrainingHub

2 жыл бұрын

You're welcome 😊

awesome many thanks :)

@MyOnlineTrainingHub

3 жыл бұрын

Glad it was helpful!

Thank you so much my lord

@MyOnlineTrainingHub

Жыл бұрын

My pleasure 😊

The tip about 'sheet views' (6:30) will help immediately. For some reason, up until this point, when I turn on filters, my view is showing on my colleague's screen. If I filter to just one category, my colleague's view filters to that category. Even worse, sometimes that colleague cannot clear filters! This does not happen on my other colleague's view. Why is this the case? What does colleague 2 do differently? As an immediate solution for colleague one, I will use this approach of creating my own view *first*, then filtering. Thanks Mynda!

@MyOnlineTrainingHub

Жыл бұрын

Great to hear, David!

Nice T-shirt

@MyOnlineTrainingHub

3 жыл бұрын

Thanks, Iwan!

Thanks!

@MyOnlineTrainingHub

3 жыл бұрын

My pleasure 😊

Hello Mynda, great content like always! Do you know how can I assign a specific column to a user, meaning the this user is the only person allowed to make changes in the column?

@MyOnlineTrainingHub

2 жыл бұрын

There's no security feature in Excel that does this. At best you can lock the cells in that column and give the password to the user you want to allow to edit it.

@MrBrunoptavares

2 жыл бұрын

@@MyOnlineTrainingHub Good idea! You are the best.

Hi Mynda, great video. Do I need to have separate licenses for external users to use and edit? Thx

@MyOnlineTrainingHub

2 жыл бұрын

Glad you liked it! Guest users can edit in Excel online (I think). You can test it in a browser. Make sure you’re logged out.

Very useful

@MyOnlineTrainingHub

3 жыл бұрын

Glad to hear that, Pankaj!

@dreamsunlimited0783

3 жыл бұрын

@@MyOnlineTrainingHub Thankyou for makeing such kind of video By profession i m a business Analyst please suggest some videos which can help ..

@MyOnlineTrainingHub

3 жыл бұрын

Hi Pankaj, at a minimum you should know Power Query and Power Pivot. You can see these tools in action in some of my Dashboard tutorials, and all of my Power BI tutorials, as Power Query and Power Pivot are integral to using Power BI.

@dreamsunlimited0783

3 жыл бұрын

@@MyOnlineTrainingHub Thankyou so much

Great video! Does sheet view work on an excel dashboard so that 2 or more different users can apply different slicers and get different views of the same dashboard?

@MyOnlineTrainingHub

Жыл бұрын

Yes, it will.

Can you also track rows that are deleted while transforming data using PowerQuery? Example: I have two row with duplicate IDs, but other important information still exists in the other columns. Using PowerQuery, I can remove the duplicate row by id. However, I would like the deleted row to populate to a new a table so I can find the correct ID. Thank you in advance! Your videos are amazing!

@MyOnlineTrainingHub

10 ай бұрын

You could number the duplicates and then separate the records numbered 1 and records numbered 2 (the duplicate records) into separate tables. See this tutorial: www.myonlinetraininghub.com/numbering-grouped-data-power-query If you get stuck, post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum as I won't see follow up replies to this thread.

Thanks for your video. It is possible to "point" a user to a specific view by writing into the cells something like a link to 'table1!view2' ?

@MyOnlineTrainingHub

3 жыл бұрын

You're welcome, Stefan! You could add a hyperlink for the user to click that takes them to the cells you want them to enter.

Dear Mynda, Thanks for another great video. I have had three ocassions on different users that people co-authoring in Excel Desktop, Excel Online and Excel in Teams find later that their changes did not go through at all or went through partially. All the files were in Sharepoint Sites. Any thoughts on why this might be happening? I know you are not a MS troubleshooter but I don't follow any of them. :-)

@MyOnlineTrainingHub

Жыл бұрын

Hi Alberto, not sure why that would be. Sometimes my OneDrive sync tool doesn't connect properly and I have problems saving the changes, but this is rare.

@ajzambranop

Жыл бұрын

@@MyOnlineTrainingHub Thanks for the comments and keep it up! :-)

Great video. This may solve the issues that I have been trying to fix. Several Questions: 1. Does everyone need to have 365 or just the owner of the book 2. If the file is saved on my onedrive, do they need to save the link to keep accessing it or do they save the file to their drive too? In other words, once I share the link how do they keep accessing the file? 3. One reason I would prefer to use excel over sheets is that I want to protect the cells that have formulas, while allowing the user to enter data in other cells. I assume that I will be able to do this using a shared 365 spreadsheet. Thanks again.

@MyOnlineTrainingHub

3 ай бұрын

Thank you! 1. I'm pretty sure that as long as you set the link up with "anyone with the link can edit", then the users don't need 365 but they will have to open the file in Excel Online. 2. Yes, they need to click the link to open the file each time in Excel Online. 3. Yes, you can set worksheet protection on specific cells.

@gpclarkejr

3 ай бұрын

@@MyOnlineTrainingHub Thank you for such a quick response. You are truly awesome!

Happy new year and I would appreciate if you could refresh my memory. Do all co-authors need to use their Desktop Excel to edit or this can be done on either Desktop or Web Excel? What are the cons and pros, if any?

@MyOnlineTrainingHub

Жыл бұрын

You can use either. Web version doesn’t have all Excel functionality.

@moesadr3342

Жыл бұрын

@@MyOnlineTrainingHub Thank you!

Hi Mynda, thanks for the video. I am evaluating MS excel for collaboration and have a question: Let's say I have a paid personal Microsoft 365 subscription and have saved the file on my OneDrive. Does the person I share the file with also need to have a Microsoft 365 subscription (and/or save the file in their own OneDrive) for this to work, or is it enough that they have any kind of MS Office/Excel license (including, possibly, no paid product but just the free Office-Online version). Would greatly appreciate if you could help me know how it would work in these scenarios. Thanks.

@MyOnlineTrainingHub

2 жыл бұрын

As long as you share the file with anyone, your users don’t need a license.

Ahhhh, Mendy and here I got so excited... Pitty not available for other products

@MyOnlineTrainingHub

3 жыл бұрын

What do you mean 'not available for other products'? What other products?

@GodWillIncreaseNitzborn

3 жыл бұрын

Hi, I mean for otger versions like Excel 2013, 2016 etc... Is it not only for office 365 with excel online?

@MyOnlineTrainingHub

3 жыл бұрын

Ah, yes. Only the latest version of Excel gets the bells and whistles!

Quick question. If I need excel to select the number above or below the average of a group of numbers, what would that formula look like? Or can it perform this function at all?

@MyOnlineTrainingHub

3 жыл бұрын

Hi Leslie, Yes, you could use some nested functions to do this. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

can this function able to link with power BI on real time as well? is there any function such as importrange (in google sheet) where we can transfer information from other file in real time? anyway, that supernice video!

@MyOnlineTrainingHub

3 жыл бұрын

Glad you liked it, Muhammad! Yes, you can connect to Excel files with Power BI using Power Query and schedule updates. Not real time, but at specified intervals. The equivalent of importrange is to use Power Query to get data from other sources.

Thanks Mynda. Very helpful indeed. How do I prevent multiple collaborators editing each other's entries. In other words, I want my students to provide certain information in the same sheet, but I don't want to allow anyone edit another's text. Is there a way to do this?

@MyOnlineTrainingHub

11 ай бұрын

Great to hear! You can't lock the cells, but you can share sections of the workbook with specific people so they know where they should be entering their data: support.microsoft.com/en-au/office/share-a-section-of-a-workbook-dd5d3385-a8f7-4a25-9283-ff505ad8ddb4

@AdelM2007

11 ай бұрын

@@MyOnlineTrainingHub Thank you

Great presentation! Any restrictions on manipulating shared workbooks with VBA?

@MyOnlineTrainingHub

Жыл бұрын

You can't execute VBA online, so that's a non-starter. However, you can execute VBA in a shared workbook that's open in the desktop app.

@liamkane101

Жыл бұрын

@@MyOnlineTrainingHub Hi Mynda, thanks for the reply. I need to build an app that hides a lot of the data entry manipulation behind some forms and where multiple teams can collaborate. Have use Google Script + Google Sheets before, but lots of companies won't allow Google Sheets in their environments. I don't need a full web app with a real database. Any thoughts?

Do you have a video on how you created the Gantt chart shown in this vid?

@MyOnlineTrainingHub

3 жыл бұрын

Not a video, but this tutorial explains it: www.myonlinetraininghub.com/excel-gantt-chart

hi there...thanks for this great video...just 1 question, what if i want to share my file in real-time with my colleagues but they cannot edit on it...for viewing purposes only...thanks

@MyOnlineTrainingHub

2 жыл бұрын

You can make it read only.

@danielbabor

2 жыл бұрын

thanks ma'am but how? 🙏😊

Real time experience in ms Excel using drive for desktop ?

Hey can u also tell us how u made that status sheet !! I already downloaded the description link but there is no description regarding that status sheet kindly guide me threw !! Thanks

@MyOnlineTrainingHub

2 жыл бұрын

I used an Excel Chart for the Gantt chart as explained here: www.myonlinetraininghub.com/excel-gantt-chart

Is there VBA code that you could use in the desktop version that would automatically populate a threaded comment with the @email in the comment to automate that process?

@MyOnlineTrainingHub

3 жыл бұрын

Probably, but I haven't tried it. Here's the documentation for the Excel Threaded Comment object: docs.microsoft.com/en-us/office/vba/api/excel.commentthreaded

Great video. I need the ability for user x to see ONLY what user x enters/edits while over 100 users update a master table. Any way to have users only see THEIR data?

@MyOnlineTrainingHub

2 жыл бұрын

Not unless you use a form for them to enter their data into: kzread.info/dash/bejne/d62nlbuNndexYtY.html

@damatar

2 жыл бұрын

@@MyOnlineTrainingHub Thanks Mynda. :) I've toyed with the idea of doing forms, but there are 24 columns of data and some users have dozens of rows, so they would need to enter the form potentially 1000+ times. Good to know, though as I work through my options. If confidentiality is on the table, I may just wind up having users save their worksheets into a folder, then user power query to combine into the master table. (The process I inherited has them email me, then I copy/paste into a master table. 0_o) Have a great day!

Can I add Name Range and Tables to add Data Validation and still use it for Real time Co-Authoring? Also is it possible to Hide one or two sheet from others, if needed?

@MyOnlineTrainingHub

Жыл бұрын

Yes, you can use defined names and data validation with co-authoring. You can share a specific region of the worksheet with users as explained here: support.microsoft.com/en-us/office/share-a-section-of-a-workbook-dd5d3385-a8f7-4a25-9283-ff505ad8ddb4?WT.mc_id=M365-MVP-5003849 (although I'm not sure this prevents them from wandering elsewhere in the file).

Hi there, I’m currently using office 2019 on my desktop, and I subscribed office 365, can I use the co-authoring feature on the 2019? Or I need to reinstall the 365 version? Thanks a lot!

@MyOnlineTrainingHub

2 жыл бұрын

You need to install the 365 version.

One question - Can you used microsoft 365 to colaberate on excel files when the file has external links/external data feed? Thanks

@MyOnlineTrainingHub

Жыл бұрын

Yes.

Can you make changes to mistakes done after saving or send notifications/emails to the guest or co-workers after some days?

@MyOnlineTrainingHub

10 ай бұрын

Yes, it's just like any Excel file where you can continue to edit it. If you want to alter co-workers to issues, you can tag them in comments.

Better than google sheets you said .. but all those features already in google sheets since way too long and it's all free for example .. version history in google sheets lets you do beside what u showed in your video: 1) revert to any old version of the sheet without loosing the last updated version. 2) copy any version to new sheet. 3) rename each version to your liking. they even took it far and created mini dashboard that track users activity and trends on the sheet so what is better exactly?

@MyOnlineTrainingHub

3 жыл бұрын

Excel can do 1, 2 and 3 too (not sure of the value of the dashboard), plus Excel has 17 Billion cells vs Sheet's 5 Million. On top of that Excel has Power Query and Power Pivot. Sheet's is fine for basic stuff, but Excel is for serious spreadsheeters ;-)

This got us started. However, we cannot tag anyone in the comments. Any suggestions on where we look to determine why?

@MyOnlineTrainingHub

2 жыл бұрын

hmmm, check you're all in the same tenant.

How does everyone find this daily Will it be saved in their desktop excel? Do they have to reopen the email? Also is there a way to add the same file into Teams?

@MyOnlineTrainingHub

2 жыл бұрын

The file is saved on OneDrive and each person opens the file on the desktop or in Excel Online or in Teams. If they open it in the Desktop client they will have the OneDrive sync tool installed so the file is constantly in touch with OneDrive and updating their view of the file.

If I want to hide certain rows or column from other user that I don't want them to see or to unhide, is it possible to do?

@MyOnlineTrainingHub

2 жыл бұрын

With workbook/worksheet protection: www.myonlinetraininghub.com/excel-workbook-protection

Wondering if there is any way to have a column showing the intial of the teammate which either created or updated a record?

@MyOnlineTrainingHub

Жыл бұрын

Not that I'm aware of, Mohammad. You'd have to get them to enter that info upon data entry.

@mohammadsadrzadeh4067

Жыл бұрын

@@MyOnlineTrainingHub Thank you!

at 3:01 you mentioned status where you have a sheet show when someone made changes. how was that made

@MyOnlineTrainingHub

3 жыл бұрын

If you follow the link in the video description to download the file you can see how it’s made.

Do you have any videos or advice on trying to solve the below message with co-authoring a shared excel sheet which is stored on one drive with 4 people using. Below message randomly appears whilst co-authoring “New version available - We cannot apply changes made by someone else” Then asks to press reopen

@MyOnlineTrainingHub

Жыл бұрын

I get this message from time to time too and I'm not sure what the fix is other than to reopen the file, sorry.

Me and some of my colleagues work in a excel document together. But since recently my colleagues dont see the changes. Everyone is correctly signed in with a good internet connection. Any idea? Especially since it worked perfectly before.

@MyOnlineTrainingHub

Жыл бұрын

Hmmm, not sure why that would be. My first thought would be to reboot all PCs connecting to the file and re-open it from OneDrive/SharePoint.

@FlyOpenBallsOut

Жыл бұрын

@@MyOnlineTrainingHub thanks for your response, i will tell them to try it.

Question. I want an excel file to be password protected only between me and the other person I want to co-author with at the same time. How do i trigger with the co-author feature that we both can only make changes together with a password when the document is opened?

@MyOnlineTrainingHub

Жыл бұрын

If you set a password to edit the file, then you and the other person you want to have edit rights can open the file in edit mode and make changes. All other users will not know the password to edit it, so they will be able to open it in Read Only mode. The password is set in the Save As dialog box > Tools drop down > General Options. Set the password in the 'Password to modify' field.

@series25a

Жыл бұрын

@@MyOnlineTrainingHub Ok awesome thanks. i will try.

I have a question can we do this on a daily basis with our colleagues without any lag.?

@MyOnlineTrainingHub

Жыл бұрын

Yes! The only lag is the time it takes to upload your edits to SharePoint/OneDrive and download the edits of your co-workers, which is minimal.

Hi. I need to know if this works with workbooks that contain queires, macros and vbs script?

@MyOnlineTrainingHub

Жыл бұрын

Yes, but keep in mind that VBA is not executable on the web, so if the file is opened in Excel Online, then the VBA won't run.

@jimbrown746

Жыл бұрын

@@MyOnlineTrainingHub Awesome thank you so much

How many user can work at a time? Is their any limitation like few dozens, hundreds or thousands?

@MyOnlineTrainingHub

2 жыл бұрын

I'm not sure if there's a hard limit. You used to be able to configure the number of concurrent users in SharePoint Server, so this may also be the case for SharePoint online.

do I need to have "track changes" on when co-authoring?

@MyOnlineTrainingHub

2 жыл бұрын

No, it automatically does it for you.

How about Macros and VBA codes, does it work in excel online?

@MyOnlineTrainingHub

Жыл бұрын

No, Macros and VBA cannot be executed online. For that you need to use scripts.

Hiding columns in Sheet Views does not work - Is that correct? I tried it but the columns hidden while creating the view will simply unhide when you jump out of that view. Switching back to that view will not re-hide those collumns. Is this a bug or is it simply not possible? Many thanks in advance!

@MyOnlineTrainingHub

11 ай бұрын

It's not possible, but you can use grouped columns and expand/collapse them: www.myonlinetraininghub.com/excel-group-and-outline-data

@vossenjonk3448

11 ай бұрын

@@MyOnlineTrainingHub Hey, thank you so much for this useful information! This will come in very handy for a usecase!

@vossenjonk3448

11 ай бұрын

@@MyOnlineTrainingHub Subscribed!

If only it worked consistently, sometimes allows co authoring and other times the same file is locked by a user. No idea why, it's random same file same staff same everything. Never found a reason or a fix.

@MyOnlineTrainingHub

3 жыл бұрын

I haven't had that problem, Gareth, but be sure to send a frown via the Help tab in Excel so the Excel team can investigate.

Can you do this with Excel 2021?

@MyOnlineTrainingHub

Жыл бұрын

No. It requires Microsoft 365.

sheet view it is not working with pivot table... any idea?

@MyOnlineTrainingHub

2 жыл бұрын

Sheet view was designed to work with Tables and other hidden/filtered content. PivotTables change the actual data in cells, so I'm not surprised this isn't supported.

@lucone1973

2 жыл бұрын

​@@MyOnlineTrainingHub first of all, thanks for your reply. In my opinion, if Microsoft is talking about collaboration systems, certain functions have to be really collaborative. Sheet view, regardless of tables or pivot tables, must be an independent viewing system for users. Otherwise it makes no sense. We hope for the future. Happy day.

So, how can this be done when OneDrive and a SharePoint servers is NOT available?

@MyOnlineTrainingHub

11 ай бұрын

There's no support for co-authoring without online access, sorry.

@dennistucker1153

11 ай бұрын

@@MyOnlineTrainingHub This is why I've turned to Google Sheets. The collaboration, ease of use and cost are just way better.

Can anyone help me? I can't tag people neisthetically - when I type "@" it doesn't highlight people....

@MyOnlineTrainingHub

4 ай бұрын

You have to be logged into Excel with the same tenant as your connections, and connected to the internet.

Why won't the project restore unless all other people editing the document have closed it down?

@MyOnlineTrainingHub

Жыл бұрын

I presume you mean refresh. The file should show updates from other users in real time.

@plasmaglowmusic1655

Жыл бұрын

@@MyOnlineTrainingHub I tried and it told me that all other users need to close the application first before I can restore a previous version.

@MyOnlineTrainingHub

Жыл бұрын

Hmmm, maybe someone checked the file out.

FIRST