Chris Menard's YouTube channel hits 43,000 Subscriber - November 2022

Posted on:  11/27/2022
Chris Menard's YouTube channel hits 43,000 Subscriber - November 2022

Chris Menard's YouTube channel hits 43,000 subscribers on November 27, 2022! Menard has been an active YouTuber since 2018His technology videos cover:

  1. Excel
  2. Word
  3. Teams
  4. Outlook
  5. Microsoft Forms
  6. PowerPoint
  7. Zoom
  8. Google Calendar
  9. Gmail
  10. and other software
Chris Menard - YouTube 43,000 Subscribers - November 2022

Chris Menard - YouTube 43,000 Subscribers - November 2022

Popular YouTube Videos published in November 2022

In November 2022, we published eleven videos. Below are some of our most popular videos published in November 2022

PivotTables - 3 Annoying Things FIXED!

PivotTables are one of the best features in Excel. PivotTables allow you to summarize, analyze and chart complex data. There are 3 annoying things in PivotTables that users always ask me about. One of them is after changing the width of a column, on refresh, the PivotTable changes. Another annoying feature is blank or empty fields, and finally, data not repeating when it should. We will look at these annoying features and provide a fix for each one. 

Chapters

  1. 00:00 Introduction
  2. 00:19 Convert data to a table
  3. 00:36 Item 1 - Prevent Autofit
  4. 02:22 Item 2 - Default value for empty fields
  5. 03:42 Item 3 - Repeat item labels
  6. 05:15 Quick Review
  7. 05:46 Closing remarks

Excel - Turn on Multiple Filters in a PivotTable - Allow multiple filters per field Setting

Filter in PivotTables only allows one filter by default. To filter by more than one field, you need to turn on the PivotTable Option - Totals and Filters tab and check Allow multiple filters per field.

Chapters

  1. 0:00 Intro
  2. 0:38 Create a PivotTable
  3. 1:10 Filter a PivotTable
  4. 2:34 PivotTable Options - Totals and Filters

Excel - Insert a blank row after every row or every Nth row

Do you ever need to add blank rows in between rows? There are several ways to do this in Excel, but if you have a lot of data, right-clicking and inserting rows becomes tedious. We will use a helper column to quickly add blank rows after every row. We will also look at inserting a blank row after every 3rd row or every Nth row.

Chapters

  1. 0:00 Intro
  2. 0:12 Helper column for blank rows
  3. 1:15 Every 3rd row, a blank row

Recent Articles

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

Outlook - Manage your Inbox using Ignore, Archive, Block, Delete, and Clean Up

NEW Teams  - Two New Features - October 2023

NEW Teams - Two New Features - October 2023

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

Microsoft Teams Training with Chris Menard - 2.5 hours of material

50% off Chris Menard's Online Teams training course

 

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 20 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.

Categories