PS Tech MSP
PS Tech MSP
  • 23
  • 17 515
Unlock Excel's Full Potential: Pro Tips - Part 1 (Webinar)
3:08 - How to find Microsoft's list of shortcuts for Excel
3:56 - Navigation
5:41 - More Shortcuts demonstrated
7:21 - Select, move, copy and paste data
13:58 - Quick data analyses and calculations
15:58 - Formatting data to make it clearer
18:45 - Power Query - importing and formatting data from external sources
Whether you're a beginner or an experienced user, this session is packed with expert tips and techniques to elevate your skills and transform the way you use Excel.
Subscribe to our channel for more tutorials and expert tips on Microsoft Excel and other productivity tools.
มุมมอง: 98

วีดีโอ

Why Should I Upgrade to Windows 11? - Lunch & Learn Webinar
มุมมอง 184หลายเดือนก่อน
In this webinar we look at some of the Windows 11 features and improvements and compare them alongside Windows 10. We also look at reasons why you should upgrade and provide step by step how to upgrade. 2:30 - Why upgrade to Windows 11? 6:38 - Myths about upgrading to Windows 11 7:49 - Windows 11 improvements 8:58 - Comparing Windows 10 and Windows 11 side-by-side 18:01 - How to upgrade to Wind...
How to use the New Microsoft Planner - Lunch & Learn Webinar
มุมมอง 3.5K2 หลายเดือนก่อน
The New Planner in Microsoft 365 is here! What is it and how does it differ from the current edition of Planner? In this month's Lunch & Learn webinar, we took a look at how to use the New Planner tool in Microsoft Teams, which combines your personal tasks from Microsoft ToDo with your Plans in Planner. Plus... new advanced premium features leveraging Microsoft Project Online are available for ...
How to Use SharePoint Lists - Lunch & Learn Webinar
มุมมอง 9834 หลายเดือนก่อน
We will look at how we can use SharePoint Lists features to improve team work flow and organisation. 1:10 - Use cases of SharePoint Lists 1:50 - How to get SharePoint Lists 3:03 - Getting started with SharePoint Lists online 5:48 - Creating a new Purchase Order list 13:21 - Adding data to a SharePoint List 16:35 - Viewing, sorting and formatting data in a SharPoint List 22:05 - Creating a list ...
How to be organised with Microsoft To Do - Lunch & Learn Webinar
มุมมอง 1.8K6 หลายเดือนก่อน
Organise your work (and personal) life with Microsoft To Do. 0:29 - What is Microsoft To Do? 3:42 - Configuring Microsoft To Do settings 5:03 - Smart Lists 6:06 - Creating a Task 8:39 - Creating Task Lists 9:46 - Creating a Group of Lists 10:36 - How to share a Task List 12:39 - How to integrate Microsoft To Do with Outlook 14:38 - How to integrate Microsoft To Do with Teams 15:32 - How to inte...
How to Use Templates in Microsoft Word, Excel and Outlook - Lunch & Learn Webinar
มุมมอง 8867 หลายเดือนก่อน
In this episode we master Microsoft templates - a powerful tool to optimise your workflow. Discover how to simplify document setup and maintain brand consistency with ease. We'll provide practical demonstrations on creating and utilising templates in Microsoft Word, Excel, and Outlook, tailored to boost your productivity. 0:00 - Introduction - The issues with not using templates 9:38 - Identify...
Automating Microsoft Forms for Smarter Data Handling - Lunch & Learn Webinar
มุมมอง 1.4K8 หลายเดือนก่อน
Learn how to harness automation not just to gather data, but to analyse it swiftly and effectively, unlocking insights like never before. We take a dive into Microsoft Forms, SharePoint Lists and Power Automate to show how you can automate data collection, collate responses in SharePoint Lists and be notified when certain choices in a form are made. 8:35 - Create a simple contact form for our w...
Outlook's Pro Tips for Busy Professionals - Lunch & Learn Webinar
มุมมอง 8K10 หลายเดือนก่อน
3:44 - Better time management 14:57 - How to search and filter more effectively in Outlook 19:02 - Tips for getting stuff done quickly in Outlook 28:07 - Common questions people ask 34:07 - Bonus material - Flagging emails & To-Do
Think Your Accounts Are Safe?... Think Again! - Lunch & Learn Webinar
มุมมอง 5411 หลายเดือนก่อน
What steps should we take to protect our accounts? What threats are lurking that make them vulnerable? From social media to banking, we have so many online accounts. Trying to keep them secure can quickly become overwhelming. In this webinar, we dive into some of the secrets to better protect our accounts and personal information and show you how to utilise these tips for yourself through live ...
The Big BT Switch Off - Don't Be Left Without a Voice - Webinar
มุมมอง 711 หลายเดือนก่อน
We look at BT's switch off of traditional analogue phone lines, helping you understand what it is and why it's happening. We also discuss VoIP and look at some of the features and benefits of this business phone system.
Boost Efficiency with VoIP: Best Features Explained - Lunch & Learn Webinar
มุมมอง 48ปีที่แล้ว
The world of communications has changed and will be changing even more very soon in the UK with the BT switch off of traditional analogue telephone lines. VoIP is now already used by many businesses. However, many are unaware of the features VoIP has to offer. In this webinar, we discuss the scalability and the flexibility of VoIP, auto attendant features (phone menus and custom company greetin...
Your Most Effective Security Tool? Training - July 23
มุมมอง 6ปีที่แล้ว
Discover the essential role of cyber security awareness in safeguarding small to medium-sized businesses from diverse cyber attacks in our latest TH-cam video. Uncover why your team could be your biggest vulnerability, and the critical importance of implementing a robust training strategy. Learn how to devise a comprehensive training plan to fortify your business against cyber threats. This vid...
Master Microsoft Teams - Lunch & Learn Webinar
มุมมอง 135ปีที่แล้ว
Is Teams just another meeting tool? No. We'll be looking at some basic and advanced tips in the current and new version of Teams to help you use this messaging and workspace tool to its full. 0:00 Welcome 1:16 The different versions of Microsoft Teams 3:57 Poll - What is your preferred virtual meeting system? 6:30 The Teams interface 6:56 Using Chat in Teams 8:31 Using Calendar in Teams to sche...
How to Manage Passwords Effectively - Lunch & Learn Webinar
มุมมอง 81ปีที่แล้ว
Learn how to manage passwords effectively by using a password manager. Discover the ideal storage location for passwords and find out if storing them in your browser is secure. Also, get insights on how frequently passwords should be changed. Welcome 0:00 Scary password statistics! 2:02 Risks from poor password practice 4:!2 What is good password practice? 6:41 Demonstration: Introducing the Ke...
Introducing Microsoft Loop - Lunch & Learn Webinar
มุมมอง 125ปีที่แล้ว
Have you heard of Microsoft Loop? It's one of Microsoft's latest collaboration tools. If you already have Microsoft 365 then you already have access to Loop. So why not find out what it does and how to use it? Paul Stanyer will show you all of the above in this month's FREE Lunch & Learn webinar. Welcome 0:00 What is Microsoft Loop? 1:00 Accessing Microsoft Loop 3:12 Settings options 3:40 Getti...
Backup your data. One day it could save your business - June 23
มุมมอง 8ปีที่แล้ว
Backup your data. One day it could save your business - June 23
The 3 most important areas to discuss with your technology partner - Mar 23
มุมมอง 8ปีที่แล้ว
The 3 most important areas to discuss with your technology partner - Mar 23
Important reasons to use MFA in your business - Apr 23
มุมมอง 4ปีที่แล้ว
Important reasons to use MFA in your business - Apr 23
5 quick ways to boost your business’s Wi-Fi speed - Nov 22
มุมมอง 5ปีที่แล้ว
5 quick ways to boost your business’s Wi-Fi speed - Nov 22
3 steps to better cloud security - Jan 23
มุมมอง 5ปีที่แล้ว
3 steps to better cloud security - Jan 23
3 ways to protect your business email - Feb 23
มุมมอง 6ปีที่แล้ว
3 ways to protect your business email - Feb 23
How to plan a big IT project - May 23
มุมมอง 13ปีที่แล้ว
How to plan a big IT project - May 23
SharePoint - Common Questions Answered - Lunch & Learn Webinar
มุมมอง 111ปีที่แล้ว
SharePoint - Common Questions Answered - Lunch & Learn Webinar

ความคิดเห็น

  • @hikgerguy1234
    @hikgerguy1234 3 วันที่ผ่านมา

    Very nicely presented. I've decided to bite the bullet and upgrade from Win10 now so I have some time to learn and tweak it before support for Win10 ends in October 2025. You have a very good presentation style and voice for tutorials like this. I got a LOT of info out of this and I'm now excited to upgrade to Win11! Thank you! Quick question: If I have Win10 Pro, will I upgrade to Win11 Pro? I would expect that to be the case, but I did come across one post on a forum saying that didn't happen for them. Can't imagine MS downgrading to Home version if you already have the Pro version in Win10.

    • @pstechmsp
      @pstechmsp 2 วันที่ผ่านมา

      Hi HikerGuy1234. Thank you so much for your kind comments. I am pleased you found the presentation useful, and wish you the best with your Windows 11 upgrade!

  • @usmaniqbal1836
    @usmaniqbal1836 14 วันที่ผ่านมา

    Perfect 👍 please share data file for practice

  • @ik2600
    @ik2600 หลายเดือนก่อน

    Hi, Thanks for the video! Is there a way of getting a flagged email task moved to a plan? Essentially having the email task in the plan associated with that email.

    • @pstechmsp
      @pstechmsp 2 วันที่ผ่านมา

      Hello ik2600. Please accept my apologies for my slow reply. I don't believe what you are asking is a supported feature. My assumption is that Microsoft consider a flagged email as a 'personal' task. Plans are meant for team-work. But.. I just did a Google AI search for this, and the following steps to create a task in Planner were suggested, using Power Automate. Let me know if this works. 1. Start the flow when an email is flagged. 2. Get your user profile information. 3. Create a task. 4. Use the email subject as the task subject. 5. Put it in a bucket. 6. Assign your Office365 User ID to assign the task to you. 7. Include a preview of the email body. 8. Create a URL that links to the email in Outlook online. 9. Clear the flag. Heres a link to the article with step-by-step instructions: www.padtinc.com/2022/08/22/microsoft-flow-email-planner-task-notes/ (This is provided by a third-party, so PS Tech cannot be held responsible for it's operation and effectiveness)

  • @potatotitan5625
    @potatotitan5625 2 หลายเดือนก่อน

    For some reason files attached to a task in planner are being opened only in browser version instead of directly in Teams. On user end the "File open preference" is set to "Teams" Any tips ?

    • @pstechmsp
      @pstechmsp 2 หลายเดือนก่อน

      Hi! I dont have a specific answer for you I'm afraid. What I will say is that the New Planner in Teams is new. Developments are improvements are coming later in 2024. Maybe the web interface will solve some of the missing Teams features. I hope this helps.

  • @brentmorris8626
    @brentmorris8626 7 หลายเดือนก่อน

    I work on 4 to 7 projects every month and use a separate folder for each one of them. I have about 70 different categories that represent different stages of the workflow. As emails come in for a specific project they are marked with a category. The benefit is that I can easily look into a folder and see that I have or have not received requested deliverables, scheduled meetings, etc. Additionally I take the time to mark categories to each email that is in my sent box as that folder is always linear regarding time.

    • @pstechmsp
      @pstechmsp 7 หลายเดือนก่อน

      Hey! Sounds like you have developed a great system that works well for you. I'd be interested to know how you deal with the fairly limited colour choices in Outlook for Categories, or do you just rely on the Category Name for your system and group them into colours?

  • @melisestall5090
    @melisestall5090 8 หลายเดือนก่อน

    Amazing! I am currently working on automating our HR request process. Thank you!

    • @pstechmsp
      @pstechmsp 2 วันที่ผ่านมา

      Hello Melisestall5090 I'm ever so sorry I missed your comment. I hope your practicing with Microsoft Forms worked out well for your needs. Paul.

  • @NYinSD
    @NYinSD 8 หลายเดือนก่อน

    in my old outlook it would read lone emails to me but recently the button has been removed. can the new outlook read emails back to you?

    • @pstechmsp
      @pstechmsp 8 หลายเดือนก่อน

      Hi NYinSD. The Read Aloud button is on the Home tab of Outlook. If that is missing, it may be because the Simplified Ribbon has been enabled. In the bottom right corner of the toolbar/ribbon, click the drop-down arrow, and choose Classic Ribbon. The Read Aloud button should be there. Alternatively, right-click the riccon, customise, Under All Commands, add Read Aloud to the customer ribbon. All the best and thanks for watching!

    • @NYinSD
      @NYinSD 8 หลายเดือนก่อน

      @@pstechmsp awesome! thanks for the feedback.. Actually i can see the button but it is greyed out so not available to use. i have used it for years but doesn't work now.. any suggestions? thank you in advance. i am sub to you.. gracias..

    • @pstechmsp
      @pstechmsp 8 หลายเดือนก่อน

      Hi NYinSD. Thanks for subscribing! We really appreciate the support. A quick Google Search on your problem has brought up a couple of possible solutions. You could try Adding the 'Speak' button to your Quick Access Toolbar. It may also be that the text to speech feature in Windows is not enabled or corrupted. You can remove and add voices in Windows Settings > Time & Language > Speech. Check it has the correct voice package installed. I hope this helps. Paul.

    • @NYinSD
      @NYinSD 8 หลายเดือนก่อน

      @@pstechmsp wow, thank you for your support..

  • @wachox
    @wachox 8 หลายเดือนก่อน

    thank you, was very clear and straightforward, could we have more videos on power automate with more examples?

    • @pstechmsp
      @pstechmsp 8 หลายเดือนก่อน

      Thanks for your kind comments Wachox. Maybe in the future we will plan some more Power Automate videos :)

    • @wachox
      @wachox 8 หลายเดือนก่อน

      @@pstechmsp thank you, keep up the great work