Microsoft Tutorials

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.

Teams add your own virtual background directly in Teams

Microsoft has released a Teams meetings update that allows meeting participants to upload their own personal backgrounds. Teams is known for the popular blurry background effect and soon added pre-installed backgrounds. Now Teams allow custom backgrounds to be added easily.

Average Function in Excel

The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.