Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
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. **Average using Sum with Max, Min, and Count** You can calculate the AVERAGE in
Microsoft Excel
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. **Stock data type Refresh every 5
Microsoft Excel
Which is best in Excel? Classic CHARTS or PIVOTCHARTS? I will show you both ways of creating charts in Excel. I demonstrate step by step what's involved in each method, which one is the most flexible and powerful, and which one I prefer. **Charts vs. PivotCharts** We take
Microsoft Excel
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. **PivotTable with a Distinct Count** To create a
Microsoft Teams
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. In this video, I provide 5 tips that will help you find your way around the Saved messages functionality in Teams.
Microsoft Excel
Excel PivotTables have calculated fields and calculated items. In this video, I will take a field called Year, which has 2022 and 2021 in it and create a calculated item. In case you are wondering, what is the difference between a calculated field and a calculated item? That is easy
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