Microsoft Tutorials

Outlook Sweep Feature - Awesome built-in tool to keep your inbox clean

The Sweep feature in Outlook gives you options to automatically delete all incoming emails from a particular sender, to keep only the latest email, or to delete emails older than 10 days (which I use all the time). Sweep is a great way of keeping your inbox clean.

Upload Files in Microsoft Forms - New Feature!

Microsoft Forms allows you to create a survey with multiple question types. One of the NEW question types is the "File upload". So users can now upload files in a survey! This is an awesome feature. The files are stored in a SharePoint folder and automatically marked with the person's name that uploaded the files. You can specify the number of files someone can upload and the maximum file size.

Word and Outlook - Dictate with Auto Punctuation and Voice Commands

The Dictate feature in Word and Outlook has been greatly improved. Dictate will now allow Auto Punctuation, Voice Commands, and a Profanity Filter. The Dictate command works in the Desktop apps - Word, Outlook, and PowerPoint. Interestingly, the new improvements only work in Word and Outlook.

PowerPoint Presenter View in Microsoft Teams

Share PowerPoint slides in a meeting in Presenter View! If you're a presenter and choose to share a PowerPoint file in a meeting, you will have some behind-the-scenes capabilities with the new presenter view. As the presenter, you will see the current slide, your slide notes or speaker notes, and thumbnails of all the slides in your deck.

Today Function in Excel

The TODAY function is a date/time function that shows the current date based on your computer time. The TODAY function will update automatically.

Teams Channel Calendar now available - New Feature

Channels in Teams can have their own calendar. This is a great new feature that allows Teams members to quickly see upcoming channel meetings all in one place.

OneNote - Copy text from picture - 2 reasons to use this awesome feature

Microsoft OneNote allows you to copy the text from a picture or image. OneNote supports Optical Character Recognition (OCR), which allows you to copy text from an image or picture and paste it on your notes or another application, like Word or Outlook, so you can edit the text. Another incredible feature on OneNote and OCR is the text in the picture is searchable!

Three tips for getting started with Excel Charts

Charts in Microsoft Excel are easy. This short video shows three tips for creating charts. I'll cover two keyboard shortcuts for making charts, using Recommend Charts, and creating charts using Quick Analysis.

Tax Brackets Explained using Excel's XLOOKUP function

Tax brackets show you the tax rate you will pay on each portion of your income. There are seven tax brackets. The United States has a progressive tax system based on your Taxable income, not Gross income or Net Income. Your income is taxed at different rates with a progressive tax system.

PowerPoint - Free Stock Videos from Microsoft now in PowerPoint

Microsoft 365 subscribers have access to Premium Creative Content, an in-app library of royalty-free images, icons, cutout people, stickers that are available in Word, PowerPoint, Outlook, and Excel. Now Microsoft has added Stock Videos for PowerPoint. The videos are subtle looping videos.

Email mail merge: personalized emails using Excel - Word & Outlook

Need to send personalized emails to individuals all at one time? That is called an "Email Mail Merge." I'm going to use Excel, Word, and Outlook - part of Microsoft 365 - to create and send bulk emails out. The order these apps are used would be Excel, then Word, and finally, Outlook.

Roles in a Teams Meeting: Organizer - Presenter - Attendee

Teams Meetings have three roles: Organizer, Presenter, and Attendee. You have different capabilities depending on your role. We will cover all the possibilities on the roles and how to change roles.