Microsoft Tutorials

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.

Excel DateDif function - difference between two dates

In Excel if you need to calculate the difference between two dates in years, month, or days, the DATEDIF function will handle it. DATEDIF is "Date & Dif".

7 reasons to enable the New Meeting Experience in Teams

Microsoft Teams has now the new Meeting Experience. At a first look it might not be as easy as it sounds, so I will walk you through all the steps you need to do and also give you 7 reasons for using the new experience.

PowerPoint / Keynote as a Virtual Background

Zoom's Virtual Background feature is trendy. It is easy to share a PowerPoint or Keynote presentation in a Zoom meeting, but now you can share that presentation as a Virtual Background. Participants can view your video imposed directly on the screen share.

Live Captions in Microsoft Teams with speaker attributions

Recently Microsoft Teams updated their live caption enhancement to a newer version. We tested the enhanced live caption feature, discussed Teams on the web, punctuation and how live captions work in recorded videos.

Excel: College Decision Helper Template

Whether you want to attend a large public university or a small private college, knowing all about the schools you're considering is essential to making a good decision.

Microsoft Teams Meetings Update: New Features for Pop-out Meetings, Focus Mode, Meeting Notes and more | July 2020

Microsoft has some major features scheduled for release for Microsoft Teams, particularly to do with Meetings

Create a Poll in an Outlook email

Outlook now allows you to quickly create a poll in an email. This works with in conjunction with Microsoft Forms, but you do NOT have to go to Forms to use this feature. You create your poll directly in the email.

Excel Automatic Data Type: Dog Breeds and Diseases

Excel's Automatic Data Types recognizes similar data. In this video, I type in different dog breeds in columns A and Excel finds the breeds and returns data information.

Zip Code data type in Excel

To use the Zip Code data type, select your zip codes, and Excel will return important information. Data includes the median household income, latitude, longitude, population by marital status

Teams download custom background images for Family Guy, the Simpsons and other shows

Fox has created backgrounds you can use as custom images in Teams meetings. The background images include The Simpsons, Family Guy, The Masked Singer, LEGO Masters, Bob's Burgers, and others.