2022 YouTube video published

Posted on:  01/02/2023
2022 YouTube video published

In 2022, we published 143 videos on YouTube. They range from Excel, Teams, Word, Outlook, and Zoom. Below is a table with the 143 videos listed. 

Highlights from 2022

  • Views 4,275,833
  • Watch time  hours 157,021
  • Subscribers gained 14,500

YouTube Views Comparison - 2022 vs. 2021

YouTube Views - 2022 vs 2021

YouTube Views - 2022 vs 2021

YouTube Watch Time Comparison - 2022 vs. 2021

In hours


YouTube Watch Time comparison - 2022 vs. 2021 (in hours)

YouTube Watch Time comparison - 2022 vs. 2021

Teams Training with Chris Menard

Chris Menard's online Teams training course is availalbe here. 


YouTube videos published in 2022

 Title  Watch Url  Date Published
Microsoft Teams - Add images to poll questions - December 2022 feature https://www.youtube.com/watch?v=tTguOywIt1w 12/28/2022
Outlook 7 Date Searches Every User Should Know https://www.youtube.com/watch?v=kavgFrFJLHc 12/20/2022
Excel Flash Fill - Getting Started with 4 Awesome Examples https://www.youtube.com/watch?v=EKXZnubYEz0 12/19/2022
Outlook - Add Day's Old field to Inbox to calculate How old is this email? https://www.youtube.com/watch?v=bJ2LOTcJGlQ 12/16/2022
Excel 7 Easy Tips Everyone Should Know https://www.youtube.com/watch?v=O1C6A2-bSLI 12/14/2022
LinkedIn: How to Record Your Name Pronunciation https://www.youtube.com/watch?v=pL-RaR7ra-c 12/12/2022
Excel PivotTable - Using XLOOKUP Function to Group Text https://www.youtube.com/watch?v=ZfqwkqsuCog 12/9/2022
Teams - Delete entire chat - New Feature December 2022 https://www.youtube.com/watch?v=tk-eGSaMntA 12/8/2022
Excel PivotTables - Group Text Fields and Tips for working in Groups https://www.youtube.com/watch?v=KGqdPGAztkY 12/6/2022
Outlook - Allocate time for Flagged Emails - Time Management https://www.youtube.com/watch?v=PrqD2_bmgRc 12/2/2022
Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watch?v=6v2aj1GE3fg 11/30/2022
Excel Tiered Conditional Formatting with Dates using functions AND and TODAY https://www.youtube.com/watch?v=uCmmuScmxQk 11/29/2022
Teams Online Course Promotion https://www.youtube.com/watch?v=KJgxWOqdZHE 11/22/2022
Excel PivotTables Percentages - Grand Total, Parent Row Total, and Parent Total https://www.youtube.com/watch?v=KSaM8JAVnSo 11/21/2022
Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting https://www.youtube.com/watch?v=qFnHYfn6yNs 11/18/2022
Excel - Filter a PivotTable with a Timeline https://www.youtube.com/watch?v=FIKqdUC92f4 11/16/2022
PivotTables - 3 Annoying Things FIXED! https://www.youtube.com/watch?v=U746wZCrq6k 11/14/2022
Excel Add Sparklines on a Separate Worksheet https://www.youtube.com/watch?v=163KG9gImPI 11/11/2022
Excel Chart Maps used with the Geography Data Type https://www.youtube.com/watch?v=iQvapFfAoEE 11/9/2022
Excel Concatenate Text and Dates with the TEXT function https://www.youtube.com/watch?v=hljBSRnKZp4 11/7/2022
Tasks by Planner in Teams - Recurring Tasks - New Feature https://www.youtube.com/watch?v=byV-dsWCrU0 11/4/2022
Excel - Insert a blank row after every row or every Nth row https://www.youtube.com/watch?v=FPu3nJBwgEc 11/2/2022
CTRL + SHIFT + V to Paste Plain Text in Excel - New feature coming soon https://www.youtube.com/watch?v=VA4C4-3sWu0 10/31/2022
Teams Send Chat Later and Record Video in Chat | New Features https://www.youtube.com/watch?v=2V2q7-6ccpw 10/27/2022
Excel Images: Two New Features | IMAGE function and Data from Image https://www.youtube.com/watch?v=57L6jkT0PaM 10/25/2022
Excel - Separate Positive and Negative numbers in the same column https://www.youtube.com/watch?v=ssxjvgXvveg 10/21/2022
Teams Meetings - Captions in your preferred language | Multiple-Language Meetings https://www.youtube.com/watch?v=IM0-UcBmwhQ 10/19/2022
Excel Freeze Panes - Freeze panes to lock rows and columns https://www.youtube.com/watch?v=KkZTsDIh3D8 10/17/2022
Excel PivotTables - Six Tips for working with PivotTable Field List https://www.youtube.com/watch?v=CEZDCNfCpEE 10/14/2022
OneDrive - Teams and Outlook folders automatically created in OneDrive https://www.youtube.com/watch?v=pKYVdm2WfiA 10/12/2022
Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote. https://www.youtube.com/watch?v=-XpEsHHzT_0 10/11/2022
Teams Chat - Send at Scheduled Time - Delay delivery of Chat messages https://www.youtube.com/watch?v=h6ZWtEvVwd0 10/6/2022
Excel New Image Function - Insert Images into cells with a Formula! https://www.youtube.com/watch?v=MerHkhCJh7c 10/4/2022
Teams - Record a Video Clip in Chat https://www.youtube.com/watch?v=G3K-aPTbI5E 10/3/2022
OneNote - Sort Sections using Onetastic for OneNote https://www.youtube.com/watch?v=h3Li6xI3r8o 9/29/2022
Excel Sparklines - 5 Tips for Sparklines https://www.youtube.com/watch?v=4FCSkeWtyM4 9/27/2022
Excel - Vertical Analysis - Financial Statement Analysis - Income Statement and Balance Sheet https://www.youtube.com/watch?v=aZuFOJrVQL0 9/26/2022
Excel Highlight Every Nth Row with Conditional Formatting - Every 3rd, 4th, or 5th row. https://www.youtube.com/watch?v=nPTl1RjJs0Q 9/22/2022
Excel Keep Leading Zeros - Text vs. Numbers - Advanced Options https://www.youtube.com/watch?v=cccFPbh8ALY 9/21/2022
Using Meeting CO-ORGANIZERS in Microsoft Teams Meetings https://www.youtube.com/watch?v=4PWxSAwXhuA 9/19/2022
Microsoft Teams Allow Everyone to Bypass Lobby https://www.youtube.com/watch?v=p5lEaybmLkw 9/15/2022
Outlook Desktop - Early preview of the new Outlook for Windows Desktop / New Features https://www.youtube.com/watch?v=pggdCMecJIg 9/12/2022
Zoom - Broadcast Audio to all Breakout Rooms - New Feature - September 2022 https://www.youtube.com/watch?v=ZFdt6FwJh_k 9/9/2022
Teams - Pop Out Content - Awesome New Feature for Meetings https://www.youtube.com/watch?v=edcRnvh4CSA 9/7/2022
Excel - Share a PivotTable without the Source Data or Underlying Data. https://www.youtube.com/watch?v=yLAOJ10vVQ4 9/6/2022
Solvency Ratios in Excel - Debt to Equity, Debt Ratio, and Equity Ratio https://www.youtube.com/watch?v=qcNJ-t-4p3M 9/1/2022
Excel Sparklines to show Trends - Mini Charts inside cells- Line, Column, or Win/Loss https://www.youtube.com/watch?v=oq8tZjwv32M 8/31/2022
Excel - How to find the Greater Common Divisor (GCD Function) and show as Ratios https://www.youtube.com/watch?v=Yb6v4uVV1oU 8/29/2022
Excel - Save a Chart as an Image to use in PowerPoint, Teams, LinkedIn or other apps https://www.youtube.com/watch?v=zRsAKbgCaEU 8/25/2022
How to Rank Duplicate Values in Excel https://www.youtube.com/watch?v=rF7EtT3rfPc 8/24/2022
Excel: Liquidity Ratios - Current Ratio, Quick Ratio, & Cash Ratio https://www.youtube.com/watch?v=c-YnvjUIwq4 8/23/2022
Microsoft Forms - Share Responses for Surveys and Polls https://www.youtube.com/watch?v=p3s826treHg 8/19/2022
Excel COUNTIF Function With Wildcard Search and Cell Reference https://www.youtube.com/watch?v=jMc9vRvbxGs 8/17/2022
OneDrive - Share a Folder as Read Only | Set Expiration Date and Password https://www.youtube.com/watch?v=T-dO0ZCbGbo 8/10/2022
Zoom Always Show Meeting Controls - Awesome Tip for Presenters https://www.youtube.com/watch?v=oIKufmJLwg8 8/9/2022
Excel STATUS BAR -  Tips Every User Should Know https://www.youtube.com/watch?v=UzdfpohAyU0 8/8/2022
Teams Online Training Course Update -  August 2022 | 12 new topics https://www.youtube.com/watch?v=8H2TyyrfDVU 8/4/2022
Excel IF Statement with ROUNDUP and ISEVEN functions | Evaluate Formula | Excel Advanced https://www.youtube.com/watch?v=7nQahWW3Ug0 8/2/2022
Teams - Change your status in Teams | Duration and Status Message https://www.youtube.com/watch?v=WAK13Odqfdo 7/28/2022
How to SORT Data in Excel | 7 Tips https://www.youtube.com/watch?v=M6AvvNQ9vf4 7/26/2022
Teams Chat with Yourself - save Notes and Reminders https://www.youtube.com/watch?v=hQjunST8qhk 7/20/2022
Teams - LinkedIn Tab now Available in Teams Chat https://www.youtube.com/watch?v=crZRNaC3Lf8 7/19/2022
Excel - Data from Picture - Microsoft 365 New Feature https://www.youtube.com/watch?v=17szFsDyMqU 7/15/2022
Excel Conditional Formatting with Dates using AND and TODAY Functions https://www.youtube.com/watch?v=QNwRLmhr_yM 7/13/2022
Excel - AutoComplete for  Drop-down List - New Feature Coming to M365 https://www.youtube.com/watch?v=nEQeAE860ag 7/11/2022
Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates. https://www.youtube.com/watch?v=eDevN_lVfUE 7/7/2022
Excel - 3 Methods to Shade Every Other Row https://www.youtube.com/watch?v=CXvc2nTwdA0 7/5/2022
Teams - 5 Tips for Recorded Meetings https://www.youtube.com/watch?v=hLxtY4ye15Q 6/28/2022
Excel - Get and Transform Data | Unpivot Columns with Two Header Rows https://www.youtube.com/watch?v=puqO4_nr_mE 6/27/2022
Google Maps Timeline - Explore and Manage Your Location History https://www.youtube.com/watch?v=pjqsg1wb_5I 6/21/2022
Google Map - Add Multiple Destinations https://www.youtube.com/watch?v=2Thsun8KzUQ 6/20/2022
Outlook Calendar - Meetings vs. Appointments https://www.youtube.com/watch?v=IRReJsd947g 6/15/2022
Excel - Three Tips for Separating Date From Time | Split cell data https://www.youtube.com/watch?v=GAwDTH20WLU 6/13/2022
Outlook - 10 Tips Every User Should Know https://www.youtube.com/watch?v=dtwYyX0YSxk 6/9/2022
Excel - 5 Tips for Excel Charts - Labels, Negative Numbers, Undock Pane https://www.youtube.com/watch?v=aGbEZr_reOY 6/7/2022
Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver https://www.youtube.com/watch?v=paQdqIhmi3g 6/6/2022
PowerPoint - Create Photo Albums - Insert Images All At Once! https://www.youtube.com/watch?v=4NfpNCY_nIc 6/3/2022
Excel Year-Over-Year and Period-Over-Period Analysis with PivotTables https://www.youtube.com/watch?v=WGTy6GKcB3Y 6/2/2022
Zoom - View Speaker Notes When Presenting PowerPoint | Presenter View https://www.youtube.com/watch?v=1Jc4-iEyK7A 5/31/2022
Word - Five Tips for Working with Heading Styles https://www.youtube.com/watch?v=tKbXkiKSD6o 5/26/2022
Teams Meetings & Calls - Make a Test Call to Test Your Speaker and Mic https://www.youtube.com/watch?v=m9WkVq0mWg4 5/25/2022
PowerPoint Edit Speaker Notes While in SLIDE SHOW https://www.youtube.com/watch?v=xib6cYMNqRQ 5/24/2022
OneDrive - Block Download of Videos - MP4 files https://www.youtube.com/watch?v=2NGniGQbvOQ 5/23/2022
Data Table in Excel - What-if-Analysis - Powerful Analysis feature https://www.youtube.com/watch?v=Rkdl0zTaytA 5/20/2022
Teams - 3 Simple Features You May Not Be Using in Microsoft Teams https://www.youtube.com/watch?v=Nn0NyJDqoDU 5/18/2022
Excel Conditional Formatting with the TODAY function | Duplicate Rule https://www.youtube.com/watch?v=ZaZZbRvI0BM 5/16/2022
Microsoft Word - Read Aloud on Mobile Phone | Proof-Listening https://www.youtube.com/watch?v=q2deQ3ShG5Q 5/13/2022
Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work https://www.youtube.com/watch?v=1gdbmqHVM3A 5/12/2022
Teams - Why You Should Always NAME Your Meetings https://www.youtube.com/watch?v=Y6yautwl5TA 5/11/2022
Excel Recommend PivotTables - Improved Experience https://www.youtube.com/watch?v=5-3i55AkOHA 5/10/2022
Teams - Group chats vs. Channel Conversations - What's Best? https://www.youtube.com/watch?v=j_Zgv4jJmbs 5/6/2022
Excel PivotTable - Calculate the number of days of each week for every month of the year https://www.youtube.com/watch?v=6q-h22YUd28 5/5/2022
Outlook on the web - Multiple time zones https://www.youtube.com/watch?v=MkMuZ-QZdoU 5/3/2022
Analyze Results from Microsoft FORMS POLLS in Excel  | Watch Chris Work https://www.youtube.com/watch?v=hH6_RUc5rp8 4/28/2022
Zoom - Central Library of Polls - New Feature - April 2022 https://www.youtube.com/watch?v=lH4fDO_-AYs 4/27/2022
Teams - How do I Delete Chat Files? https://www.youtube.com/watch?v=fRhHnz607Lk 4/26/2022
OneDrive - FAQ about Microsoft's OneDrive Sync Icons https://www.youtube.com/watch?v=EclBA0Mbhs0 4/20/2022
Teams Organizing Teams and Channels - Hide, Pin, and Rearrange https://www.youtube.com/watch?v=o-0ZEoG_k94 4/19/2022
Google Calendar - The Best Keyboard Shortcuts to Navigate and Move around https://www.youtube.com/watch?v=Kvm921T4VEY 4/18/2022
Zoom Save and Reuse Breakout Room Assignments - Zoom 5.10.0 https://www.youtube.com/watch?v=q8-mqtrRvj8 4/15/2022
Excel calculate the Median IF - two methods | Function and PivotTable https://www.youtube.com/watch?v=F6UgujanjAs 4/13/2022
Auto-Refresh STOCKS in Excel | Pull Live Stock Data in Excel | New Feature https://www.youtube.com/watch?v=f0guygUrgWY 4/11/2022
Excel Charts vs PivotCharts | Comparison | Which is Best? https://www.youtube.com/watch?v=r7Ecka2nbOA 4/7/2022
Excel AVERAGE excluding the highest and lowest values | TRIMMEAN Function https://www.youtube.com/watch?v=ooDqrMkjV48 4/6/2022
Excel Weighted Moving Average (WMA) with Customizable Weights https://www.youtube.com/watch?v=UQ_Ozwuddyg 4/4/2022
Excel Distinct Count with a PivotTable https://www.youtube.com/watch?v=C3NNQ0JtM-M 3/30/2022
PowerPoint for Web: Create Slides from Agenda Slide automatically https://www.youtube.com/watch?v=swsS4xt2BBY 3/28/2022
Saving Chats and Conversations in Microsoft Teams | 5 TIPS https://www.youtube.com/watch?v=VaEsjXzoN9k 3/23/2022
Excel Advanced - Calculated Items in a PivotTable - using percentages https://www.youtube.com/watch?v=s1FCu38B3sM 3/22/2022
Insert Online Videos in Microsoft Word and Troubleshooting Tips https://www.youtube.com/watch?v=Q9bor0yLfIU 3/18/2022
OneDrive Five Frequently Asked Questions (FAQ) Answered https://www.youtube.com/watch?v=sxZ6y9J82s4 3/16/2022
PowerPoint Hide & Unhide slides now have different commands and Slideshow Tips https://www.youtube.com/watch?v=G6vBv9yChJ4 3/14/2022
Microsoft Teams - Pin for Me and Hide for Me (hide your own video) - Meeting Features! https://www.youtube.com/watch?v=WgX32GitTKI 3/11/2022
Teams Chat - two new features | PIN chat and see more chat messages https://www.youtube.com/watch?v=ulmRF8eWUEM 3/9/2022
Excel RATE function | Scottish woman's $3 bank account becomes $335 after six decades https://www.youtube.com/watch?v=8SWVWAqWpTk 3/8/2022
Zoom Allow only Registered Email to Join Meeting https://www.youtube.com/watch?v=Gg-RZBzBGFY 3/3/2022
Conditional Formatting in Excel using Between with Dates and Number with COOL TIP https://www.youtube.com/watch?v=tW2jZsGSDoQ 3/2/2022
Zoom - Set up a Paid Webinar with PayPal - Make money with Zoom https://www.youtube.com/watch?v=T8_VTVfKnzA 2/28/2022
Excel Charts - 5 COOL TIPS https://www.youtube.com/watch?v=IIfnmKSOgKg 2/25/2022
Ally Bank Smart Savings with Buckets and Boosters https://www.youtube.com/watch?v=_sdyVz8SS7c 2/23/2022
Understand Percentage Changes in Excel https://www.youtube.com/watch?v=jywJr2cp_jQ 2/22/2022
Excel - Three tips every Excel user should know | Move column, Paste Values & Flash Fill https://www.youtube.com/watch?v=YsMBeGvGIvY 2/17/2022
Zoom Breakout Rooms - Create, Delete, and Rename Rooms while Rooms are open! - New Feature 2022 https://www.youtube.com/watch?v=9mGymxdZ-0w 2/15/2022
Conditional Formatting with Icon Sets in Excel https://www.youtube.com/watch?v=2sfgtmGyfjs 2/10/2022
Meet the Peabody Hotel Duckmaster https://www.youtube.com/watch?v=yhilFV_owVs 2/8/2022
Pin Cloud Folder Shortcuts to Windows Taskbar https://www.youtube.com/watch?v=ftEzczgMZIc 2/8/2022
Excel Moving Average with Analysis TookPak Add in https://www.youtube.com/watch?v=cbpPXLpF7Ic 2/7/2022
Zoom Waiting Room - Chat with Waiting Room Participants - New Feature 2022 https://www.youtube.com/watch?v=w_SJHNdVDko 2/4/2022
Outlook: Create Contact List using Outlook on the Web - aka Distribution List https://www.youtube.com/watch?v=Bh1NRwUtGKQ 2/3/2022
Excel: Year-over-Year (YOY) analysis w/ a PivotTable https://www.youtube.com/watch?v=RHUNVrx4uog 2/2/2022
Teams  - Training Course with Chris Menard on Teachable - Promotional Video https://www.youtube.com/watch?v=bYFBWTpiQlk 2/1/2022
Zoom - Show Video in the Waiting Room - New Feature for January 2022 https://www.youtube.com/watch?v=RGRbkrG8MXQ 1/31/2022
Microsoft Word: Re-arrange pages and content the easy way https://www.youtube.com/watch?v=k_8f774GtIA 1/28/2022
Excel - Advanced Conditional Formatting with sample Excel file - 3 examples https://www.youtube.com/watch?v=Oc_Dn_ZdZ-Y 1/26/2022
Zoom - Record Separate Audio Tracks for easy editing https://www.youtube.com/watch?v=DQlWDqosj0E 1/25/2022
OneNote - SORT PAGES  - New Feature - 2022 https://www.youtube.com/watch?v=mmVvJ4-T2XA 1/24/2022
Breaks in Microsoft Word: Page, Section, Column break with examples https://www.youtube.com/watch?v=ytJtT6Trsuw 1/20/2022
Teams - Files app to find files in chat, channels, downloads, and OneDrive https://www.youtube.com/watch?v=aV8_9MKk1sw 1/18/2022
VLC Media Player - Best FREE Media Player - Works with Windows and Mac https://www.youtube.com/watch?v=NZwPgpAzNlo 1/11/2022
Excel Conditional Formatting - Getting started with five examples https://www.youtube.com/watch?v=tzB8RN6xw5c 1/10/2022
Word to PowerPoint - Use Slides from Outline to import Word into PowerPoint https://www.youtube.com/watch?v=qR3gSkG3IoE 1/6/2022
Teams - Improved Search Feature - 2022 https://www.youtube.com/watch?v=tgsP-jiZl0Y 1/4/2022
Zoom Focus Mode with Scheduled Meetings https://www.youtube.com/watch?v=uj90JXV1PlY 1/3/2022


Lifetime access to Teams Course Beginner to Pro with coupon
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 18 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at chrismenardtraining.com/linked or watch his videos on YouTube at chrismenardtraining.com/youtube.