Microsoft Tutorials

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!

Breaks in Microsoft Word: Page, Section, Column break with examples

Handling complex documents in Word couldn't be easier when you understand how section and page breaks function in Word.

Teams - Files app to find files in Teams chat, channels, downloads, and OneDrive

Microsoft Teams handles multiple file types. The files can be located in multiple locations. Chats, Channels, Meetings, and Channel Tabs. The "Files" app in Teams is located on the Navigation Bar, also known as the Sidebar.

Excel Conditional Formatting - Getting started with five examples

Conditional Formatting is one of Excel's best features. I use it daily. In this short video, I'll get you started using Conditional Formatting.

Excel Five Great Tips for Filtering Data

Five great filtering tips for Excel. Filter by selected cells value, copy and paste filtered data, delete filtered data, auto-calculate works with filtered data, and search for filtered data.

Excel - Create a custom list to sort data

Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically.

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

How to calculate progressive tax with 2021 tax brackets and VLOOKUP in Excel, with examples. Tax brackets show you the tax rate you will pay on each portion of your income.