Пікірлер
@nunomics
@nunomics Ай бұрын
Hi, can you tell me please if you have a essentials acount and create a meeting, all members have to had essentials account to be 300 people at meeting? Thanks
@drewsoffice
@drewsoffice Ай бұрын
Hi - thanks for reaching out. If the meeting organiser has an Essentials account - then that is what determines the 300 attendee limit. Therefore attendees joining from a Free account, for example, would not experience any restriction.
@nunomics
@nunomics Ай бұрын
@@drewsoffice Thanks. Cheers.
@freepilot7732
@freepilot7732 Ай бұрын
Great job.... If I may ask for help? Is this possible? Could the dependant list be dynamic and it applies it to the drop down list? Example... Cell A1 is my dropdown list location. If B2=1.Then.... The drop down list (A1) will show. A, B, C to choose. BUT.... If B2=2 Then A1 drop down list will automatically change the choices to D, E, F. Continued.... But If B2=3 Then my drop down list in A1 will now show choices G, H, I, J, K. Another words your dependent list still changes it's list of choices based on your CONTINENT value but that value isn't selected from a list but a value provided by being typed in or provided elsewhere yet again your dependent list so changes.?
@drewsoffice
@drewsoffice Ай бұрын
Hi. Yes this is possible with the IF or IFS function. You would need to nest separate INDIRECT statements inside the IF statement to call the different named ranges. Send me your spreadsheet, I will have a look for you :)
@freepilot7732
@freepilot7732 Ай бұрын
I appreciate your quick response. Funny how just asking the question and following your video I figured it out and it works. After Two months of trying. Thank you. Cheers.
@gbrooking
@gbrooking 2 ай бұрын
Drew, is there a way to obtain this spreadsheet? Thanks!
@drewsoffice
@drewsoffice 2 ай бұрын
Hi, I will upload and share a link - stay tuned!
@drewsoffice
@drewsoffice 2 ай бұрын
Here is the link to download Tennis spreadsheet: www.dropbox.com/scl/fi/ubhkhfm3bswt3ku2wtico/11-Wimbledon-Excel-Sheet-EXCEL.xlsm?rlkey=xs6uvjc0ud72y21i4dy0azm2a&st=wb61c1tv&dl=0?dl=1
@gbrooking
@gbrooking 2 ай бұрын
@@drewsoffice Many, many thanks!
@gbrooking
@gbrooking 2 ай бұрын
@@drewsoffice If I want to add players, should I just add them to the end of Round 1 Players list?
@drewsoffice
@drewsoffice 2 ай бұрын
Hi, yes the Round 1 Players table is the master!
@slasheddepot
@slasheddepot 2 ай бұрын
Thank you for making this video because i was stressing why i dont have the teams app in my free plan
@drewsoffice
@drewsoffice 2 ай бұрын
You're very welcome!
@Shreyo.69
@Shreyo.69 Ай бұрын
Smaeeeeee I was ssooooo pissed I couldn't find that
@brightfringe
@brightfringe 8 күн бұрын
I wanted to add the onenote classnotebook featue. but don't have the premium . I've a school email but when I try to sign up it doesn't support it.
@Van_Wilder
@Van_Wilder 3 ай бұрын
Hi there, instead of using three rows for three different selections, I’ve made mine to be one. Everything works well but I was wondering if there’s a way that after one has gone and changed your selection to a different continent, is it possible to have the first country of the newly selected continent show up dynamically in the drop down list. Currently everything changes to the correct drop down list in background but you’ll only notice it once you make a country selection. Prior to making a selection, the country from the previous continent still shows up after you’ve changed continent.
@drewsoffice
@drewsoffice 3 ай бұрын
Hi Van - thanks for your message. According to how you describe, this can be achieved using the VLOOKUP function. If you email your spreadsheet to me, I will take a look and find a solution for you. [email protected]
@AhtshamBinshahid
@AhtshamBinshahid 3 ай бұрын
Great job ❤
@drewsoffice
@drewsoffice 3 ай бұрын
Thank you! Cheers!
@abdulsalam935
@abdulsalam935 4 ай бұрын
Sir, Very very good explanation. Please provide EXERCISE FILE to practice.
@ShahZafar
@ShahZafar 4 ай бұрын
I don’t understand
@drewsoffice
@drewsoffice 4 ай бұрын
Hi - have a look at some of my older videos for absolute beginners. You may need to understand some Excel Basics and the come back to watch this video again.
@NareshYadavJ
@NareshYadavJ 5 ай бұрын
thanks. this was helpful
@drewsoffice
@drewsoffice 5 ай бұрын
Glad it helped!
@pmorse3653
@pmorse3653 5 ай бұрын
Are all these factors true only for the host? Ie, if i am invited to a call on teams, do i need to pay to join the call? thank you
@drewsoffice
@drewsoffice 5 ай бұрын
Hi, with Teams you can join a call for free....up to 30 hours for a one-to-one call.
@cmdramethyst.8625
@cmdramethyst.8625 5 ай бұрын
Thanks for this Drew - it's really well presented, and the way you explain it has genuinely helped me to better understand *how* the formula works, as well as what it can do =]]
@drewsoffice
@drewsoffice 5 ай бұрын
You're very welcome!
@KCyou1
@KCyou1 5 ай бұрын
👏🏿 giving ideas for use of another service like ChatGPT through a well polished training video. This is multi level knowledge 👏🏿🧠
@drewsoffice
@drewsoffice 5 ай бұрын
Much appreciated!
@akosisupercute4749
@akosisupercute4749 5 ай бұрын
I like Ur videos specially about teams. I also notice that your new in tutorial videos. I suggest you do more videos for begginers. Teams for beginners, zoom for begginers, focus on beginners 😊
@drewsoffice
@drewsoffice 5 ай бұрын
Hey - thank you for your post - this is great feedback!
@hassanmaje5849
@hassanmaje5849 5 ай бұрын
I abandoned Teams for Cisco WebEx. It has same, more and better features for personal use. Contacts list though is a small trade off. Bad experience with Teams. It presented me with duplicate log in accounts - both with same ID and credentials. Secondly, opening a new chat creates myself as a user who joined. It seems it's treating me as another user in addition to myself. Thirdly it messed up contacts - it copied my Google accounts contacts on to MS365 Hotmail/Outlook contacts which i keep separate from Google, and i didn't want that. I had to manually delete the contacts from Outlook account manually!
@hassanmaje5849
@hassanmaje5849 5 ай бұрын
I know of paid personal MS365 subscription plan that has Teams identical to that of a free plan. Why is that so? On it, on the left panel, there is no Teams icon which has Channels inside (instead, it has a community icon), no Calls icon, also no recording functionality as you mention, etc etc. I know enterprises and businesses have all features of Teams. Microsoft are not explicitly clear and there is confusion. Am I missing something?
@drewsoffice
@drewsoffice 5 ай бұрын
Hi, yes you are correct, a Personal plan does not include business MS Teams. Microsoft Teams (free) comes pre-installed in Windows 11. I see that channels can be created inside of Communities and permissions/invites seem to work in the same way. Let's ask everyone else - what has been your experience with Teams (free) vs Teams (paid)?
@drewsoffice
@drewsoffice 5 ай бұрын
Ready to up your Excel game? Drop your questions or share your success stories below.
@drewsoffice
@drewsoffice 5 ай бұрын
Ready to turbocharge your data analysis? 💼 Drop your SUMIFS success stories or burning questions below, and let's unlock the full potential of Excel together!
@drewsoffice
@drewsoffice 5 ай бұрын
🔪 Excel Data Slicing 101! 🔍 Ready to slice and dice your Excel data like a pro? 💼 Drop your challenges or success stories below and let's conquer Excel together!
@drewsoffice
@drewsoffice 5 ай бұрын
🤔 Got Excel Questions? 🚀 Drop your thoughts below and let's tackle Excel together!
@mattdupuis9811
@mattdupuis9811 5 ай бұрын
Well done!! 👏👏 Extremely well layed out and explained. 👌 A good understanding of these seemingly basic functions are paramount while working through more complex tasks in Excel. I wish I would have had this years ago when I was learning these techniques. A+
@drewsoffice
@drewsoffice 5 ай бұрын
Hey Matt - very kind words indeed. I'm glad the video was helpful and appreciate you taking the time to comment and feedback.
@cesarpena-quevedo8033
@cesarpena-quevedo8033 6 ай бұрын
I got an error when using the INDIRECT function
@drewsoffice
@drewsoffice 6 ай бұрын
Can you share more details?
@stewartwilkinsonsnr
@stewartwilkinsonsnr 6 ай бұрын
Excellent video just what I needed to set up my excel spreadsheet many thanks 👍👏
@drewsoffice
@drewsoffice 6 ай бұрын
Thank you very much for taking the time to message. Glad the video was helpful
@aboyhya612
@aboyhya612 6 ай бұрын
Can i have more than one meeting per day in the free version?
@drewsoffice
@drewsoffice 6 ай бұрын
Of course my friend. You will only be restricted as to how many people can attend each meeting and which features will be available - as described in the video.
@marcogiubar
@marcogiubar 7 ай бұрын
Great music! And the tips too!
@drewsoffice
@drewsoffice 7 ай бұрын
Glad you liked it!
@rodyeltabaa6871
@rodyeltabaa6871 7 ай бұрын
Nice video. I have found a efficient and simple way to reference to every table in workbook in a drop down list then reference to its headers in another drop down list and finally get a unique list of that column in a 3rd dependent drop down list.... only using the indirect fuction.... happy to share my findings with you 😊
@drewsoffice
@drewsoffice 7 ай бұрын
Thanks. Your method sounds interesting...please do share
@KCyou1
@KCyou1 8 ай бұрын
Think I might need a drone. 👏
@drewsoffice
@drewsoffice 8 ай бұрын
You should!
@raymondodhiambo1214
@raymondodhiambo1214 8 ай бұрын
Awesome.
@drewsoffice
@drewsoffice 8 ай бұрын
Thank you! Cheers!
@scotchperson
@scotchperson 8 ай бұрын
THANK YOU SO MUCH
@drewsoffice
@drewsoffice 8 ай бұрын
You're welcome!
@soniaouargli6547
@soniaouargli6547 9 ай бұрын
Perfect timing to get us all in the Christmas spirit! #letthecountdownbegin
@drewsoffice
@drewsoffice 7 ай бұрын
And a happy Christmas to you :)
@Astrologyenergy
@Astrologyenergy 11 ай бұрын
You just made me fall in love with excel even more! I really need to find a way that I could take classes just for formulas and VBA language! All of the events MSL Classes goes over things that I'm not interested in. 000 I don't what video tutorials or webinars… I can do it online, but it have to be interactive where I can ask the trainer questions instantly. Anyway thanks for this sweetie. 😍
@drewsoffice
@drewsoffice 11 ай бұрын
Hey Shonda, thank you so much for your kind words and for taking the time to share them. You sound like you need a bespoke training programme - that you can tailor just to your requirements. I could certainly help with that...
@Astrologyenergy
@Astrologyenergy 11 ай бұрын
@@drewsoffice Okay, thanks!
@TheOzzyOsmanKHR
@TheOzzyOsmanKHR Жыл бұрын
Very helpful vid, I was wondering why I’ve got communities but I realise I need to pay to get the standard teams functions
@drewsoffice
@drewsoffice Жыл бұрын
Glad you enjoyed it. Yes...you may need the paid version to add external members. Check out my other video re M365 Subscriptions kzbin.info/www/bejne/a3PGm4uroNCtf6c
@KCyou1
@KCyou1 Жыл бұрын
Simple & useful.👍
@drewsoffice
@drewsoffice Жыл бұрын
Glad you liked it
@KCyou1
@KCyou1 Жыл бұрын
All this time never knew F4 added the $'s. Something for everyone!!💪
@drewsoffice
@drewsoffice Жыл бұрын
One day I will make a video of the best shortcut keys in Excel
@pradeepsp8079
@pradeepsp8079 Жыл бұрын
Very nice video 📷
@drewsoffice
@drewsoffice Жыл бұрын
Thank you so much...really glad you enjoyed :)