365 Training Hub
365 Training Hub
  • Видео 211
  • Просмотров 70 697
Excel - How to find and remove duplicates in your data
Subscribe to our channel for more Microsoft 365 tips. Give us a thumbs up if you like our content!
Managing duplicate data in Excel is a common task for many professionals. Watch this video for a step by step on how to work with duplicates.
Просмотров: 3

Видео

How to add the Copilot icon to your Teams Navigation Bar
Просмотров 122 часа назад
Got the Microsoft 365 Copilot licence yet? If so, pin it to your Navigation rail in Teams for easy access! Subscribe for more tips and tricks for M365 or get in touch to book live webinar training at your workplace. www.365traininghub.co.nz
Teams Introducing the new 'MEET' app
Просмотров 154 часа назад
Subscribe to get our latest videos for tips and tricks on working smarter with Microsoft 365. This new Meet app sits nicely on the navigation bar in Teams to provide a summary of upcoming and recent meetings. #microsoft365 #microsoftteams
Copilot how to save prompts
Просмотров 9619 часов назад
Subscribe to our channel for quick tips and tricks and longer videos on Microsoft 365 - work smarter! You can’t save Copilot prompts directly within the Copilot interface, but you can keep a record of them in a few different ways. This video just shows you how to save the Copilot suggested prompts that you like to reuse.
Copilot What is Business Chat
Просмотров 65День назад
Subscribe to our channel for quick tips and tricks and longer videos on Microsoft 365 - work smarter! Or get in touch for training at your workplace via our Live Webinar sessions - www.365traininghub.co.nz Microsoft now has officially branded their paid licence aspect of Copilot - it's called Business Chat - let's see where we can find it. #microsoftcopilot #microsoft365 #businesstips #business...
Who are the 365 Training Hub?
Просмотров 9День назад
We can help your business upskill and work smarter across the Microsoft 365 tools. Get on board with Copilot today and work smarter, not harder! www.365traininghub.co.nz
A first Campaign in Viva Amplify
Просмотров 50День назад
Subscribe to our channel for quick tips and tricks and longer videos on Microsoft 365 - work smarter! Or get in touch for training at your workplace via our Live Webinar sessions - www.365traininghub.co.nz Let's step through how to create a first campaign in Viva Amplify to distribute across different channels - Outlook, SharePoint and Teams.
Teams: How to quickly summarise Key Decisions made in a Chat - with Copilot
Просмотров 3921 день назад
SUBSCRIBE for more ways to work smarter with M365. This feature is using Microsoft365 Copilot which sits across Teams, Word, Outlook, Excel and PowerPoint. Let's harness the power of AI to make our workdays more productive. #TeamProductivity #MicrosoftTeams #aiinbusiness #MeetingEfficiency #Innovation
Teams -'Find in Chat'; how to search inside a Teams chat
Просмотров 2921 день назад
Hit SUBSCRIBE for more tips to work smarter across Microsoft 365. I don't want to search the whole of Teams but just do a quick search inside one specific Chat thread - Go to the three dots for more options, top right of the Chat screen and select 'Find in Chat' and type in a keyword. #microsoftteamstutorial #microsoft365 #microsoftteams
Teams - How to turn off the new feature that 'Autohides' your Unused Channels!
Просмотров 37321 день назад
SUBSCRIBE for more Microsoft 365 Tips and Tricks. I like to hide the channels myself that I'm not currently using - I don't want Teams to do this for me! Do you feel the same? If so, this video is for you - we can turn off this setting together!
How to delete a File from a Teams Chat
Просмотров 3821 день назад
Hit SUBSCRIBE if you'd like more tips and tricks for working smarter across Microsoft 365! If you've sent the wrong file or it's now out of date - you'll need to delete the original post that you sent with that file in it - in order to remove the file from the chat www.365traininghub.co.nz
How to create percentages in Excel
Просмотров 2321 день назад
Subscribe for more M365 Tips and Tricks! Understanding percentages in Excel can transform your data analysis, budgeting, and strategic planning.
Late for a Teams Meeting? Let Copilot 'Recap the Meeting So Far' for you!
Просмотров 1328 дней назад
Subscribe for more M365 tips and tricks! I'm using the paid Copilot licence inside Microsoft 365 and I love this new feature - use the prompt to 'recap the meeting so far' - no more excuses! Visit us www.365TrainingHub.co.nz for live webinar training at your workplace.
How to use Copilot for Translation
Просмотров 9328 дней назад
Subscribe to our channel for more tips and tricks across Microsoft 365! I love that Copilot makes it so easy to talk with people in their native language. Let's remove language barriers and connect better across cultural divides.
Why do I use Copilot inside Microsoft Edge?
Просмотров 11428 дней назад
Subscribe for more Microsoft 365 tips and tricks. I use Copilot all day for more and more tasks. People ask me but why do I need it, what would I use it for? AI is not going to replace jobs, but jobs will be replaced by people who know how to use AI - let's embrace it and get on board!
From chaos to clarity with Copilot's help - How Copilot saved us hours
Просмотров 85Месяц назад
From chaos to clarity with Copilot's help - How Copilot saved us hours
How to post on your Viva Engage Community
Просмотров 328Месяц назад
How to post on your Viva Engage Community
How to use Viva Engage for a Marketplace at Work!
Просмотров 165Месяц назад
How to use Viva Engage for a Marketplace at Work!
Teams : How to use the Speaker Coach Feature to get feedback on your presentation
Просмотров 153Месяц назад
Teams : How to use the Speaker Coach Feature to get feedback on your presentation
Microsoft Planner - how to create a personal plan
Просмотров 486Месяц назад
Microsoft Planner - how to create a personal plan
How to view all your Plans in one place - Microsoft Planner
Просмотров 152Месяц назад
How to view all your Plans in one place - Microsoft Planner
How to remove a background of an image in PowerPoint
Просмотров 40Месяц назад
How to remove a background of an image in PowerPoint
How to add Checkboxes to your Excel Spreadsheet
Просмотров 39Месяц назад
How to add Checkboxes to your Excel Spreadsheet
How to find the Copilot sidebar to summarise PDF files
Просмотров 101Месяц назад
How to find the Copilot sidebar to summarise PDF files
Tools to Manage Files on SharePoint
Просмотров 59Месяц назад
Tools to Manage Files on SharePoint
How to catch up on Teams meetings you've missed
Просмотров 190Месяц назад
How to catch up on Teams meetings you've missed
How Teams Premium lets you brand your Teams meetings
Просмотров 25Месяц назад
How Teams Premium lets you brand your Teams meetings
Outlook Hacks: Managing Back-to-Back Meetings Without the Burnout
Просмотров 909Месяц назад
Outlook Hacks: Managing Back-to-Back Meetings Without the Burnout
How Copilot can help you prepare for the week ahead
Просмотров 96Месяц назад
How Copilot can help you prepare for the week ahead
Teams and Copilot - Recap my Meeting so far
Просмотров 42Месяц назад
Teams and Copilot - Recap my Meeting so far

Комментарии

  • @edwarddavies4719
    @edwarddavies4719 7 дней назад

    This option has disappeared in recent weeks. I'm on version 24231.508.3099.9629 and the toggle under General in Settings has gone!

  • @aigriffin42604
    @aigriffin42604 10 дней назад

    Why do you not have permission to like the video?👍

  • @aigriffin42604
    @aigriffin42604 16 дней назад

    Sorry I couldn’t decide whether to subscribe or not!❤

    • @365traininghub2
      @365traininghub2 15 дней назад

      Do you mean 'Subscribe' to the '365 Hub'? We'd love your support, and you'll love the training! Here's the link kelly-coyle.mykajabi.com/offers/fsAV2KtN/checkout

  • @randomlysatisfying6064
    @randomlysatisfying6064 27 дней назад

    Exactly what i was searching for, straight to the point! Thank you!!👍🏼👍🏼👍🏼

  • @yulingl649
    @yulingl649 29 дней назад

    Thank you so much for this video! I had trouble with sharing the files with external users on the New MS Teams that my organisation has been updated to. Luckily I found this video and it helped me! Thanks again!

  • @tipigolaboski9643
    @tipigolaboski9643 Месяц назад

    Always prefer to Uber myself!

  • @TS-fr7ch
    @TS-fr7ch Месяц назад

    Thank you. Very nice explanation

  • @aigriffin42604
    @aigriffin42604 Месяц назад

    What happened to the Indian Female Siri voice?❤

  • @yvizcaya1
    @yvizcaya1 Месяц назад

    Does this video have audio?

    • @365traininghub2
      @365traininghub2 Месяц назад

      Hi, no sorry it doesn't - will include more videos with sound now. thanks

  • @aigriffin42604
    @aigriffin42604 Месяц назад

    Which version of Copilot are you talking about?❤

    • @365traininghub2
      @365traininghub2 Месяц назад

      Hi @aigriffin42604- I'm working with the Microsoft 365 Copilot that sits across all the applications.

  • @LukeChatburn-q7i
    @LukeChatburn-q7i 2 месяца назад

    I cant get the Hotdesks to appear as "Staff"

    • @365traininghub2
      @365traininghub2 2 месяца назад

      Hi - you need to stet the Hot Desks up as Users first - jump to 0.39 seconds in the video to see if that helps

    • @LukeChatburn-q7i
      @LukeChatburn-q7i 2 месяца назад

      ​@@365traininghub2 They're users without a license and they dont appear, it's been 3 days since I created the accounts - are you sure they don't need a license for this setup. Also if they dont have a license they dont have an email address that actually routes so when a booking is made the user would get a bounce back wouldn't they?

    • @LukeChatburn-q7i
      @LukeChatburn-q7i Месяц назад

      @@365traininghub2 Yeah I've done this but can't find any of them - assuming it's down to them not being licensed

    • @LukeChatburn-q7i
      @LukeChatburn-q7i Месяц назад

      Plus you get bounce backs from their emails each time you book a room

  • @aigriffin42604
    @aigriffin42604 2 месяца назад

    What is child minding?❤

    • @365traininghub2
      @365traininghub2 2 месяца назад

      You're right! It should be 'parenting'. I guess when you're juggling working from home, the 'child minding' aspect of parenting becomes another task!

  • @aigriffin42604
    @aigriffin42604 3 месяца назад

    Copilot: Your Emotional Support Companion!❤

    • @365traininghub2
      @365traininghub2 3 месяца назад

      It's going to be a crazy world ahead!

  • @aigriffin42604
    @aigriffin42604 3 месяца назад

    Your voice sounds so soothing!❤

  • @benflanagan20
    @benflanagan20 4 месяца назад

    Thank you for putting this video up, I found it very helpful. I am having a problem where an email is being sent to the desk email, I carried out the same steps as you, even though I have unticked the 'Notify the staff member' option. Do you have any ideas how to get round this?

    • @365traininghub2
      @365traininghub2 3 месяца назад

      hi @benflanagan20 - I see you have to turn that checkbox off for every single desk email. Also it looks like if you go to the Bookings Page (on left of screen under the Calendar settings ) there is also a checkbox there for email notifications. Did you see that one? The other place to check is to go into each 'Service' eg: 2 hour hotdesk and select 'edit' and check the Notifications Tab there to ensure no email notifications are being sent. Hope that helps!

  • @davidandrew5762
    @davidandrew5762 5 месяцев назад

    I tried this but the other pivot table doesn't show up.. any idea?

    • @365traininghub2
      @365traininghub2 5 месяцев назад

      Hi there @davidandrew5762 when you go back to the source data and create the second pivot table, you need to select a cell in the same sheet as the first pivot table for it to 'land' into. I'm wondering if you're just clicking through, and it is putting the second pivot on a new sheet by default. The other thing is that you have to click into the 'empty pivot' that you've created and build it. If you click away from that empty pivot frame, it will look like the pivot isn't showing up.

  • @wastwhg
    @wastwhg 6 месяцев назад

    Hi Great video... can bookings be recurring? as in User Johnny wants to use the same desk every wednesday he can do it in one booking?

    • @365traininghub2
      @365traininghub2 6 месяцев назад

      Hi @wastwhg - no, unfortunately - that's not a feature yet

    • @alexnorman1023
      @alexnorman1023 6 месяцев назад

      could 'User Johnny' put a recurring meeting in their diary for every wednesday and invite Hotdesk4? Would this automatically log a booking?@@365traininghub2

  • @mufflur
    @mufflur 6 месяцев назад

    Is there a way to have the music play by default without respondents having to turn it on

    • @365traininghub2
      @365traininghub2 6 месяцев назад

      Hey there @mufflur, no there's no option for it to play automatically. The respondents do have to click the music icon for it to play..

    • @mgbarrera1
      @mgbarrera1 Месяц назад

      @@365traininghub2 Will this be an option eventually? It's a great feature and I've used it pretty regularly but it would be great to be able to opt for the music to play automatically.

    • @YuBattousai
      @YuBattousai 16 дней назад

      @@365traininghub2 and what is the point of background music then how many people are going to click that button. I bet 99% people are just going to fill out the form without clicking the background music option.

    • @365traininghub2
      @365traininghub2 15 дней назад

      @@YuBattousai I also thought it was an unusual addition! Maybe it's for the Gen Alphas?

  • @hopcroftrick
    @hopcroftrick 7 месяцев назад

    You need to share this trick on "National Clean Your Virtual Desktop Day" - October 17

  • @hopcroftrick
    @hopcroftrick 7 месяцев назад

    No way!

  • @lucianozorzanelli58
    @lucianozorzanelli58 7 месяцев назад

    I can't find your previous videos creating Bookings Tab inside Teams

  • @adeolaolatona8012
    @adeolaolatona8012 7 месяцев назад

    Great explanation, thank you! Is it possible to not have these bookings show in my team's calendar? So that our calendars aren't unnecessarily blocked off from actual work meetings.

    • @365traininghub2
      @365traininghub2 7 месяцев назад

      Hi there, as the bookings come through into your staff's individual calendars, they can just be deleted. This won't affect the bookings made which are in the separate shared calendar.

  • @franknapolitano8302
    @franknapolitano8302 8 месяцев назад

    Interesting video thank you. Do you know if it's possible to report on bookings? We'd like to alert the staff once a week perhaps with who will be in the office and when.

    • @365traininghub2
      @365traininghub2 8 месяцев назад

      Hi there @franknapolitano8302, you could extract the data using Excel: Data>Get Data>From Online Services>From Microsoft Exchange Online> and then entering the email address associated with the booking page of the calendar. This will get you a list of activity. Alternatively, what if people just pinned the Bookings app to Teams for easy access? See this short clip: ruclips.net/video/GeHyO4HssVg/видео.html

  • @krissybassist
    @krissybassist 8 месяцев назад

    yes but these folder colours don't appear on an app on a phone/tablet- just on a desktop

    • @365traininghub2
      @365traininghub2 8 месяцев назад

      Hi there, you're right! That's annoying isn't it, maybe it's a feature that will transfer in time...

  • @Sumaiyakongkon
    @Sumaiyakongkon 9 месяцев назад

    Hi 365 training hub your video is not but have not enough view. Because of your channel us not proper customize. If you want know what is the problems of all you will ask me

  • @hopcroftrick
    @hopcroftrick 2 года назад

    Thanks Kelly. What is the third question for the third argument? (Col_index_num) - would it be: "what column number are you wanting to return?"

    • @365traininghub2
      @365traininghub2 2 года назад

      Sorry Rick - did I miss that! Yes, what is the column number that holds the content you are looking for!

  • @ReadySteadyExcel
    @ReadySteadyExcel 2 года назад

    Great idea for the Bookings app