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 Calendar - Meetings vs. Appointments

Outlook Calendar - Meetings vs. Appointments

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Teams - How to Manage Files and Folders in a Channel

Teams - How to Manage Files and Folders in a Channel

Microsoft Teams - Collect immediate feedback with an Instant Poll

Microsoft Teams - Collect immediate feedback with an Instant Poll

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 Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 15 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories