Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Word
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. **Word - Insert
Microsoft OneDrive
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. Q1 - How do I upload a file to OneDrive? **Upload files to OneDrive** To upload a
Microsoft PowerPoint
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. **PowerPoint Hide
Finance
Ally Bank has Buckets and Boosters to assist in optimizing savings. Buckets are digital envelopes. You can have 10 buckets in your savings account. You can have buckets for emergencies, vacations, wedding, bill payments, car repairs, education, pet needs, and other buckets. You can even create your own bucket and
Zoom
Zoom has a great feature where you can separate audio tracks. Most Zoom users aren't aware that they can record audio files on separate tracks. This feature is beneficial for content creators such as Livestreams, Podcasters, and anyone doing interviews. Zoom - Record a separate audio file for
OneNote
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! OneNote sort pages This is for OneNote on the desktop version. There are four different sorts. Sort Options - Sort Alphabetical - Sort by Date
Microsoft Word
Handling complex documents in Word couldn't be easier when you understand how breaks function in Word. You can create multiple types of breaks throughout your document, to help with your document structure, leave empty space, jump to the next page, column, to the next section, or even to
Microsoft Teams
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. **Teams - Files app** The Files App is an easy way to
Microsoft Excel
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. We will look at using five easy Conditional Formatting features. We will use Conditional Formatting with text, numbers, above average, top 10 and
Microsoft Excel
Filtering data is one of the most popular Excel features. Here are five great filtering tips for Excel. 1. Filter by selected cells value 2. Copy and paste filtered data 3. Delete filtered data 4. Auto-calculate filtered data 5. Search for filtered data **Excel - Filter data tips** Tip #1
Microsoft Excel
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—such as
Microsoft Excel
Use Excel to calculate your tax liability using VLOOKUP. The Excel file is in the blog post. Tax brackets show you the tax rate you will pay on each portion of your income. For example, if you are single in 2021 and make $86,375, you are in the 22%