Microsoft Tutorials

OneDrive - FAQ about Microsoft's OneDrive Sync Icons

OneDrive is Microsoft's Cloud storage. There are three sync icons for files and folders - cloud-only, locally available, and Always keep on this device. I answer the following questions in this video.

Excel AVERAGE excluding the highest and lowest values | TRIMMEAN Function

When you have a range of numbers in Excel and want to figure out the AVERAGE but you have some extreme values that can skew your averages, there is a function that helps solve that problem.

Auto-Refresh STOCKS in Excel | Pull Live Stock Data in Excel | New Feature

The STOCKS data type in Microsoft Excel required manual refresh until now. A new feature released for Microsoft Excel on Desktop for Windows, Mac as well as Excel on the Web, fixes that problem, by allowing you pull almost live stock data into Excel.

Excel Charts vs PivotCharts | Comparison | Which is Best?

Which is best in Excel? Classic CHARTS or PIVOTCHARTS? In today's Excel video, I show you both ways of creating charts in Excel, show you step by step what's involved in each method and which one is the most flexible, powerful and which one I prefer.

Excel Distinct Count with a PivotTable

PivotTables in Excel can create a Distinct Count. An example of a distinct count is we had five orders in one day, but three orders were placed by the same customer. I want to know we have five orders from three customers.

Saving Chats and Conversations in Microsoft Teams | 5 TIPS

Saving chats and channel conversations in Microsoft Teams helps you reference old discussions, go back to questions or things you want to remember from your conversations with your colleagues.

Calculated Items in an Excel PivotTable

Excel PivotTables have calculated fields and calculated items. In this video, I'm going to take a field called Year, which has 2022 and 2021 in it and create a calculated item.

Insert Online Videos in Microsoft Word and Troubleshooting Tips

Inserting videos from the web inside a Word document is easy. You can link to a video from a document, using the Insert Hyperlink function, but you are also able to insert the actual video in Word, so it shows the thumbnail and you can access playback.

OneDrive Five Frequently Asked Questions (FAQ) Answered

OneDrive is Microsoft's cloud storage where you can store, share, and sync your work files. In this short video, I answer five frequently asked questions about OneDrive for Work or School.

PowerPoint Hide & Unhide slides now have different commands

In PowerPoint, it was unclear how to unhide a slide. Previously, when you wanted to hide a slide, you right-clicked the slide and selected Hide. But to unhide the slide, the command still showed Hide instead of Unhide. Now, the command for unhiding is correctly labeled Unhide Slide.

Teams online training course

Teams online training course with Chris Menard. Go from beginner to pro in this fast-paced training course.

OneNote - SORT PAGES - New Feature - 2022

Previously, in OneNote, if you wanted to sort pages, you had to drag them around manually. Now, you can sort your pages in OneNote automatically!