Microsoft Tutorials

Microsoft Teams: March 2021 Update: New features, New look

6 new features and improvements in Microsoft Teams update from March 2021 to do with meetings, calendar, Outlook, navigation and more.

PowerPoint Presentations in a Teams Meeting: Improvements and New Features

Several great improvements for PowerPoint presentations during a Teams meeting: speaker switch, high-contrast view, speaker notes and more.

Microsoft Outlook on the Web - the FILE view feature is incredible!

Microsoft has a “File” view in Outlook on the Web, that makes it easy to find any document and photos.

Year-Over-Year Growth - Excel PivotTable

Year-Over-Year (YOY) growth compares one period, usually a quarter or a month, against the same period twelve months before. You can compare Q3 of 2021 against Q3 of 2020. Another example is comparing the month of September 2021 to September 2020.

Excel PivotTable - Summarize data by Month or Day of the week

I need to know what day of the week is my most profitable. PivotTables and the TEXT function in Excel can easily determine this for me.

Outlook on the Web - 7 cool features

Outlook on the Web keeps rolling out new features. In this video, I cover seven features in Outlook that I love. Start a Teams chat in Outlook, work with sending and receiving attachments using OneDrive for Work, use undo send, suggested replies, and sent later.

Excel Charts - three methods for filtering Chart Data

Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video, I show three methods of filtering chart data. Method 1 is using Chart Filters. This is the easiest method.

Word: Insert Electronic Signature multiple ways including AutoCorrect

Need to add your electronic signature to a Word document? It is effortless to do. In this video, I'll show three ways to add your electronic signature to a Word Doc, how to correctly resize your signature, and wrap the text shows it shows correctly in the document.

Microsoft Forms - 5 things you may not know you can do in Forms

With Microsoft Forms, you can easily create surveys and polls to collect customer feedback, measure employee satisfaction, and organize team events. You can print a blank form, shuffle questions, allow receipt of responses, add a logo to your form, and use Forms in Teams.

Excel: Covert decimal hours Excel's hours & minutes (8.25 to 8:15)

I'm frequently asked how do I change decimal hours to Excel's hour and minute format. A couple examples: 7.75 need to show as 7:45, and 30.25 needs to show as 30:15. The solution is to divide by 24 hours. The formula is hours/24.

Microsoft Forms - Show Progress Bar on Surveys, Polls, and Quizzes

Microsoft Forms is an excellent tool for creating surveys, quizzes, and polls. Did you know you can add a progress bar to a Forms survey or quiz? A progress bar makes it easy for users to see how many pages they have left to complete.

Outlook - make Teams Meeting the default and Meet Now Feature

The Outlook desktop client now allows all meetings to be Teams meetings by default. No longer do you have to remember to click the Teams Meeting add-in icon in the ribbon. Another new feature in Outlook is you can now have a Meet Now meeting in Teams.