@chrismenardtraining Avatar @chrismenardtraining Chris Menard

Chris Menard posts on YouTube about microsoft, how to, tutorial, data the most. They currently have [------] followers and [---] posts still getting attention that total [-----] engagements in the last [--] hours.

Engagements: [-----] #

Engagements Line Chart

Mentions: [--] #

Mentions Line Chart

Followers: [------] #

Followers Line Chart

CreatorRank: [---------] #

CreatorRank Line Chart

Social Influence

Social category influence technology brands stocks finance social networks countries automotive brands currencies

Social topic influence microsoft #1361, how to, tutorial, data, microsoft teams #77, walk, excel, ai, if you, create

Top accounts mentioned or mentioned by @graphicious @mentions @chrismenardtrainingcom @mention @microsoftforms

Top assets mentioned Microsoft Corp. (MSFT) Alphabet Inc Class A (GOOGL)

Top Social Posts

Top posts by engagements in the last [--] hours

"How to use the Windows clipboard With the Windows [--] clipboard you can copy multiple images and text at one time. The clipboard previously held one item but now the clipboard holds [--] items. You can even copy items from one PC to another with a cloud-based clipboard. To access your clipboard history at any time press Windows logo key + V. Chris Menard's blog post https://chrismenardtraining.com/post/how-to-use-the-windows-clipboard Screenshot of how to turn on the Windows clipboard - Do this FIRST https://drive.google.com/file/d/1kDud1mMwf_MQmEvR9vAmO9uuGS_UjnM4/viewusp=drivesdk TimeStamps /"
YouTube Link 2020-06-09T14:26Z 95.5K followers, 193.3K engagements

"Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard Cost-volume-profit analysis looks to determine the break-even point. The breakeven point is when Revenue covers total expenses. There is no profit and no loss. Net income is $0.00. CVP looks for different sales volumes and cost structures. It is used to determine the break-even point. How many units do I need to sell to breakeven ********* Video on cost-volume-profit with multiple products Chris Menard's blog post on break-even. https://chrismenardtraining.com/post/breakeven-in-excel-accounting"
YouTube Link 2017-05-30T19:50Z 95.5K followers, 256.6K engagements

"Create Polls On the Fly in Teams In this video I'm diving deep into creating and using polling questions in Teams meetings. I'll walk you through every step from scheduling polls before a meeting to creating them mid-conversation. Plus I'll show you my favorite feature - the instant poll. I'll start with a quick review of setting up polls for scheduled meetings then jump into the meat of this tutorial: creating polls during an active meeting. You'll learn how to access the Polls feature through the Apps menu create a new poll from scratch and even use Microsoft's handy poll suggestions. I'll"
YouTube Link 2024-07-19T14:00Z 95.5K followers, [----] engagements

"Zoom Meetings Registration Top [--] questions answered Zoom Registration Tutorial Why use registration for a Zoom meeting Registration is used for Zoom webinars but you can use Registration for meetings. Three reasons to used registration for meetings: 1) Capture information about your attendees. There are a lot of questions you can ask your attendees using registration questions. 2) Polling if used will capture the name and email of those that voted. 3) You may want to know if anyone signed up for your meeting a couple of days in advance. Possibly you have a lot of work to do a couple of days"
YouTube Link 2021-03-16T16:37Z 95.5K followers, 44.5K engagements

"How to SORT Data in Excel [--] Tips Excel has a powerful SORTING engine. SORT is the most popular function in Excel and it can sort by many types of data many attributes and even custom sorting configurations. In this video I walk you through [--] major SORT function tips and procedures. We look at how to ensure the data is ready to sort selecting the appropriate sorting range and making sure there are no blank rows or columns. Then we sort in Excel by one column multiple columns by color by date custom sorting and also sorting mixed data ensuring that if we have numbers and numbers stored as text"
YouTube Link 2022-07-26T13:10Z 95.5K followers, 164K engagements

"Presentations with Organization Templates with Copilot for PowerPoint I demonstrate a new feature in PowerPoint that allows you to reference your organization's templates with Copilot. This will give you a kickstart on your presentations while abiding by your organization's brand guidelines. I guide you through starting PowerPoint accessing the new 'Create with Copilot' feature and selecting templates. Although I don't have any organization templates added I explain how to add them and show how you can create presentations using these templates. If you choose an organization template Copilot"
YouTube Link 2025-05-27T14:00Z 95.5K followers, [----] engagements

"Create a contact group / distribution list in Outlook by Chris Menard Do you email the same people all the time If yes you need to create a Contact Group in Microsoft Outlook. Contact groups are also called "Distribution Lists". The steps below work in Outlook [----] Outlook [----] Outlook [----] Outlook [----] and Microsoft [---] Outlook desktop. If you want to pull Excel data with a copy and paste see this video I created. https://youtu.be/ZrH9O6_UQ8I And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone -"
YouTube Link 2016-11-06T15:29Z 95.5K followers, 691.8K engagements

"Excel FILTER Function Excel One Minute Functions Explained The FILTER function in Excel allows you to filter a range of data based on the criteria you define. The FILTER function is a dynamic array function. The FILTER function has three arguments but only two are required. Syntax =FILTER(arrayincludeif_empty) Example =FILTER(A5:D20C5:C20=H2"") Argument Description **************** array - The array or range to filter REQUIRED include - A Boolean array whose height or width is the same as the array REQUIRED if_empty - The value to return if all values in the included array are empty (filter"
YouTube Link 2021-10-12T13:00Z 95.5K followers, 38.4K engagements

"Excel Charts - three methods for filtering Chart Data Filtering data in Excel charts is easy to do. The method you use should be based on the amount of data you have. In this video I show three methods of filtering chart data. Method [--] is using Chart Filters. This is the easiest method. Method [--] is using Filters and creating a chart. Method [--] is using a Table and Filters. Methods [--] and [--] work great with large data sets. Method [--] is great for a small set of data. I also show Transpose data and how to keep a chart from moving or disappearing when you filter your data. Chapters ***** 0:00 Intro"
YouTube Link 2021-02-25T15:23Z 95.5K followers, 79K engagements

"Zoom Video - Video as a Virtual background in meetings by Chris Menard Zoom Video Conference: Zoom now allows you to have a video as your virtual background in your meetings. This is a great feature released in early [----]. You can still do an image background with or without a green screen. I'm not using a green screen in this video. Both videos I use as my background were preloaded when I started the Zoom meeting. You can also download videos to use as your virtual background. The video can be an mp4 or mov. The resolution needs to be 360p - 1080p. I recommend if you do a lot of video"
YouTube Link 2020-02-23T14:59Z 95.5K followers, 238.5K engagements

"Solvency Ratios in Excel - Debt to Equity Debt Ratio and Equity Ratio Solvency ratios determine a company's ability to meet its long-term debt obligations. There are several solvency ratios. One of the most popular solvency ratios is the Debt-to-Equity (D/E) Ratio. The Debt-to-Equity ratio takes the total debt divided by the equity of a company. That ratio tells you how a company is funded. Is it funded by debt or equity The lower the number the better. A higher number may indicate a company may have issues paying its debt. For example the total debt of $500 and equity of $500 is [----]. The"
YouTube Link 2022-09-01T14:23Z 95.5K followers, [----] engagements

"Excel SORTBY Function Excel One Minute Functions Explained The SORTBY function in Excel sorts the contents of a range or array based on the values in a corresponding range or array. Use SORTBY to see a list of employees sorted by highest paid but you don't show their salaries. USE SORTBY to sort a customer list by the most profitable customer but not see the revenue. SORTBY has two required arguments but you can sort by multiple criteria. You can use the SORTBY function on another worksheet or on another file or workbook. Syntax =SORTBY(array by_array1 sort_order1 by_array2 sort_order2)"
YouTube Link 2021-10-13T13:00Z 95.5K followers, 26.3K engagements

"Create PowerPoint Presentations from Excel Files with M365 Copilot An exciting new feature available to M365 Copilot license holderscreating PowerPoint presentations directly from Excel files. I show you how to use Copilot to generate a well-organized PowerPoint presentation complete with charts graphs and tables. Learn how to customize and manage your slides quickly and efficiently with Copilot in no time. My courses on Copilot Excel OneNote Teams are here: https://courses.chrismenardtraining.com Chapters: 00:00 Introduction 00:20 Setting Up Your Excel File 00:45 Creating a PowerPoint with"
YouTube Link 2025-08-29T13:45Z 95.5K followers, [----] engagements

"Excel Linking Files - Link vs. 3D reference If you need data from one Excel file to show in another workbook that is a LINK. It is very similar to a 3D Reference. The difference is a 3D reference happens inside one Excel file while a Link happens with multiple Excel files. I'll demonstrate two methods for linking files in this short video. Chapters 0:00 Intro 0:30 Swap between Excel files 0:50 Link workbooks method [--] 2:06 Link workbooks method [--] 3:14 Update workbook Title Watch Url Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watchv=6v2aj1GE3fg"
YouTube Link 2023-09-05T13:00Z 78K followers, [---] engagements

"Zoom - Move individual participants from breakout room to main room Zoom has two incredible new features with Zoom 5.4.6 released on December [--] [----]. You can now move participants to the main session from breakout rooms. Hosts and co-hosts have the option to assign a participant back to the main session rather than ending all breakout sessions. You had to close the breakout rooms to get someone back to the main session in the past. The other new feature is co-host now have the same breakout room controls as host. Co-hosts can start breakout rooms end breakout rooms and assign participants to"
YouTube Link 2020-12-09T17:08Z 86.2K followers, [----] engagements

"Excel Loan Amortization Schedule: New Lower Interest Rates - Compare Loans Understanding your Loan Amortization Schedule is crucial if you're in the market for a home. In this video I demonstrate how to use a free Loan Amortization Schedule from Microsoft. You'll learn how to input key details like loan amount down payment interest rate and loan term to see a complete breakdown of your payments. I also show how to compare two different loans using Excel including tips on adding additional expenses like taxes and insurance. Check out the video and my online training classes which are linked"
YouTube Link 2024-09-25T13:00Z 77.5K followers, [---] engagements

"SUM Function in Excel: how to use SUM correctly by Chris Menard The SUM function is the most popular function in Excel. That is why it on the home tab with a large icon. Most beginning Excel users and some intermediate Excel users do not use the SUM function correctly. #msexcel #microsoftexcel #chrismenardtraining #excelfunction #sumfunction Chris Menard's website: https://chrismenardtraining.com And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod"
YouTube Link 2020-03-09T13:04Z 91.8K followers, [----] engagements

"New Microsoft Teams: New CAMERA Controls & Green Screen Options I discuss some notable changes on Microsoft Teams set to be the default from March [--] [----]. I highlight the new location for camera controls in meetings and teach you how to swap cameras during a meeting adjust brightness and use the newly added green screen feature. Chapters: 00:00 Introduction 00:36 New Camera Controls 00:55 Switching Between Cameras 01:14 Adjusting Brightness and Video Effects 01:31 Using Green Screen Feature 01:58 Setting Up Green Screen Background 02:59 Conclusion Check out my Microsoft Teams Course soon"
YouTube Link 2024-01-31T15:01Z 89.1K followers, [----] engagements

"OneNote - New layout option - Horizontal Sections Microsoft OneNote has a new feature rolling out. You can now view your sections horizontally. This is a great update. This feature applies to OneNote formerly called OneNote [----]. There are six different versions of OneNote. OneNote for Windows OneNote for Mac OneNote for the web OneNote for iPhone OneNote for iPad and OneNote for Android. Within Windows OneNote there are two options - OneNote for Windows [--] and OneNote. Chapters: 00:00 OneNote for Windows New Layout Options 00:57 Six Versions of OneNote 01:22 Two Versions of Desktop App on"
YouTube Link 2023-02-07T15:16Z 81.7K followers, 47.7K engagements

"Zoom - View Speaker Notes When Presenting PowerPoint Presenter View Have you been in a Zoom meeting and need to share PowerPoint but you see your Speaker Notes If you need to let your audience see PowerPoint full screen or "Slide Show" View you can even view your speaker notes with just one monitor but only you see your Speaker Notes - the participants see PowerPoint full screen or Slide Show view. To view your Speaker Notes the trick is to use Share in Zoom and select PowerPoint. In PowerPoint use "Presenter View". Presenter View works when sharing your screen or just PowerPoint but the big"
YouTube Link 2022-05-31T13:00Z 89.7K followers, 177.5K engagements

"Mail Merge for Gmail - Different attachments for each recipients by Chris Menard You can use Gmail to perform a mail merge. The advantage of Gmail over Outlook is you can use an Add-on that is free to send different attachments to different recipients and you can also schedule delivery. Everything you need is free. A Gmail account chrome and google sheets which is part of Google Docs. Microsoft Outlook [----] and previous versions of Outlook allow you to perform a mail merge also but if you want to send an attachment it is all of nothing. Meaning every recipient gets the same attachments or"
YouTube Link 2016-01-18T19:07Z 88.9K followers, 127.3K engagements

"COUNTIFS function in Excel with dates by Chris Menard To count the number of occurrences for a range or multiple items use the COUNTIFS function. When it comes to a date range whether is it for a month quarter or any date range the COUNTIFS function is what you need. Examples: How many orders did we get for Quarter [--] That is the COUNTIFS function since it is between a range of dates. How many times was product A ordered for customers in Australia How many orders did we have between January [--] and March [--] The COUNTIF function which I covered in this video will handle one criterion. COUNTIFS"
YouTube Link 2020-01-14T16:49Z 91.8K followers, 107.2K engagements

"Microsoft Teams - Virtual Appointment - No app required Microsoft Teams is rolling out Virtual Appointments. Virtual Appointments make it easy to schedule meetings and the meeting attendees do not need to install Teams. Even joining from an Android or iPhone there is no need to install Teams. Examples of who would use Virtual Appointments: insurance agents meetings with new clients financial advisors meeting with clients and attorneys meeting with a client are just a few examples. Chapters: 0:00 Intro 0:36 Schedule Virtual Appointment 3:05 Mobile Phone View 4:12 Join as guest Chris Menard's"
YouTube Link 2023-10-24T03:31Z 59K followers, [----] engagements

"MS Teams: How to View Only Channels and Not Teams Microsoft Teams is a powerful collaboration tool but navigating through numerous teams and channels can sometimes be overwhelming. In this guide we'll explore how you can streamline your experience by focusing on channels alone without the clutter of team names. This is particularly useful for users who want a more organized and efficient workflow. Introduction to Viewing Only Channels If you're a Microsoft Teams user especially one who manages multiple channels within a team you might find it helpful to view only the channels without the"
YouTube Link 2025-05-14T14:00Z 86.1K followers, [---] engagements

"Excel XLOOKUP vs FILTER Function (with examples) Excel's XLOOKUP and FILTER functions are two powerful tools for data analysis and manipulation. While they serve similar purposes each has unique strengths and use cases. This comprehensive guide will explore how to effectively use XLOOKUP and Filter functions compare their capabilities and provide practical examples to help you choose the right tool for your Excel tasks. Understanding XLOOKUP: The Versatile Lookup Function XLOOKUP is a newer addition to Excel's lookup family designed to overcome the limitations of its predecessors like VLOOKUP"
YouTube Link 2025-04-02T14:00Z 84.4K followers, [---] engagements

"Excel PivotTable - Summarize data by Month or Day of the week If you need to find out what day of the week is the most profitable or what day of the week do we receive the most support calls Excel's PivotTables can handle it. PivotTables will group dates automatically. If you have any date field - invoice dates order dates hire dates - Excel will group by year quarter and month for you. No formula's needed. If you want to group by day of the week we can use the TEXT function in Excel and group by the day of the week. In this example I use PivotTable and the Text function to find out what day"
YouTube Link 2023-09-14T22:26Z 59K followers, 31.7K engagements

"Grouping in Excel PivotTables with ChatGPT [--] and Copilot I'll show you how to group data inside a pivot table in Excel. We will utilize ChatGPT [--] within the free version of Microsoft Copilot to help determine the appropriate grouping. Starting with a list of car brands I'll demonstrate how to organize them by their respective countries such as USA Japan Italy and Germany. I explain the unique function how to insert and manage pivot tables and how to group data effectively. We'll also discuss alternative methods like VLOOKUP or XLOOKUP and the advantages of in-pivot table grouping for small"
YouTube Link 2025-08-22T13:45Z 89.6K followers, [---] engagements

"How to use the Excel DATE function In this video I demonstrate how to use the DATE function in Excel. I take you through two examples: how to combine three cells into a single date and how to calculate [--] years from a certain date using the DATE function. Syntax: DATE(yearmonthday) Assume that cell A2 has the month B2 has the day and C2 has the year. A2 contains August as the number [--] B2 contains the ninth as the number [--] and C2 contains [----]. In D2 = DATE (C2 A2 B2) would return 8/9/2024. Notice the function goes year month and day. Another reason for using the DATE function is to add years"
YouTube Link 2024-04-11T14:00Z 83.8K followers, [----] engagements

"Zoom video - save polls and keyboard tips for the Mac by Chris Menard Zoom allowing you to poll your audience. This is a great feature for opening a meeting or giving your audience input on future events. A YouTube subscriber asked me in poll questions could be saved This is a great question. The answer is Yes if you use your Personal Meeting ID. If you use a dynamic id they can't be saved but you can still add questions. Blog post with zoom keyboard shortcuts for the Mac and Windows/PC https://chrismenardtraining.com/post/zoom-meeting-keyboard-shortcuts Download the PDF files for top [--] Zoom"
YouTube Link 2020-03-20T16:54Z 91.5K followers, 11.5K engagements

"Find Unique Values in Microsoft Excel: [--] Methods for Beginners Finding Unique Values in Microsoft Excel is very easy and there are many methods to do it. In this Excel tutorial I'm showing you my [--] favorite ways to find filter extract and display unique values from a range of cells. 00:00 Introduction 00:16 Remove Duplicates 00:51 Using Filter 01:27 Using PivotTable 02:02 Using the UNIQUE function (Microsoft [---] only) Remove Duplicates in Excel **** Select the range of cells that has duplicate values you want to remove. Click Data then Remove Duplicates and then Under Columns check or uncheck"
YouTube Link 2021-06-04T15:16Z 78.1K followers, 34K engagements

"Excel - Data Analysis and Clean Up Data Chapters/Bookmarks 0:00 Intro 0:40 Check data and create a table 1:40 AutoCalculate 2:57 Change text to number 3:39 Change General to Dates 4:18 Filters and Spaces 4:55 UNIQUE Function 5:20 Remove Duplicates 6:18 TRIM Function 7:16 Move columns with SHIFT 7:55 Data Analysis 9:59 Calculated Column in a Table 10:40 PivotTable Turn on Data Analysis File Options Add-in turn on Analysis Toolpak Title Watch Url Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watchv=6v2aj1GE3fg Excel Tiered Conditional Formatting with"
YouTube Link 2023-10-12T14:58Z 59K followers, [----] engagements

"Excel TRANSLATE Function: New Feature The Excel Translate Function lets me translate entire columns of text without leaving the worksheet. Its built into Excel [---] so you dont need add-ins or third-party tools to get started. I was particularly impressed by how simple the syntax is and how it integrates with autofill and normal worksheet functions. Heres the scenario I worked with: I had five product descriptions in English and I needed them translated to Spanish for a website. I used a simple formula in cell C2 to translate the text in B2. The formula looks like this: =TRANSLATE(B2"en""es")"
YouTube Link 2025-08-18T13:50Z 89.4K followers, [---] engagements

"Microsoft Excel create a mixed reference - F4 key to change references by Chris Menard Chris Menard demonstrates how to use Excel's mixed reference in this short [--] second video. You can either type the dollar symbol or use the F4 function key to cycle through the references. An Absolute Reference looks like this $B$4. Both the column and row are frozen. A Mixed Reference looks like either $B4 or B$4. The first mixed will freeze column B since the dollar sign is in before the column. The latter will freeze row [--] since the dollar sign in before the row. Chris Menard does Microsoft training in"
YouTube Link 2013-09-16T19:45Z 88.7K followers, 18.6K engagements

"Excel for the web - Recommended Pivot Tables - New Feature [----] Excel for the web has a new feature. Recommend Pivot Tables are now shown when you create a Pivot Tables. To create a Pivot Table select Insert then click PivotTable. Screenshot https://drive.google.com/file/d/1sNcofqXtY_Ys1az34mAeFW34Wae3fk5T/viewusp=drivesdk Chapters: 0:00 Intro 0:14 Insert PivotTable 1:03 New Sheet or Existing sheet You can still create your own Pivot Table if you want. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone -"
YouTube Link 2021-08-02T16:10Z 89.9K followers, [----] engagements

"Mastering M365 Copilot - Your AI Assistant 🚀 Join Us for a Live Event on January [--] 🚀 We're excited to announce a special live event covering Microsoft Copilot This event is tailored for current M365 Copilot users and companies considering using M365 Copilot. Discover how Copilot can transform your productivity in Excel Word PowerPoint Outlook and OneDrive. 🗓 Date: January [--] 🕐 Time: 1:00 PM - 1:40 PM ET 📍 Where: Join live on LinkedIn or YouTube. No registration required 🎤 Presenter: Chris Menard Microsoft Certified Trainer Don't miss this opportunity to see Copilot in action and learn"
YouTube Link 2025-01-02T13:32Z 80.5K followers, [---] engagements

"Excel - Copy and Paste only non-blank cells by Chris Menard There are two methods when you need to copy and paste non-blank cells. 1) Use Paste Special - Blanks - Delete 2) Use Copy and Paste but use Skip Blanks in Paste Special. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera https://amzn.to/2Tg75Sn Shock mount - https://amzn.to/3g96FGj"
YouTube Link 2023-10-23T10:46Z 59K followers, 91.5K engagements

"Excel RATE function Scottish woman's $3 bank account becomes $335 after six decades A Scottish woman checked her bank account after six decades. Her grandmother's $3.35 initial deposit made back in the 1950s has grown to $335. While visiting her grandmother her grandmother opened an account for her in TSB Bank in [----]. I became curious we know her initial deposit and we see the balance now is $335 after [--] years. No additional payments were made. I was wondering what annual interest rate did she earn Excel's RATE function gave me the answer. It was slightly over 7%. This shows the power of"
YouTube Link 2022-03-08T14:00Z 88.3K followers, [---] engagements

"Can Copilot Cope with Large Data Sets in Excel In this video I demonstrate an update to Copilot by testing it with a dataset containing over [----] records which is a significant increase from the [--] to [--] records used in my previous demonstrations. I focus on an 'Invoice Date' field within a large spreadsheet to assess Copilot's capability in processing extensive data. Specifically I challenge Copilot to generate a column chart that totals invoice amounts by year and month. Copilot produces an accurate clustered column chart showcasing data for each month in [----] and [----] effectively giving me"
YouTube Link 2024-05-17T14:00Z 77.9K followers, [---] engagements

"Excel VLOOKUP for Tax Brackets Year [----] with Examples How to calculate progressive tax with tax brackets and VLOOKUP in Excel with examples. Tax brackets show you the tax rate you will pay on each portion of your income. The United States has a progressive tax system based on your Taxable income not Gross income or Net Income. There are seven tax brackets and your income is taxed at different rates with a progressive tax system. The more you make the higher the rate for that bracket. For example if you are single in [----] the lowest tax rate of 10% is applied to your income's first $9950. The"
YouTube Link 2021-11-18T15:23Z 88.7K followers, 27K engagements

"Teams - Recorded Meetings - who can download view and where are they stored Teams Meeting recordings are saved in either OneDrive for Work or Sharepoint. This video covers scheduled and ad-hoc (instant) meetings. We will look at who can download the MP4 recording who can view the recording and where in OneDrive your recordings are stored. I have two examples in my video. Example [--] is the Organizer doesn't attend and I record the meeting. Example [--] is the Organizer attends the meeting and records the meeting. If you record a meeting in Teams it is stored inside OneDrive for Work or School in"
YouTube Link 2021-12-09T14:00Z 79.4K followers, 80K engagements

"Excel Report Filters: Tips of creating multiple reports from one PivotTable PivotTables are great for summarizing and analyzing data. Report Filter Pages is a great way to generate multiple reports. For example we have a list of [--] Salespeople and their customer and their orders. We can use Report Filters to create [--] additional reports one for each rep quickly. I'll demonstrate how to use Report Filters and how to sort and format before creating your Report Filters. Blog post by Chris Menard"
YouTube Link 2021-04-12T17:13Z 88.6K followers, [----] engagements

"UNIQUE Function using Excel for the web by Chris Menard The UNIQUE function in Excel is a Dynamic Array function. In this video I use the UNIQUE function to find DISTINCT values UNIQUE values and even combine the SORT function with UNIQUE. Also shown is Excel's famous remove duplicate feature and I transpose data before using the 2nd argument in the UNIQUE function. The UNIQUE function doesn't work In Excel [----] or Excel [----] but it does work in Excel for the web. Topics covered in this video for the UNIQUE Function Distinct vs. Unique - unique is it shown only once. This would be the 3rd"
YouTube Link 2020-05-26T18:42Z 89.9K followers, [---] engagements

"Subtotal Command in Excel - automatically calculate subtotals and grand totals The Subtotals Command will automatically calculate subtotals and grand totals in a list for a column. Subtotals come with an automatic outline in Excel. The outline will show [--] [--] and [--] to the left of column A. I have three rules I follow before I use Subtotals - 1) Save 2) Sort and 3) Subtotal. You can also do multiple Subtotals. Chapters: 0:00 Intro 0:35 Subtotal Command 1:10 Three rules for Subtotals 3:00 Grand Totals 3:48 Multiple Subtotals 4:40 Remove Subtotals #excel #msexcel #chrismenardtraining #chrismenard"
YouTube Link 2021-11-02T13:00Z 78.1K followers, 18.4K engagements

"Clean Inconsistent Data with Microsoft Copilot in Excel In today's fast-paced digital world handling data efficiently is crucial. Whether you're a business analyst an administrative professional a data scientist or simply someone who deals with spreadsheets regularly having the right tools can make all the difference. Enter Microsoft Copilot a revolutionary tool designed to streamline data cleaning in Excel. In this article we'll explore how to use Copilot in Excel to clean inconsistent data effortlessly. Launching Copilot Upon opening a file Copilot makes its presence known by highlighting"
YouTube Link 2025-05-12T13:53Z 86K followers, [---] engagements

"Installing the Zoom Outlook Plugin by Chris Menard The Zoom Outlook Plugin allows you to schedule meetings from Microsoft Outlook. In this short video I install the Zoom plugin to Outlook for the desktop with an Office [---] subscription. Chris Menard's Website http://chrismenardtraining.com And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera"
YouTube Link 2019-02-15T14:48Z 89.1K followers, 28.5K engagements

"Artificial Intelligence (AI) in Microsoft [---] Artificial Intelligence (AI) is in all Microsoft [---] apps - Excel Word Outlook PowerPoint Teams and other M365 apps. In Excel we have Analyze data on the Home tab and the ability to get data from a picture or screenshot. In PowerPoint we have the Rehearse with Coach. It will tell you that you are speaking too fast too slow or using too many filler words. Teams and PowerPoint allow us to view live captions and even in another language. Teams will do a meeting recap (part of Teams Premium.) Word has translation features the Resume Assistant. Outlook"
YouTube Link 2023-04-12T14:40Z 84K followers, 20.5K engagements

"6 NEW Features in Excel for the WEB In this video I demonstrate [--] Exciting New Features in Excel on the Web I'll walk you through each feature demonstrating how they work and sharing my thoughts on their usefulness. From resizing columns with ease to a more flexible freeze panes function these updates are designed to make your Excel web experience smoother and more efficient. While I couldn't get the quick column insertion feature to work I'll still explain what it's supposed to do as this feature might be working for some of you already. The blog post from Microsoft is available here:"
YouTube Link 2024-07-24T14:00Z 89.9K followers, [---] engagements

"Excel Distinct Count with a PivotTable 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. To create a distinct count in a PivotTable there is a box you must check to have this feature enabled in your PivotTable. In this short video I'll demonstrate a PivotTable without a distinct count create another PivotTable with a distinct count and finally show the awesome UNIQUE function. The tip is to select Add this data to the data"
YouTube Link 2022-03-30T13:00Z 89.7K followers, 81.7K engagements

"Six Excel Intermediate and Advanced features in [--] minutes by Chris Menard Chris Menard covers six intermediate and advanced features in Excel in five minutes. Feel free to share with your co-workers. Chris's Excel Intermediate class is available online at http://chrismenardtraining.teachable.com/ Online Excel Training And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand -"
YouTube Link 2017-05-16T14:53Z 85K followers, [---] engagements

"Outlook: Reactions & Notifications & At Mentions With Outlook you should leverage reactions notifications and mentions. Whether using the new or classic desktop versions or Outlook on the web. Learn how to react to emails with various icons and manage your notifications easily. I'll show you the steps using examples like @ mentioning in group emails and navigating the notification icon in the top right corner to keep track of your mentions and reactions efficiently. Stay tuned for bonus tips and improve your Outlook experience Chapters/Bookmarks 00:00 Introduction to Outlook Reactions and"
YouTube Link 2025-01-29T15:00Z 87.6K followers, [----] engagements

"Excel - Create a Custom Sort List Excel sorts by numbers dates text and color. Excel will also sort by Custom List. For example maybe you need to sort July to June or October to September for fiscal years. You can also make a custom sort list for job titles. Possibly all Directors need to show up before Managers. Managers show up before Admin. You have to create a custom sort list before using it. The great news is a custom sort list stays on your computer. It is per file or worksheet. Chapters: 0:00 Intro 0:36 Remove duplicates 1:52 Two methods for order 2:45 Create a custom sort 5:22 Custom"
YouTube Link 2023-08-08T20:09Z 77.8K followers, [----] engagements

"Rename your OneDrive files and delete files while in Word PowerPoint or Excel by Chris Menard Two new Office [---] (O365) features came out on August [--] [----]. 1) You can now rename a file while working in Word PowerPoint or Excel and it will retain your OneDrive or SharePoint file history. Renaming a file on the fly is an excellent feature. 2) The second feature is the ability to delete a file in Word PowerPoint or Excel before opening the file. When your startup screen appears you can quickly see if a recently created file needs to be deleted and delete it immediately. You don't have to go to"
YouTube Link 2018-08-23T11:15Z 91.6K followers, [----] engagements

"Copilot Figures Out Best Excel Functions to Use Do you ever struggle to find the right Excel function to use in various situations In this video I demonstrate how Copilot Chat can assist you with Excel functions. As an example I'll show you how to easily compare employee IDs in different columns return true or false based on their presence and show how Copilot can help you figure out that this requires the MATCH function in Excel. Even if you don't know the exact function you need Copilot Chat can guide you through the process - and it works in the free version too Check out my Copilot and"
YouTube Link 2025-07-18T14:00Z 88.2K followers, [---] engagements

"Gwinnett Medical Center PlacementCenter GMC PlacementCenter for School Coordinators Instructors and Students. GMC is located in Lawrenceville GA And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera https://amzn.to/2Tg75Sn Shock mount - https://amzn.to/3g96FGj Boom Arm - https://amzn.to/3g8cNi6 -- SOFTWARE USED ---------------------------------"
YouTube Link 2013-08-29T12:39Z 85K followers, [--] engagements

"Handle Excel Data with Manual Totals: PivotTables GROUPBY and MORE Are you struggling with Excel data that includes manually added totals for different groups You're not alone. Many Excel users face this challenge when working with datasets containing pre-calculated subtotals. In this comprehensive guide we'll explore effective methods to handle manual totals. We will use Excel PivotTables and the GROUP BY function to handle the manual totals ensuring accurate results and clean data for analysis. Understanding the Challenge of Manual Totals When working with Excel data that includes manually"
YouTube Link 2025-04-23T14:17Z 85.3K followers, [---] engagements

"SORTBY Function in Excel - Dynamic Array Function by Chris Menard The SORTBY Function is one of six new dynamic array functions in Microsoft Excel. SORTBY function allows you to sort one range based on another range. Example: You have a list of employees with the following fields: Name Department and Salary. You want to sort it on a separate workbook or file but those users don't need to see Salary. You want to Sort by Department in ascending order and then Salary in descending order. You can do that with the SORTBY function. You are using Salary as a sort field but other users can't see"
YouTube Link 2019-09-13T13:12Z 90.1K followers, [----] engagements

"How to Split Date and Time in Excel with the INT Function In this video I demonstrate the process of separating date and time in Microsoft Excel when they're combined in a single cell. I begin by introducing the concept of using the INT function for this purpose highlighting that in Excel dates and times are essentially numbers. Let's say I have a cell that contains the current date and time like this: 8/3/2025 1:30 pm. The INT function allows me to extract just the date portion leaving the time behind. I then showcase how to generate a date and time stamp using the NOW function and proceed"
YouTube Link 2024-04-29T14:00Z 87.1K followers, [----] engagements

"Excel: Change Default PivotTable Settings to Save Time Every Time Tired of manually adjusting PivotTable layouts every time you create one I'll show you how to customize Excel's default PivotTable settings so your tables automatically format the way you want them. In this tutorial you'll learn how to: * Change subtotal positioning from top to bottom * Control grand totals display (rows columns or both) * Add blank rows between data groups * Switch from compact to tabular layout * Turn off the annoying auto-fit column width feature * Use two methods: import from existing table or set up before"
YouTube Link 2025-09-16T13:45Z 90.4K followers, [----] engagements

"How to Create a Pivot Chart Grouped by Year and Month in Excel Excel makes it easy to make a chart but frequently a PivotChart is much better. Take a range of daily sales. This could also be a call center request or support tickets. If you have a lot of daily data and wish to view it by year and month a chart in Excel will not work. You need to use a PivotChart. A PivotChart has grouping capabilities that a chart does not. In this short video I'll run you through creating a PivotTable ungrouping the dates grouping the dates by year and month and finally making an incredible PivotChart so you"
YouTube Link 2021-05-17T15:30Z 89.5K followers, 61.4K engagements

"How to Use the TAKE Function in Microsoft Excel Learn how to use the TAKE function in Microsoft Excel to efficiently calculate totals and averages for the first or last rows of your data. In this video I cover practical examples of the TAKE function including dynamic formulas that update as you add new data and tips for making your calculations more flexible. Whether youre tracking monthly revenue or need to quickly adjust your analysis period youll see step-by-step how the TAKE function can streamline your workflow in Excel. Download the sample file and follow along to master the TAKE"
YouTube Link 2025-09-09T13:45Z 90.3K followers, [----] engagements

"Outlook Calendar - Meetings vs. Appointments In Outlook we live in our calendar. We have three different types of calendar items - Meetings Appointments and Events. When do you use each We will look at scheduling meetings appointments and all-day events. The main distinction is Appointments are for you and have a start and end time. Meetings are for you and someone else or multiple people and have a start and end time. All Day Events are usually for you and do not have a specific time like appointments do. All three can also be Recurring. For example I have recurring appointments for my lunch"
YouTube Link 2022-06-15T17:40Z 90K followers, 33.6K engagements

"Microsoft Copilot Chat: Get S&P [---] Returns Over Various Years Exploring S&P [---] Returns Over the Years with Microsoft Copilot Chat. I demonstrate the capabilities of Microsoft Copilot Chat in analyzing S&P [---] annual returns across various time frames. In this tutorial I'll show you how to utilize the latest Copilot features including generating detailed tables and charts on stock performance. Discover insights on the impact of events like the dot-com bubble and the housing crisis on S&P [---] returns and learn how to effectively use Copilot Chat with or without an M365 license. My Copilot"
YouTube Link 2025-06-03T14:00Z 86.8K followers, [---] engagements

"Outlook: Simple searches by From Has Attachment Categories and Dates by Chris Menard Outlook makes it easy to search your inbox. It has predefined searches you can use. I'll search my inbox by FROM then Has Attachments. Next I'll combine FROM With Has Attachments. I will quickly search to today and then yesterday and finally by category. Chris Menard's Website: https://chrismenardtraining.com And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg"
YouTube Link 2019-04-14T13:40Z 89K followers, [----] engagements

"Compare Files for FREE with Copilot Chat As someone who is always exploring new ways to streamline work processes Im excited to share a powerful yet underutilized feature in Microsofts Copilot Chat: the ability to compare files for FREE. If youre like me youve probably used Copilot in Outlook to summarize emails and even attachments like PDFs Word documents and PowerPoint files. But what happens when you want to compare two files side by side such as annual reports or financial statements The answer is simple Copilot Chat can do that and today Ill walk you through exactly how. In this guide"
YouTube Link 2025-07-15T13:58Z 88.1K followers, [---] engagements

"Copilot in Excel - Ask Copilot Questions Join me as I demonstrate some cool features of Copilot in Microsoft Excel. Learn how to utilize Copilot to discover intermediate keyboard shortcuts apply Data Validation effectively and find out about lesser-known yet powerful Excel functions like LET. Plus get insights into my comprehensive Excel online training that also includes Teams Copilot and OneNote. Don't miss out on these handy Excel tips Bookmarks/Chapters 00:00 Introduction to Copilot in Excel 00:09 Exploring Intermediate Keyboard Shortcuts 00:40 Using Data Validation for Addresses 01:23"
YouTube Link 2025-01-27T15:00Z 81.5K followers, [---] engagements

"3 Easy Methods to EXTRACT Numbers from Text in Excel I'll demonstrate three straightforward ways to extract numbers from text strings in Excel. I'll cover Flash Fill available in Excel [----] and newer versions TextBefore and TextAfter functions available in Excel [----] [----] and Microsoft [---] and the new RegexExtract function exclusive to Microsoft [---] users. Watch and learn how to use these powerful tools to simplify your data extraction tasks. Stay tuned till the end to see practical examples and tips to enhance your Excel skills. Thank you for watching My Excel Teams OneNote Copilot courses:"
YouTube Link 2025-08-08T14:17Z 89K followers, [----] engagements

"Microsoft Teams and Outlook Contacts Sync - New Feature Explained Microsoft has introduced a new feature that synchronizes your contacts in Teams and Outlook. This enhancement will streamline our workflow and boost productivity by eliminating the need to manage contacts separately in each application. The new unified contacts experience brings a cohesive view of your contacts across Teams and Outlook. This means that any changes you make to your contacts in one application will automatically reflect in the other. Let's dive into how this works and why it's such a game-changer."
YouTube Link 2025-03-26T15:00Z 88.7K followers, [----] engagements

"Next-Level Productivity: Whats New in Microsoft [---] Copilot July [--] [----] 🚀 Ready to supercharge your workflow with AI Join us for a deep dive into the latest and greatest features of Microsoft [---] Copilotyour new productivity partner in Excel Word Outlook and PowerPoint. In this live session we'll explore: ✅ New Copilot capabilities that are transforming how you work in Microsoft Office ✅ Excel's AI-powered data insights and new create worksheet feature ✅ Word's updated Summarize Documents feature ✅ PowerPoint's new feature using your company templates ✅ Outlook's intelligent email"
YouTube Link 2025-06-25T12:04Z 88.1K followers, [---] engagements

"Microsoft Copilot in Word: Mini Toolbar Tips & Tricks Microsoft Word has always been a robust tool for document creation but the introduction of the Copilot in Word Mini Toolbar takes it to a new level. This feature integrates directly into the mini toolbar providing quick access to powerful functions that streamline your workflow. Imagine you're preparing a proposal document. After typing out several items followed by numbers you realize that a table format would be more effective. Here's where Copilot in Word Mini Toolbar shines. Highlighting the text will reveal the mini toolbar and you'll"
YouTube Link 2025-05-02T14:36Z 85.6K followers, [---] engagements

"How to Set New Message to Open in a New Window in Outlook by Default If you're an Outlook user you've probably experienced the frustration of constantly clicking "Open in New Window" every time you create a new message. Well I've got good news for you In this quick tutorial I'll show you how to set your new messages to automatically open in a new window by default. This simple change can save you time and streamline your email workflow. Let's dive in ✅The Problem with the Default Setting In the new Outlook when you create a new message it typically opens in a task pane on the right side of"
YouTube Link 2025-02-10T15:00Z 84.2K followers, [----] engagements

"Excel Fiscal Year in a PivotTable Fiscal Year different from Calendar Year in Excel For many companies the fiscal year is different than the calendar year. In today's video I create a PivotTable in Microsoft Excel and show you how to calculate the fiscal year in your data and use it in a PivotTable. We've created many PivotTables in previous videos and today is no different. We create a simple date and sales PivotTable and show quickly how Excel takes the dates and organizes them by calendar year. We then use some simple formulas to take the dates and display the fiscal year for those dates."
YouTube Link 2021-03-22T16:05Z 84.2K followers, 36K engagements

"OneNote: Insert Outlook Meeting into OneNote by Chris Menard OneNote is great for taking notes and keeping up with meetings. You can easily insert an Outlook meeting into OneNote. This works in OneNote for Windows and OneNote [----]. To make internal links to other pages in OneNote use double closed brackets. Example January [----] #onenote #outlook #outlookmeeting And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights -"
YouTube Link 2019-01-03T13:48Z 89.1K followers, [----] engagements

"Meeting Chat while Sharing Screen in Microsoft Teams If youre a regular Microsoft Teams user you know how challenging it can be to manage chat messages while sharing your screen during a meeting especially if you only have one monitor. For years this limitation has been a source of frustration: to view the chat you had to either exit the screen share or open the meeting window separately both of which disrupt the flow of your presentation. Fortunately a long-awaited feature has finally arrived to solve this issue. In this article Ill guide you through the new Teams Meeting chat while"
YouTube Link 2025-06-24T14:00Z 88.6K followers, [---] engagements

"Xara Cloud: Create social media post thumbnails with Xara by Chris Menard Social Media post thumbnails are easy to create with Xara Cloud. In this example I make the same post three different times. I need it for FaceBook LinkedIn and Instagram I could have made Twitter and Pinterest also. Xara Cloud is free to try for [--] days. It is extremely affordable if you need high-end graphic design. Chris Menard's Website: https://chrismenardtraining.com Xara Cloud Website: https://cloud.ixara.com/ And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera"
YouTube Link 2019-01-18T14:10Z 89.6K followers, [---] engagements

"Adobe Acrobat Pro Redact Text and change redaction color by Chris Menard When redacting text with Adobe Acrobat Pro the black background stands out. You can change the background color and even have text over the redacted area. Adobe Acrobat Pro DC is free to try for [--] days. *********** The video below is how to search for a word and redact that word. https://www.youtube.com/watchv=0WcW0omEVQw *********** Video created for Southern Crescent Women's Healthcare and Hank Fellows and other doctor offices hospitals and attorneys. And make sure you subscribe to my channel -- EQUIPMENT USED"
YouTube Link 2016-12-04T18:00Z 86K followers, [----] engagements

"Excel - PivotTable: Show Report Filter Pages - create many PivotTables at one time by Chris Menard Excel has a great feature that allows you to create multiple PivotTables from one PivotTable. It is called "Show Report Filter Pages." To use this feature you have to use the Filter area in a PivotTable. The field you want to drag to the Filter area of the PivotTable is the field you wish to create many PivotTables. As an example if you want each Sales Rep to have their own PivotTable report and you have a field called Sales Rep you would drag Sales Rep to the filter area. You need two other"
YouTube Link 2019-10-31T17:57Z 90K followers, 12.3K engagements

"Using the Fill Handle in Excel - series months years weekdays and formatting - by Chris Menard The Fill Handle in Excel can fill dates text numbers and a combination of dates and numbers. Knowing how to use the Fill Handle is essential to mastering Microsoft Excel. In this video I cover AutoFill options for months days years and series. In this short video I fill the next day then I fill only workdays. An example would be an emergency room that is open 24x7 would need the next day or a production facility that operates 24x7. The week or workweek would be a law firm bank or company that only"
YouTube Link 2019-10-26T20:14Z 81.2K followers, 13K engagements

"MS Word: Convert Text to Table with Ease Have you ever found yourself struggling with the layout of information in Microsoft Word It can be frustrating when your document doesnt look quite right. In this guide well explore a powerful advanced skill: converting text to a table in MS Word. This feature can transform messy data into a structured and professional-looking table. Microsoft Word offers a variety of tools to help organize and present data effectively. One of these tools is the ability to convert text into a table. This function is particularly useful when dealing with data that"
YouTube Link 2025-05-01T14:00Z 85.6K followers, [---] engagements

"Outlook Web TODAY: Interface Improvements Outlook on the Web: Handy Calendar Feature Improvement for the TODAY page. In this quick tutorial video I explain a great feature of Outlook on the web calendar function. The TODAY page has been improved. I cover how the current day is visually made prominent making it easier to organize your schedule and avoid scheduling errors. The ability to display multiple time zones is also highlighted though not in detail because it was covered in a previous video. Chapters 00:00 Introduction 00:20 Demonstration: Week View 00:36 Demonstration: One Day View"
YouTube Link 2024-01-10T15:40Z 91.5K followers, [---] engagements

"How to Edit Display Name in Teams Meetings: New Feature Microsoft Teams users get ready for an exciting new feature that's rolling out The ability to edit your display name during a Teams meeting is now in public preview as of April [----]. This feature promises to enhance collaboration and personalization in your virtual meetings. Steps for the Meeting Organizer to allow users to Edit Display Name [--]. Open your Teams desktop calendar. [--] Create a new meeting as usual filling in the necessary details. [--]. Click on "Meeting options". You can also use Meeting options after sending out the invite. 4."
YouTube Link 2025-04-15T14:00Z 85K followers, [---] engagements

"Market Capitalization: Excel Analysis & S&P [---] Returns In this video I dive deep into Market Capitalization demonstrating how to use Excel for stock analysis and exploring the potential of long-term S&P [---] returns. Whether you're a finance enthusiast or just curious about stock market metrics this tutorial offers valuable insights and practical Excel techniques. Learn how to leverage Excel's stock data type to quickly analyze company financials understand market capitalization categories and see how compound interest can potentially grow your investments over time. I also explain the Rule"
YouTube Link 2024-07-26T14:00Z 78K followers, [---] engagements

"Excel AutoRefresh for PivotTables: NEW FEATURE A fantastic new feature for Microsoft Excel users that allows PivotTables to auto-refresh. If you've ever been in a meeting and forgotten to refresh your PivotTable after updating data this feature is going to save you In this tutorial I demonstrate how to create a PivotTable with a list of states and purchases. Watch as I change the data and the PivotTable instantly updates. I'll also show you where to locate this Auto Refresh option in Excel and how to turn it off if needed. More of my Excel Teams Copilot and OneNote training resources:"
YouTube Link 2025-08-05T13:45Z 88.9K followers, [---] engagements

"The Rule of [--] explained using Excel and the NPER Function Need to know when your investment will double In finance the rule of [--] is an easy method for deterring when an investment will double. Take the number [--] and divide it by the interest rate which gives you the number of years. For example a [----] investment at 8% interest will double to $10000 in [--] years according to the rule of [--]. Take [--] and divide by [--] (interest rate) and you end up with [--] years. You can even go the other route. If you want your money to double in [--] years what interest rate do you need to have [--] divided by 9"
YouTube Link 2021-04-28T16:48Z 83.8K followers, [----] engagements

"MS Word - Odd and Even Page numbers using Headers and Footers by Chris Menard Chris Menard shows you how easy it is to duplex or print two-sided in Microsoft Word. The odd page numbers should be aligned to the right and the even page numbers should be aligned to the left. Start with a Word Document that has at least two pages. ****************************************************** Chris Menard provides onsite Microsoft office training in metro Atlanta. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone -"
YouTube Link 2013-06-05T15:56Z 87.9K followers, 133.9K engagements

"Easily Create PowerPoint Presentations with Copilot AI In this video I walk you through Microsoft Copilot my new favorite assistant for creating PowerPoint presentations effortlessly. I start by showing off a presentation I've already made on how to run a successful conference using Copilot. Then I demonstrate live how to add an agenda slide and create a presentation from scratch including a deep dive into making a presentation on Delta Airlines where I cover everything from their frequent flyer program to their Comfort Plus seating. Copilot not only lets you generate an initial presentation"
YouTube Link 2024-03-13T15:00Z 83.3K followers, 26.5K engagements

"Excel - Format a date the way you want - Custom date formats Excel has plenty of date formats you can get from Format cells (CTRL + 1) is the keyboard shortcut. If you want you can create your own custom date format. This short Excel tutorial will look at Long Date Short Date and several custom date formats. Get a list of date formats: **** Select the cells you want to format. Press CTRL+1. In the Format Cells box click the Number tab. In the Category list click Date. Pick Date in the Category list Under Type pick a date format. Your format will preview in the Sample box with the first date"
YouTube Link 2021-11-30T15:00Z 83.9K followers, 50.8K engagements

"Three Great OneDrive Tips and Features Microsoft OneDrive Tips and Tricks by Chris Menard I love Microsoft's OneDrive and I use it all the time in my work and also for my family. In this video I cover three cool features I love about Microsoft OneDrive. So if you're using Excel Word PowerPoint the ideal place probably to store your files is in OneDrive. There are a couple different variants of OneDrive - one is for Personal use or Family use (which you can share with up to [--] people) and the other version is for Work/School. You control the OneDrive for Family/Personal but the Work/School"
YouTube Link 2021-08-31T13:09Z 91.8K followers, [----] engagements

"Excel: find the lowest/ highest values for rows or columns w/ conditional formatting by Chris Menard You can find the lowest or highest values for rows or columns in Excel using Conditional Formatting. The MIN function finds the lowest value. The MAX function finds the highest value. Combine the MIN or MAX function with Conditional Formatting and you can find the lowest or highest values by row or columns. The trick to doing this is using relative reference and selecting the correct range. To know which row has the lowest value you select B2:E5. The conditional formatting function is"
YouTube Link 2019-08-03T18:29Z 86.5K followers, 159.2K engagements

"Zoom: Request consent to unmute participants Zoom now allows the host to unmute participants with their pre-approved consent. Zoom has always allowed the host to "Mute All" participants and previously allowed the host to "Unmute all". Unmute all was removed in May [----]. It was determined it was a privacy issue to unmute all. Now Zoom has added a great feature that allows the host to Unmute participants using pre-approved consent. This update is part of Zoom 5.2.1 which came out on 8/17/2020 and can be downloaded for free or you can update in your Zoom app settings. The host can schedule"
YouTube Link 2020-08-21T16:28Z 86.3K followers, 25.2K engagements

"Excel TEXTJOIN CONCATENTATE and CHAR Functions to Join Text In this video I'll be discussing three Excel functions that help you join text together: CONCATENATE TEXTJOIN and the CHAR function. If you're looking to combine data in multiple cells into one cell then this video will explain in detail how to achieve that. I start by demonstrating how to use CONCATENATE to combine the last name and first name columns with a space in between. If you want to use a different delimiter such as a comma you can easily do that too. Next up is TEXTJOIN a powerful function that combines data from multiple"
YouTube Link 2023-03-15T15:12Z 85.1K followers, 21.6K engagements

"Calculate the earliest or latest date in Excel based on criteria by Chris Menard If you have dates in Excel and you want to find the earlies or lastest date based on a criteria use the MAX or MIN function with the IF function. The formula will need to be entered as an array function And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera"
YouTube Link 2019-02-20T14:45Z 88.7K followers, 161.3K engagements

"Three tips for the Outlook Mobile App by Chris Menard The Outlook Mobile App will allow you to schedule emails suggest calendar availability and scan a business card. Also shown are @mentions in the Outlook web app and Outlook mobile app. Tip [--] We get a lot of emails and some of them we don't' have time to answer now. You can schedule an important email to disappear and pop up later with the Outlook mobile app. Tip [--] If you need to meet with someone and don't want to go back and forth with emails you can mark times on your calendar you are free to meet with them. Outlook will insert those"
YouTube Link 2023-10-17T13:22Z 59.1K followers, 115.2K engagements

"Saving Chats and Conversations in Microsoft Teams [--] TIPS 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 [--] tips that will help you find your way around the Saved messages functionality in Teams. We look at saving a chat message saving a conversation from a Team channel see where the saved chats and conversations go - it's not immediately obvious as Teams doesn't provide a visual cue when you save a chat message. We see where"
YouTube Link 2023-10-22T10:50Z 59.1K followers, 27.8K engagements

"Teams chats: [--] things you need to know - hide chats delete messages and organize your chats Microsoft Teams chats are used daily. To help you manage your chats I created this short video on hiding and unhiding chats deleting messages and pin and unpin chats. This will help you stay organized if you have a lot of chat history. Chapters: 0:00 Intro 0:28 Hide a chat 2:05 Delete a chat message 3:04 Pin and Unpin chats Can I delete an entire chat No you can only delete the chat messages you have sent. Why don't I see my chats Your company may have a retention policy running and your chats may"
YouTube Link 2021-06-09T13:45Z 84.7K followers, 61.4K engagements

"Excel MONTH Function - extract the month from a date Excel One Minute Quick Reference The MONTH function in Excel allows you to extract the month from the date. In this video I show you how the month function works in Excel the formula to use reference the fields formatting it so that you only see the month and nothing else. In this Excel Short tutorial I aim to provide a complete quick reference of all the Excel formulas or functions with simple to follow examples the complete formula and use cases. Make sure to subscribe for more videos like these almost every day. Here is the full list of"
YouTube Link 2023-09-14T22:26Z 60.3K followers, 15.4K engagements

"Google Chrome - SAVE TAB GROUPS is now available - Keep your tabs organized Google Chrome came out with the ability to add Tab Groups in April [----]. I know I made a video on how to use Tab Groups. What was missing was the ability to Save the Tab Groups. You can now save Tab Groups if you turn on Chrome Flags. Chrome Flags are new or experimental features. This tells me soon Saved Tab Groups will be part of the Chrome browser. What are Tab Groups Tabs in Chrome that are related. For example Delta Air Lines Southwest Airlines Hilton and Marriott may be grouped together under the Travel Group."
YouTube Link 2023-03-23T11:55Z 83.8K followers, 39.6K engagements

"One-Time Expense Reimbursement in Gusto Payroll In this video I demonstrate how to do a one-time expense reimbursement for an employee using Gusto Payroll. I'm Chris Menard and in this tutorial I'll show you how to navigate Gusto Payroll to reimburse non-taxable expenses. I'll guide you step-by-step from signing into your admin account selecting 'Run Payroll' and adding expense details to finally submitting the reimbursement for either Check or Direct Deposit. 00:00 Introduction to Gusto Payroll Reimbursement 00:43 Setting Up Gusto Payroll 01:11 Entering Reimbursement Details 01:50 Finalizing"
YouTube Link 2025-01-06T15:00Z 81.4K followers, [---] engagements

"Automatic Formula Suggestions in Excel with Copilot: New Feature An exciting new Copilot feature in Excel that I discovered recently: Copilot now suggests formulas automatically when you're working in Excel. Watch as I demonstrate how it picks up the TEXTBEFORE and TEXTAFTER functions to dynamically separate first and last names for example. This new feature not only makes data handling more efficient but also updates cells automatically when changes are made it prefers dynamic functions rather than static ones. More Microsoft Copilot videos:"
YouTube Link 2025-04-07T14:00Z 84.7K followers, [---] engagements

"Exploring Microsoft Teams Improved People Search Microsoft has released the new Improved People Search feature in Microsoft Teams which was rolled out in November [----]. I demonstrate how to use the search bar to find a person and filter relevant content such as messages files and group chats associated with that person. I highlight the unique functionality that allows you to type partial names and words to further refine search results. Additionally I provide tips on using command features in Teams and searching for specific YouTube videos directly within the platform. ✅Chapters/Bookmarks"
YouTube Link 2024-12-09T14:30Z 79.5K followers, [---] engagements

"How to Find and Remove Extra Spaces in Excel with Conditional Formatting I address a common issue with extra spacing in Excel data. Specifically we tackle columns with inconsistent spacing using various methods. I'll show you how sorting and unique functions can help to spot errors but our main focus will be on using conditional formatting with the TRIM function to quickly identify and fix these issues. Additionally I'll demonstrate a step-by-step process to correct these errors conveniently. All my Excel Copilot Teams OneNote courses are here: https://courses.chrismenardtraining.com"
YouTube Link 2025-05-16T14:28Z 86.2K followers, [---] engagements

"FILTER Function using Excel for the Web by Chris Menard The FILTER function in Excel is a Dynamic Array function. In this video I use the FILTER function and run through the three arguments Filter by one criterion filtering by multiple criteria Filter by cell references and combing the SOFT function with the FILTER function. It doesn't work In Excel [----] or Excel [----] but it does work in Excel for the web. Topics covered in this video for the Filter Function 1) Filter by one criterion 2) Filter by one criterion with cell reference 3) Filter by multiple criteria 4) Filter by multiple with cell"
YouTube Link 2020-05-23T17:23Z 89.9K followers, [----] engagements

"Track Changes in Word: A Step-by-Step Tutorial In this video I demonstrate how to effectively use Track Changes in Microsoft Word. We'll cover how to turn on Track Changes understand the different tracking options such as insertions deletions formatting changes comments and moved content. Learn the difference between All Markup and Simple Markup and see how to handle Balloons and the Reviewing Pane thoroughly. You'll also learn how to accept reject changes and efficiently manage comments in your Word document. Track Changes is a powerful feature for document collaboration and this tutorial"
YouTube Link 2025-03-06T15:00Z 83.4K followers, [---] engagements

"Excel with Copilot: Deep Dive into Creating Worksheets from Scratch I explore the new feature of Copilot in Microsoft Excel for M365 license holders. We'll dive into creating worksheets from scratch using Copilot starting with an onboarding file and customizing it to fit various needs. See how Copilot can quickly generate worksheets add and tweak fields apply conditional formatting and even create an income statement. Copilot in Excel can suggest helpful fields you might not have considered and streamline your data organization process. Check out my full Copilot Excel OneNote and Teams"
YouTube Link 2025-07-10T14:22Z 87.9K followers, [---] engagements

"Zoom Polling - View all poll results at one time during a meeting Zoom's polling is a great feature. One tip that most users don't know is that you can view all polls' results during a meeting. By default as the host you can easily share one poll's results during the meeting but you can launch a web browser and see the results of every poll. This may be handy when you need to discuss the poll results or schedule breakout rooms based on poll results. Zoom's polling handles two question types. 1) True/False 2) Multiple Choice One poll can contain multiple questions. Chris Menard's blog post"
YouTube Link 2021-02-15T17:03Z 91.5K followers, 10.4K engagements

"Convert Hours & Minutes in Excel to decimals for billable hours by Chris Menard Time in Excel is tricky when you try to covert time to decimals. Example: 2:00 is two hours and zero minutes. Multiple 2:00 by $20 and you get [----] as a decimal. Two hours x [--] should be $40 billable amount. The trick is to multiply the hours and minutes by [--]. There are [--] hours in a day. Midnight in Excel is [--]. [--] Noon or [--] PM in Excel is [---] Chris Menard's Website: https://chrismenardtraining.com And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera"
YouTube Link 2019-01-12T17:34Z 86.9K followers, 170.3K engagements

"Excel - Vertical Analysis - Financial Statement Analysis - Income Statement and Balance Sheet Vertical Analysis is a financial statement analysis where all numbers on an income statement or balance sheet are shown as a percentage of a base figure within the statement. The base figure is revenue or net sales on the Income Statement or Profile and Loss Statement (P&L). On the Balance Sheet the base figure is Total Assets for the assets and Total Liabilities and Stockholders' Equity for the Liabilities and Equity. Technically you could use Total Assets since the balance sheet must balance."
YouTube Link 2022-09-26T14:00Z 77.8K followers, [----] engagements

"Outlook Scheduled Meeting attachments straight to calendar Here's a quick helpful tip showing how documents attached to a Teams meeting scheduled in Outlook will show up in your calendar in Teams too Hope this was helpful - for more tips make sure you subscribe to my channel #tutorial #teams #outlook #officetips -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera"
YouTube Link 2024-09-13T14:00Z 83.8K followers, [----] engagements

"Export & Import Quick Access Toolbar in Word Excel PowerPoint Desktop In this tutorial I'll show you how to export and import your Quick Access Toolbar customizations in Microsoft Word Excel and PowerPoint desktop versions. This is a crucial backup technique that can save you hours of work if your toolbar settings disappear after updates or system changes. I'll demonstrate the complete process using Word as an example walking you through how to access the export feature save your customizations and then restore them when needed. You'll learn where to find the import/export options in the More"
YouTube Link 2025-09-18T13:45Z 90.5K followers, [---] engagements

"Mail Merge in Word with Grouping records by Chris Menard https://youtu.be/DtPApM1Fv3k is the video where I type the code from start to finish. Link to Microsoft support site: https://support.microsoft.com/en-au/help/211303/how-to-use-mail-merge-to-create-a-list-sorted-by-category-in-word-2000 This short video demonstrates how to group records and do a Directory mail merge in MS Word. You must TYPE in the field codes. CTRL + F9 will insert the braces. I figured this out from Microsoft's support kb/294686. It works in all versions on MS Word. Here is my YouTube video where I type in the field"
YouTube Link 2015-03-12T15:55Z 85.1K followers, 157.9K engagements

"Get Users' Emails from Names: Microsoft [---] Copilot If you're a Microsoft [---] Copilot user you're in for a treat. This tool offers a feature that can significantly streamline your workflow by turning a simple list of names into a comprehensive list of email addresses. In this article we'll explore how to use Microsoft [---] Copilot to extract emails from names a function that can save you valuable time and enhance productivity. Dealing with Inconsistent Data Formats One of the challenges we often face is receiving lists of names that aren't formatted consistently. You might have some names"
YouTube Link 2025-05-19T14:47Z 86.3K followers, [---] engagements

"Year-Over-Year analysis in Excel using a PivotTable Year-Over-Year (YOY) growth compares one period usually a quarter or a month against the same period twelve months before. You can compare Q3 of [----] against Q3 of [----]. Another example is comparing the month of September [----] to September [----]. You can even compare one day to the same day in the previous year. A restaurant may want to compare Mother's Day revenue in one year against Mother's Day during the previous year. Advantage of Year-Over-Year Analysis The advantage of Year-Over-Year analysis is it removes the effects of seasons. For"
YouTube Link 2021-03-11T15:00Z 77.8K followers, 20.1K engagements

"Schedule a recurring Zoom meeting in Outlook by Chris Menard Scheduling a recurring Zoom meeting in Outlook is very easy. There are several methods of scheduling a meeting but to keep it easy I used the Zoom app to get started and did the recurrence in Outlook. Regardless of the calendar app Google Calendar Outlook etc. the recurrence is always scheduled in the calendar app. The meeting ID and password are the same for all the recurring meetings. That is a great feature. It would be a hassle if they were different for each recurrence. I'm using my free Zoom account in this video. Also I do"
YouTube Link 2023-10-12T06:56Z 60.3K followers, [----] engagements

"Show Heading [--] styles in your header in Word by Chris Menard If you have a long document for example an employee handbook you can put your heading [--] styles at the top to make it easy for users to see where they are. This is from my Word Intermediate training class. Microsoft Instructor in Atlanta. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web"
YouTube Link 2017-04-17T15:59Z 85.3K followers, 31.4K engagements

"Excel: IF function combined with AND and OR functions by Chris Menard Advanced IF functions using the OR function and the AND function. My video on the IF function for Administrative Professional Day Conference https://youtu.be/Ece19xIbMJ0 Covered in this video is IF with AND and OR. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera"
YouTube Link 2023-10-25T05:21Z 59.1K followers, 41.3K engagements

"Outlook Mail Merge: How to change default account for sending messages Doing an email mail merge in Outlook is easy but what if you have multiple email accounts and need to change the default account for sending emails This video applies to not only mail merge but changing your default email account in Outlook. There are two steps you need to do in Outlook. One is in Account Setting. That is where you change the default account. The second step is in Outlook options. You tell Outlook to always use the default account to send messages. Blog Post by Chris Menard"
YouTube Link 2021-09-13T13:00Z 88.7K followers, 93.5K engagements

"Zoom Advanced Polls - [--] new question types New Feature Nov [----] Zoom has a significant update for Meeting Polls. With Zoom 5.8.3 you can do Advanced Polling. There are six new question types in addition to single and multiple answers. You can now use short answer long answer matching rank answers rating and fill in the blank. Another great feature is that you can add images to Poll questions This is a HUGE update if you do polling in your meetings. Polls only work with a licensed account. You also must enable the Advanced Polling feature to use it. Everyone needs to be on the new update to"
YouTube Link 2021-11-09T15:09Z 89.8K followers, 33.9K engagements

"Microsoft Copilot in Excel: Create Worksheets from Prompts - NEW Feature May [----] Starting in May [----] Microsoft Excel's Copilot will have a new game-changing feature: It will allow users to create worksheets from prompts. This innovative tool simplifies data management by generating tables and workbooks through intuitive prompts. I will walk you through how to use Excel on the web to create tables and workbooks with the help of Copilot. Youll learn to utilize suggested prompts customize your data tables and add specific columns and themes. Copilot is efficient in creating sample data and"
YouTube Link 2025-05-08T14:28Z 85.9K followers, [---] engagements

"Microsoft Teams Notifications - Change Position with this New Feature Microsoft Teams has just rolled out an exciting new feature that allows users to control where their notification messages appear. As someone who has been eagerly awaiting this update I'm thrilled to share all the details about this game-changing functionality. The Problem with Default Notifications If you're like me you've probably found the default notification placement in Teams to be a bit frustrating. Messages popping up in the bottom right corner can distract and interrupt your workflow. I've often wished for more"
YouTube Link 2025-02-12T15:00Z 88.5K followers, [----] engagements

"Copilot in Excel: Advanced Text Splitting in Excel Copilot in Excel now handles advanced text splitting and data manipulation. Specifically we'll split text in column B which includes countries after a comma except for USA states. I'll show you how to use Copilot to add a new column and automatically place 'USA' for states or the respective country name for other entries. This includes employing a nested IF statement with the LET function. Follow along to see how Copilot handles this task efficiently. Chapters/Bookmarks 00:00 Introduction to Advanced Copilot in Excel 00:19 Setting Up the"
YouTube Link 2024-10-28T15:00Z 90.8K followers, [---] engagements

"Fix Cross-Tabular Data in Excel with Power Query Have you ever encountered messy Excel data that looks correct until you dig deeper In this tutorial I'll show you how to clean and transform Excel data using PowerQuery. Specifically I'll address an issue with two cross-tabular columns that need to be converted into a tabular format. We'll go through the steps of identifying the problem using Excel functions to check our data and finally leveraging PowerQuery to unpivot columns for a correct data table. I'll also highlight some key tips like ensuring customer numbers are formatted as text. We"
YouTube Link 2025-05-21T14:01Z 86.4K followers, [---] engagements

"Summarize Outlook Attachments with Copilot A new Outlook feature with Copilot: Summarize Email Attachments. Previously Copilot could summarize the body of your emails but now it can also summarize email attachments I'll walk you through how it works with a real example - summarizing Amazon's annual reports in PDF format. I'll also address some common questions like which file types can be summarized and which Outlook versions support this feature. This feature is a huge time-saver and I'm giving it a big thumbs up Check out my courses on Copilot Excel OneNote and Teams:"
YouTube Link 2025-07-08T14:07Z 87.9K followers, [---] engagements

"GROUPBY with HSTACK to combine Non-Adjacent columns in Excel In this video I demonstrate how to use the GROUPBY function in Excel to group rows and perform calculations on numeric fields. Unlike PivotTables GROUPBY is a formula that updates automatically and offers more options such as calculating MEDIAN and MODE or using LAMBDA functions. I'll also show you how to use the HSTACK function for columns that are not adjacent and well apply this by calculating total invoice amounts for different brands and dealerships or reps. Stick around for some tips and tricks to make your data analysis more"
YouTube Link 2025-03-28T15:00Z 84.3K followers, [---] engagements

"Import CSV into Google Calendar - [--] Troubleshooting tips Fix importing problems Import events to Google Calendar is a popular topic. Recently university students have asked why their CSV import is not working or only some of their records are importing. This short video will cover seven troubleshooting tips for importing your CSV file into Google calendar. We will look at required fields date and time formats all-day events end dates and start dates being negative numbers blank rows and columns and other importing issues. After going through the troubleshooting tips we will test the import"
YouTube Link 2021-09-15T18:36Z 89.8K followers, 12.6K engagements

"Naming Files correctly with YYYYMMDD by Chris Menard When naming your files always start off with a four digit year two digit month and two digit day. Never uses spaces. Underscores and dashes are fine. A file naming convention (FNC) can help you stay organized by making it easy to identify the file(s) that contain the information that you are looking for just from its title and by grouping files that contain similar information close together. A good FNC can also help others better understand and navigate through your work. 00:20 - batch renaming with F2 key. 01:12 - adding tags to files."
YouTube Link 2016-11-09T23:13Z 88.8K followers, [----] engagements

"COPILOT() Function in Excel: NEW Excel Superpowers 🚀 Bring AI to Your Formulas with the COPILOT Function in Excel Wrangling data summarizing feedback categorizing information and brainstorming ideas can be painful and time-consuming. But now theres a smarter way. The new COPILOT function in Excel for Windows and Excel for Mac is here to save time and supercharge your workflows ✅ Just type a natural language prompt directly in your spreadsheet. ✅ Reference cell values as needed. ✅ Watch Copilot instantly generate AI-powered results. Getting started: syntax and basic usage The Copilot function"
YouTube Link 2025-08-25T15:40Z 89.7K followers, [----] engagements

"How to Use Copilot in Teams Meetings Teams Meetings Recaps and More with Microsoft Copilot. I walk you through how to use Microsoft [---] Copilot in Teams meetings. Learn how to ask questions and get meeting recaps seamlessly. I'll cover the key requirements including which M365 Copilot license you need hosting meetings within your organization while having transcription turned on. I also demonstrate how to leverage features such as obtaining meeting summaries engaging with prompts and using the new audio recap function. Additionally I explain the Facilitator feature in Teams Meetings and how"
YouTube Link 2025-10-07T13:45Z 91.1K followers, [----] engagements

"Excel: Reduce the file size of your Excel workbook Excel tips and tricks Have you ever had a large Excel file that you know should be significantly smaller There are a couple of tricks to reducing the file size. One tip is to delete all blank rows and columns in the file. Another tip is to delete any worksheets you do not need. I show how to use Workbook stats to see file information. Chapters: 0:00 Intro 0:21 Initial file size 0:50 Workbook stats 1:30 CTRL + Home 1:42 CTRL + END 2:35 CTRL + SHIFT + Right arrow 3:05 CTRL + SHIFT + Down arrow 4:05 Signs your file is too large And make sure you"
YouTube Link 2021-07-13T13:30Z 83.9K followers, 107.3K engagements

"Three reasons to use OneNote - Microsoft's digital note taking app by Chris Menard OneNote is Microsoft's free notetaking app. It is free OneNote uses Notebooks Sections and Pages to help you organize your notes. Three reasons I love OneNote: * I can pull in Outlook Meeting details. I can later email the meeting notes out. 01:10 * OneNote can copy and paste text and when you copy and paste text from a webpage it automatically adds the URL of a webpage. If you copy and paste the link to a video it puts in the video thumbnail and the video. 02:40 * OneNote searches are easy and fast. OneNote"
YouTube Link 2023-10-17T08:08Z 59K followers, [----] engagements

"Excel - Find & Highlight Duplicate Rows - [--] Methods Conditional Formatting Microsoft Excel can find duplicates easily with Conditional Formatting. The issue is Conditional Formatting finds duplicates based on the cell value but I want to find duplicate rows. I use three methods in the video to find duplicate rows. I start off with CONCATENATE then use the TEXTJOIN function and finally COUNTIFS with no helper column. To highlight the rows I use Conditional Formatting using a formula. Chapters: 00:00 Introduction 00:14 Duplicate cells 00:58 Conditional formatting works on cells 01:49 Method [--] -"
YouTube Link 2021-09-01T13:08Z 78.7K followers, 96.7K engagements

"MS Teams: Working with the NEW Chat and Channels Experience The new chat and channel experience in Microsoft Teams is designed to streamline collaboration and enhance productivity in the hybrid workplace. Here are some key features: [--]. Unified Workspace: Chats teams and channels are now consolidated into one place under the Chat tab making it easier to navigate and prioritize conversations without switching contexts. [--]. Customizable Views: Users can choose to keep chats and channels combined or separate them based on their preferences. This flexibility allows for a more personalized"
YouTube Link 2025-01-25T05:31Z 81.2K followers, [---] engagements

"Excel WRAPCOLS & WRAPROWS Functions Explained How to use the WRAPCOLS and WRAPROWS functions to organize and restructure your data into structured layouts. Youll learn how to use WRAPCOLS to split a single column of data into multiple columns and WRAPROWS to split a single column into multiple rows. Ill show you how the arguments work and demonstrate how these functions automatically update when you add more data to your table. Youll see how to format a list of items control the number of rows or columns and even apply it in practical examples like grouping employees or randomizing lists. By"
YouTube Link 2025-09-24T13:45Z 90.7K followers, [----] engagements

"Adobe Acrobat Tutorial: Creating a Binder vs. Portfolio In this video I explain the differences between a Binder and a Portfolio in Adobe Acrobat Pro and guide you step-by-step on how to create both. I start by showcasing the Binder which merges various file types (Word Excel PDF) into a single PDF file. Next I demonstrate the Portfolio feature which keeps the original files separate within a single PDF container allowing them to be opened in their native applications. An Adobe Portfolio and an Adobe Binder are two different ways to combine multiple files into a single PDF but they serve"
YouTube Link 2025-01-15T15:01Z 90K followers, [----] engagements

"Excel - AutoComplete for Drop-down List - New Feature Coming to M365 Putting in data in Excel can be a slow process and errors can be made. AutoComplete and dropdown list are two features currently available in Excel. AutoComplete happens when you start typing in an item you have used previously in a column. Drop-down lists are created with Data Validation and ensure only the correct items that belong in a column are entered. For example a department column shouldn't show the Accounting department as "Accounting" and later as "Acct". Rolling out for Microsoft [---] users is AutoComplete and"
YouTube Link 2022-07-11T13:00Z 88.9K followers, 101.1K engagements

"Easy Travel Itineraries with TripIt App Simplify Your Travel Plans with TripIt: A Step-by-Step Guide Discover TripIt the ultimate travel itinerary organizer I walk you through using TripIt from scratch showing how it handles your car rentals flights hotels and activities taking the pain out of organizing your trips. Learn how to sign up for a free account add a new trip sync your travel information from emails and manage multiple email addresses. Get all your travel plans in one place for easy access on any device. See how TripIt can make trip planning stress-free and efficient. TripIt"
YouTube Link 2025-06-17T14:01Z 87.3K followers, [---] engagements

"Excel PivotTable - show months with no data Excel Pivot Tables only show months that have data. When you create a Pivot Table with months some months may disappear since there is no data for that month. In my example there is no data for April and November. I'm going to run through five easy steps to show months with no data. We will create a pivotable group by months show items with no data filter the report and fill empty cells with a zero. Chapters: 00:00 Introduction 00:12 Topics 00:31 Let's dive into it 00:51 Creating the PivotTable 01:08 Group by month 01:32 Show items without data"
YouTube Link 2021-09-30T15:14Z 78.1K followers, 14.2K engagements

"Excel: PivotTable with Conditional Formatting - Data Bars In this video I demonstrate how to add Conditional Formatting to a PivotTable in Excel. Watch as I go through the steps of inserting a PivotTable choosing the fields (Brand Rep and Invoice Amount) and applying Data Bars with a green gradient fill. I show how to properly format all the cells and avoid applying conditional formatting to subtotals and grand totals. Learn how to tweak and manage your conditional formatting rules effectively. My online Excel training class is available for those who want to dive deeper. Thank you for"
YouTube Link 2025-03-24T15:01Z 84.1K followers, [---] engagements

"How to use the SUM Function and AUTOSUM in Microsoft Excel Tutorial for Absolute Beginners The SUM function is the most popular and widely-used function in Microsoft Excel along with its automated version: AutoSum. When you click AutoSum Excel automatically enters a formula (that uses the SUM function) to sum the numbers. In this video I demonstrate the SUM function and show you a few tips that you may not know even if you've used the SUM function for a while. In this tutorial I demonstrate the various usages of SUM and AUTOSUM using [--] example worksheets. The AutoSum function automatically"
YouTube Link 2021-04-26T15:45Z 89K followers, 39.6K engagements

"Getting started with PivotTables in Excel PivotTables are one of Excel's most powerful features. PivotTables quickly analyze and summarize complex data. In this LIVE session with Chris Menard you will learn how to create a PivotTable use PivotTable fields work with subtotals and grand totals and create PivotCharts. We will create over [--] PivotTables in this Getting Started with PivotTables session. We will work with text numbers and date data types in our PivotTables. Chapters: 00:00 Intro screen 02:20 Chris Menard intro 02:45 What is a PivotTable 03:00 PivotTable [--] - Sum Average and Max 07:47"
YouTube Link 2023-02-23T06:04Z 90K followers, [----] engagements

"Copilot in Word: Quickly Add Numbers with Ease As a Microsoft Word user have you ever found yourself faced with a list of numbers that need to be added up quickly Perhaps you've resorted to manually calculating them or exporting the data to Excel for a simple sum. In this post we'll explore how Copilot in Word can effortlessly add up numbers saving you time and reducing the risk of calculation errors. Let's dive in and see just how powerful this tool can be Thumbs up for Copilot in Word To demonstrate the capabilities of Copilot in Word I've prepared a document with a list of numbers each in"
YouTube Link 2025-04-29T14:01Z 85.6K followers, [---] engagements

"Backup vs. Synchronization (Sync) - Sync using Total Commander This video shows the difference between a backup vs sycn. Windows by default can't sync. You need another program. I use Total Commander. What is the difference between a backup and sycn Backup copies data from one location to another. Going from your laptop ro desktop to an extermal hard drive or flash drive is a backup. Synchronization makes sure that two locations example desktop and flash drive contain the same up-to-date files. If you add change or delete a file from one location the synchronization process will add change or"
YouTube Link 2015-01-27T18:55Z 84K followers, 13.8K engagements

"OneDrive - Teams and Outlook folders automatically created in OneDrive Microsoft OneDrive for Work or School formerly known as OneDrive for Business creates folders for Teams and Outlook files. The Teams folders are Microsoft Teams Chat Files and Recording folders. The Microsoft Teams Chat Files shows files you uploaded in chat by clicking the paperclip icon. The Recordings Folder shows meeting recordings that are stored in OneDrive. Teams Recording has an expiration date for most companies. You can find a recording in the OneDrive Recycle Bin if a recording gets deleted. Important recording"
YouTube Link 2022-10-12T15:31Z 90.9K followers, [----] engagements

"Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver Outlook Contact Groups formerly called Distribution List are great for saving time. Instead of typing in [--] emails type in the name of the Contact Group. I'll show a nifty trick for using Contact Groups when scheduling meetings in this video. Chapters: 00:00 Introduction 00:37 Creating the contact group 03:58 Calendar Meeting Trick 05:43 Closing remarks Create a Contact Group: 1) Click the People icon. 2) Click New Contact Group in the New group. 3) Name your Contact Group. 4) Add Members by clicking the"
YouTube Link 2022-06-06T13:00Z 90K followers, 15.7K engagements

"Google Maps Timeline - Explore and Manage Your Location History Google Maps Timeline shows where you have been and how you got there. Timeline uses your Location History. In this video I'll show you how to edit your Timeline anytime delete one day and delete your entire timeline. Good news Your timeline is private so only you can find it. Timeline is available on smartphones and your computer. Chapters: 0:00 Intro 0:29 Pull up Timeline 1:35 Change Year Month Day 2:27 See Timeline from website 3:42 Delete all location history Timeline on your computer ******** 1) Open Google Maps. 2) Sign in"
YouTube Link 2022-06-21T15:45Z 84.3K followers, 43.3K engagements

"Pull Stock History into Excel w/ the Stock History Function The Stock History Function in Excel allows you to view historical data of stocks and other financial instruments in either daily weekly or monthly views. You can see the closing price opening price high price low price and even volume. Syntax of the function - STOCKHISTORY =STOCKHISTORY(stock start_date end_date interval headers property0 property1 property2 property3 property4 property5) StockHistory video by Chris Menard is featured on Microsoft's Tech Community page."
YouTube Link 2020-06-16T19:18Z 85.9K followers, 49.9K engagements

"Zoom Save and Reuse Breakout Room Assignments - Zoom 5.10.0 Zoom Save and Reuse Breakout Room Assignments - Zoom 5.10.0 version is required. Zoom's Breakout Rooms are trendy. Breakout Rooms can be named and people assigned to your breakout room before the meeting or during your Zoom meeting. Now you can SAVE and REUSE your Breakout Rooms and Assignments. SAVE and REUSE Breakout Room is an excellent feature for college professors and companies. For example if you are an educator you can assign groups of four students to rooms and save them for the next meeting. If you work at a company you can"
YouTube Link 2022-04-15T13:00Z 85.9K followers, [----] engagements

"Excel: EOMONTH DATE YEAR MONTH date functions by Chris Menard There are over [---] functions in Excel. When it comes to dates there are five functions you must know. EOMONTH DATE YEAR MONTH and DAY are among them. In this video I analyze getting paid twice a month or semi-monthly. To calculate the last day of the monthly I use the EOMPNTH function. It is nested inside the DATE function. Here is a breakdown of the functions: YEAR function - gives you a year. If an invoice date is 7/14/2021 the year function will pull out the year and return [----]. MONTH function - gives you a month. If an invoice"
YouTube Link 2020-04-12T17:43Z 77.8K followers, 22K engagements

"NEW Checkboxes feature in Excel Excel users rejoice Microsoft has introduced an exciting new feature that's set to revolutionize the way we handle data entry and analysis: Checkboxes. This powerful addition is now available in Microsoft [---] for Windows PC and Excel on the web. In this blog post we'll explore how to use checkboxes effectively their benefits and some creative ways to incorporate them into your spreadsheets. Bookmarks/Chapters 00:00 Introduction to Excel Checkboxes 00:21 Setting Up Checkboxes 00:39 Using and Managing Checkboxes 00:55 Counting Checkbox Values 01:25 Conclusion and"
YouTube Link 2025-01-13T15:01Z 80.8K followers, [---] engagements

"Exploring the New Microsoft Teams Calendar: Features and Updates In this video I explore the new Microsoft Teams desktop calendar and its exciting updates. While the old calendar lacked a Month view the new version includes it and mirrors the modern Outlook on the web calendar. Learn how to toggle various views like Work Week and Month manage multiple time zones and use the filtering feature to customize displayed appointments and meetings. I'll also discuss a couple of minor issues such as renaming categories and ensuring Teams meetings are set by default and how to navigate these through"
YouTube Link 2025-02-20T15:01Z 83.9K followers, [---] engagements

"Excel Power Query: Fix Commas in Data Advanced Workflow Advanced Power Query Techniques in Excel: Splitting and Transforming Data cleaning Commas extra spaces and more. In this tutorial I'll walk you through an advanced Excel technique using Power Query to split and transform your data for better sorting and filtering. This step-by-step guide will show you how to handle data separated by commas convert it into a table and then break it into rows for easy manipulation. I'll also show you how to clean up any leading spaces in your data and keep your tables updated automatically. Perfect for"
YouTube Link 2025-07-25T13:45Z 88.4K followers, [---] engagements

"Excel Merge and Center is EVIL: And How to Fix It If youre an Excel user like me youve probably encountered the temptation to use the Merge and Center feature to make your spreadsheets look neat and tidy. But let me tell you straight: Excel Merge & Center is evil when it comes to managing your data effectively. It causes more trouble than its worth especially when you want to sort filter create PivotTables or analyze your data. Ive experienced this firsthand and in this article and video Ill walk you through why you should avoid using Merge and Center in your data how to find merged cells and"
YouTube Link 2025-08-01T13:45Z 88.8K followers, [----] engagements

"Microsoft Teams: Latest Updates and Feature 🚀 Join Us for an Exciting Live Stream on Microsoft Teams 🚀 📅 Date: March [--] [----] 🕛 Time: 12:00 PM - 12:45 PM Eastern Time 📍 Platforms: YouTube & LinkedIn We're thrilled to announce a special live stream featuring the latest and greatest updates in Microsoft Teams 🌟 What's New 🗓 NEW Calendar 💬 Chat and Channel Combined 📏 Resize the Rail in Teams 🔔 Place Notifications Where You Want 📅 Schedule Channel Posts .and many more exciting features Presenter: Chris Menard Microsoft Certified Trainer and Public Speaker will guide you through these"
YouTube Link 2025-03-15T04:47Z 83.7K followers, [---] engagements

"Calculate the Compound Annual Growth Rate (CAGR) in Excel by Chris Menard The Compount Annual Growth Rate shows the growth rate that gets you from the initial value to the ending value. CAGR assumes that the initial value has been compounding over the time period. You can also use CAGR to forecast where you will be in the future. I use Compound Monthly Growth Rate to analysze my YouTube subscribers. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod"
YouTube Link 2019-06-09T16:51Z 90.9K followers, 49.3K engagements

"Create a treemap in Excel [----] by Chris Menard A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns such as which items are a store's best sellers. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera https://amzn.to/2Tg75Sn Shock mount - https://amzn.to/3g96FGj Boom Arm - https://amzn.to/3g8cNi6 --"
YouTube Link 2017-03-03T20:06Z 89.2K followers, 15.8K engagements

"Microsoft Teams: New Feature - Resizable Panes In this video I demonstrate a new Microsoft Teams feature that allows users to resize their panes. This update enhances user experience by providing flexibility in viewing the Teams calendar chat and other components on the far-left rail. I show how to navigate and utilize this feature across different applications within Teams and discuss some limitations. Don't miss my live on the latest Teams updates on Friday March 14th from 12:00-12:45. 00:00 Introduction to New Teams Feature 00:03 Upcoming Teams Event Announcement 00:14 Feature Overview:"
YouTube Link 2025-03-10T15:01Z 83.4K followers, [---] engagements

"Excel for the Web - Text to Columns - New Feature Excel for the Web now has the Text to Columns feature available. If you have a list of names in column A that has first names and last names for example Chris Menard you can now use Text to Columns to separate the names so you can sort by last name. If both names are in column A you can't sort by last name. I also show the desktop version of Text to Columns in this video. Chapters: 0:00 Intro 0:28 Text to columns desktop 1:07 Text to columns web 1:49 Len function And make sure you subscribe to my channel -- EQUIPMENT USED"
YouTube Link 2021-08-06T14:46Z 89.9K followers, [----] engagements

"Geography Data Type - Excel for the Web You can get geographic data in Excel for the Web. It is straightforward. Just type text such as States Countries or Cities into a cell and converting it to the Geography data type. The Geography data type is considered a linked data type because it connects to an online data source. It pulls in information such as population capitals area median income and other information. I added the full list below. The Geography data type is available on Excel for Microsoft [---] Excel for Microsoft [---] for Mac Excel for the web Excel for iPad Excel for iPhone Excel"
YouTube Link 2020-06-22T15:26Z 89.9K followers, [----] engagements

"Microsoft Teams: Real Time Microphone Volume Monitoring How to Use the Real Time Mic Volume Indicator in Microsoft Teams: A new and seemingly small feature in Microsoft Teams called the Real Time Mic Volume Indicator. This feature is applicable to Teams meetings and works on both Mac and Windows desktops. I'll show you how to find and use this indicator which displays your mic activity during meetings. My courses for Teams Excel Copilot and OneNote are here: https://courses.chrismenardtraining.com Chapters: 00:00 Introduction 00:22 Real Time Mic Volume Indicator 00:37 Using the Feature in a"
YouTube Link 2025-07-29T13:49Z 88.6K followers, [---] engagements

"AutoSave in [---] - Word - Must save to OneDrive by Chris Menard When using AutoSave in Office [---] you must save the file first and you must save it to OneDrive. Saving locally to Documents or Desktop will not turn on AutoSave. And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera https://amzn.to/2Tg75Sn Shock mount - https://amzn.to/3g96FGj Boom"
YouTube Link 2017-11-06T16:29Z 91.5K followers, 27.7K engagements

"Copilot Chat: Ask Questions About Word and PDF Files Microsoft Copilot Chat allows you to upload files and ask questions about them (Word and PDF). This guide showcases step-by-step how to use Copilot to extract information from documents such as financial reports with examples including Microsoft's annual report. This feature is available to Microsoft Business and Enterprise users. Learn about the seamless integration with OneDrive and how to manage uploaded files as well as its compatibility with both Word and PDF formats. My courses: https://courses.chrismenardtraining.com More Copilot"
YouTube Link 2025-04-04T13:58Z 84.5K followers, [---] engagements

"Excel - Sort by Color and Sort Using Conditional Formatting Sorting in Excel gives us a lot of options but many users do not know you can sort by cell color and font color. You can also use Conditional Formatting and sorting. Chapters/Bookmarks 0:00 Intro 0:14 Sort by color 2:47 Sort by Conditional Formatting 3:57 Put the selected cell color on top Popular Excel videos Title Watch Url Excel PivotTable - Percentage of Row Totals and Five Awesome Tips https://www.youtube.com/watchv=6v2aj1GE3fg Excel Tiered Conditional Formatting with Dates using functions AND and TODAY"
YouTube Link 2023-06-26T14:33Z 90.1K followers, 16.3K engagements

"How Long to Double Your Money with the Rule of [--] Excel Tutorial Understanding the Rule of 72: How to Double Your Money with Interest I explain the Rule of [--] and how it can help you determine the number of years it takes to double your investment at a fixed interest rate. Using examples and Excel functions I demonstrate the accuracy and limitations of this rule at different interest rates. You'll learn how to apply this rule to your investments and understand its effectiveness in various financial scenarios. I guide you through this powerful financial tool. Download the Excel file used in"
YouTube Link 2025-06-06T14:01Z 86.9K followers, [---] engagements

"Create Sample Data in Excel with Free Copilot Chat You can use the free Copilot Chat to generate sample data for Microsoft Excel. This is perfect when you need fictitious customer information and order records for training presentations or testing purposes. I walk you through creating an Excel file with a complete customer list including fields like names cities states emails and customer dates. Then I demonstrate how to add a related orders table while keeping everything organized in one workbook. Copilot Chat automatically structures the data as tables and even names them appropriately."
YouTube Link 2025-10-01T13:45Z 90.9K followers, [---] engagements

"Zoom polling - Reuse polls in meetings Zoom's polling feature allows you as the host to create true/false or multiple-choice polling questions for your meetings. When you are in a meeting you can launch the poll and have attendees answer the questions. Your poll questions for your Personal Meeting ID (PMI) are available when you have a meeting with your PMI but what do you do when you need to save poll questions for dynamic or Zoom system-generated meetings My answer is to create templates in Zoom and save your poll questions with the template. The next time you need those poll questions"
YouTube Link 2020-11-25T14:56Z 91.3K followers, 17.4K engagements

"Excel how to use a 3D reference to add worksheets by Chris Menard Chris Menard shows you the correct way to add multiple worksheets using a 3D Reference in Excel. This works in any version of Microsoft Excel. Chris provides on-site instructor-led training. Chris Menard's Website: https://chrismenardtraining.com Free class on Excel Tables: https://chrismenardtraining.teachable.com/p/excel-tables And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod"
YouTube Link 2013-06-06T15:43Z 89.2K followers, 121.2K engagements

"Microsoft Teams New Hyperlink Feature I will demonstrate the new hyperlink feature in Microsoft Teams which is available for chats and channel conversations. You will learn how to easily insert and shorten hyperlinks for cleaner more readable messages. I will walk you through the steps of copying a URL inserting it into a message and testing the link. You can also find out about my Microsoft Teams online training and other online classes. Have a great day ✅Bookmarks/Chapters 00:00 New Hyperlink Feature in Microsoft Teams 00:18 How to Insert a Hyperlink 00:43 Testing the Hyperlink 00:50"
YouTube Link 2025-02-06T15:01Z 82.1K followers, [---] engagements

"Updating to Zoom [---] & Reporting a user by Chris Menard Starting May [--] [----] Zoom users must be on client [---] in order to join a Zoom meeting. There are security enhancements in Zoom [---]. Another new feature is the ability to report a user during a meeting. This is under the Security tab in the Meeting controls. To report a user: Click Security click Report Find the user to report and check the appropriate reasons for reporting. Zoom support article https://zoom.us/docs/en-us/zoom-v5-0.htmlzcid=1231 Chris Menard's Zoom support page: https://chrismenardtraining.com/zoom And make sure you"
YouTube Link 2020-05-29T19:37Z 88.3K followers, [----] engagements

"What-If analysis in Excel with a Data Table by Chris Menard Excel offers either one input or two input data table. Both are available under the Data tab What-if analysis. You need both input and dependent cells to do a data table. A Data Table allows you to have multiple inputs and see how different inputs values would impact the result. This is extremely useful to analyze a problem in Excel. Blog Post on Data Tables: https://chrismenardtraining.com/post/data-table-excel-what-if-analysis Chris Menard's Website: https://chrismenardtraining.com And make sure you subscribe to my channel --"
YouTube Link 2018-03-27T21:03Z 78K followers, 367.3K engagements

"Analyze Data Command in Excel - Ask questions about your data using AI Need to quickly understand your data in Excel and ask questions about your data Easy to do using Excel's Analyze Data command located on the Home tab in Excel. Analyze Data using Artificial Intelligence (AI). You can type questions and Excel will return results in a PivotTable format. For example I can type "Show me our three largest clients for 2023" Analyze Data will give you the answer. Analyze Data also shows you charts for your data and even displays possible questions you may want to ask. Analyze Data is on the Home"
YouTube Link 2023-04-03T15:25Z 90.1K followers, [----] engagements

"Excel - Share a PivotTable without the Source Data or Underlying Data. When you share a PivotTable in Excel even if you delete the data source worksheet the data source is still attached to the PivotTable. It is called PivotTable cache. It is possible to share PivotTable results without the underlying data. You need to use Paste Special along with Paste Formats. Chapters 0:00 Intro 0:13 Delete the data tab 0:52 Show data 1:44 Copy Paste Values and Paste Format 2:40 Summary Blog Post https://chrismenardtraining.com/post/excel-share-a-pivottable-without-the-source-data #exceltraining"
YouTube Link 2022-09-06T13:00Z 78K followers, 15.7K engagements

"How to Add or Change your Profile Picture in Teams In this video I'll walk you through the process of changing your profile picture in Microsoft Teams and how it affects your entire M365 ecosystem. Here's what we'll cover: I'll show you how to access your profile settings in the Teams desktop app navigate to the profile picture change option upload a new image (with tips on image size) save your new profile picture and understand how this change affects other M365 apps. 0:00 Introduction 0:15 Accessing Profile Settings 0:30 Changing Profile Picture Options 0:45 Uploading a New Image 1:00"
YouTube Link 2024-08-12T14:00Z 84.3K followers, 14K engagements

"Excel - Getting started with Data Validation List Creating a Data Validation List is a great way to make sure you have "good" data. For example I may type Human Resources as a department but later in my data I see HR. I know that HR and Human Resources are the same but Excel doesn't. My PivotTables Filters Sorting SUMIF COUNTIF and other items will not be accurate. One easy way to fix this is using Data Validation List. I show two methods in this video but there are other methods. Data Validation is on the DATA tab. Screenshot of Data Validation"
YouTube Link 2023-07-31T13:30Z 94.3K followers, [----] engagements

"Customize Windows System Tray: Hidden Features & Keyboard Shortcuts I show you how to master the Windows system tray (notification area) in Windows [--] and [--]. You'll learn where to find it what it does and how to customize it for your workflow. I cover the essential keyboard shortcuts you need: Windows + N for notifications and Windows + A for quick settings. I also walk through the taskbar settings where you can control which icons appear in your system tray plus a faster drag-and-drop method for customization. Keeping frequently used items like OneDrive VPN or other critical apps visible"
YouTube Link 2025-10-21T13:45Z 92.5K followers, [----] engagements

"Conditional Formatting with Icon Sets in Excel Conditional formatting in Excel has an Icon Set feature. Icon Sets have a variety of different icons. You can use icons shapes indicators and direction arrows. This is great for visualizing the selected values by giving them different meanings to them. In this video I'll use two examples with monthly data and icons sets. 00:00 Introduction 00:18 Icon set example [--] 01:15 Manage rules - use number 02:37 Show icon only 03:01 Icon set example [--] 04:40 Closing remarks Conditional Formatting videos by Chris Menard: Excel Advanced Conditional Formatting"
YouTube Link 2022-02-10T16:26Z 94.2K followers, 83.5K engagements

"Outlook on the web - [--] Calendar features the desktop version doesn't have Outlook on the web has a lot of features that Outlook desktop doesn't have. I'll cover three calendar features that Outlook on the web has that Outlook desktop doesn't provide. We will look at filtering calendar appointments and filtering by category. Next we look at how much easier it is to schedule meetings with Outlook on the web. Outlook on the web has a Board feature also. Finally we will take a quick look at the new Outlook desktop coming out soon. 0:00 Intro 0:30 Outlook on the web 0:58 Filter the calendar 2:40"
YouTube Link 2023-05-05T16:05Z 93.6K followers, [----] engagements

"OneNote Share Section - [--] Workarounds to Share Just a Section OneNote is an incredibly versatile tool for capturing notes organizing ideas and collaborating with others. However a common question that arises is: Can you share just a section of a OneNote notebook with someone else The straightforward answer is no; OneNote doesnt allow you to directly share a single section on its own. However there are effective workarounds that can help you achieve the same goal. In this article Ill share three practical tips to help you share a OneNote section with others whether you want them to co-author"
YouTube Link 2025-05-29T14:02Z 93.7K followers, [----] engagements

"Unveiling Snagit 2025: Master the New Steps Capture Feature I have exciting news for Snagit users: Snagit [----] is here with a fantastic Steps Capture feature In this video I demonstrate how to use this new tool illustrating with examples in Excel. I show you how to change the font color sort data and perform multiple sorts while recording each step. The new Steps Capture feature automatically records your actions making it easier to create detailed guides. Additionally I explain how to edit move and delete steps change step appearances and export your workflow as a PDF. This feature is a"
YouTube Link 2025-02-18T15:00Z 82.6K followers, [---] engagements

"Sum up hours and minutes in Excel by Chris Menard If you need to total hours and minutes in Excel you need to add an open and closed bracket around the h for hours. Example: h:mm;@ You will use a Custom Category under Format Cells. Here is a sample Excel file if you get stuck. https://1drv.ms/x/sAlMvSeFCSQ84iIpQlvenBhahDXGDZQ *********** Chris Menard's Website: https://chrismenardtraining.com Free class on Excel Tables by Chris Menard https://chrismenardtraining.teachable.com/p/excel-tables And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera"
YouTube Link 2017-05-02T14:14Z 92.6K followers, 269.3K engagements

"PowerPoint: Morph one shape into another shape by Chris Menard PowerPoint Morph feature will now allow you to morph one shape into another shape. The trick when it comes to shapes is to name the two shapes the same name with exclamation points. Examples: Shape1 or Car or Shape15 And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera"
YouTube Link 2019-02-21T14:45Z 93.7K followers, 49.8K engagements

"Microsoft Copilot for Word: Reference Folder and Large File Support Microsoft Copilot continues to evolve bringing powerful new capabilities to improve productivity in Word. One of the most exciting recent updates is the ability to reference an entire folder in Copilot for Word instead of being limited to referencing individual files. Alongside this Copilot now supports working with massive documents containing up to [---] million words roughly equivalent to a 3000-page file. These enhancements are designed to streamline how you generate content summarize information and draft documents by"
YouTube Link 2025-05-06T14:12Z 92.2K followers, [----] engagements

"Copilot's Think Deeper Mode: Financial Calculations I show you how to use Microsoft [---] Copilot Chat's new "Think Deeper" mode to handle complex financial calculations. I walk through a real example calculating investment returns and projecting future account values with different contribution amounts. You'll see how Copilot's "think deeper" feature works through multi-step financial problems generates Excel files with proper formulas and provides multiple scenarios without prompting. I verify the calculations using an online calculator to confirm accuracy.I demonstrate the correct way to"
YouTube Link 2025-12-10T15:04Z 93.9K followers, [---] engagements

"Markup vs. Margin: Whats the Difference Explained using Excel Margin or profit margin and markup are both accounting terms that use the same inputs - Revenue cost and profit but they show different information. Both profit margin and markup use revenue and costs as part of their calculations. Revenue - Cost = Profit. The difference is margin takes the profit and divides it by Revenue or Retail price to get the margin percentage. Markup takes profit and divides it by cost to get the Markup percentage. Here is an easy example. An item costs $8 and your markup is $2 for a retail price of $10."
YouTube Link 2021-10-19T13:52Z 94K followers, 23.1K engagements

"Annual Percentage Yield (APY) and Future Value and Effect function in Excel by Chris Menard APY vs. Interest Rate. Learn the difference between the Annual Percentage Yield (APY) and the Interest Rate. We will also look at the Future Value function and the Effect Function in Excel. The APY uses both the interest rate and compounding interest. APY takes compounding into account while the interest rate does not. APY is prominently displayed on savings accounts and CD accounts. Here is an example of APY vs Interest Rate: Bank A is offering a 1.69% interest rate and Bank B is offering a 1.70%"
YouTube Link 2020-01-09T15:31Z 92.9K followers, 18.7K engagements

"Excel - IF Function using AND and OR One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example if the value in cell B2 is over $5000 give them a 2% discount. Another example is if the years of service for an employee is over [--] years give them [--] weeks of PTO. The IF statement takes a lot of manual work out of calculations. Two other functions in Excel are AND and OR. We will combine IF with AND and OR in this video. Chapters/Bookmarks 0:00 Intro 0:16 IF and AND functions nested 3:08 IF and OR functions nested #chrismenardtraining"
YouTube Link 2023-09-07T15:11Z 94.3K followers, 88.4K engagements

"Word Template with file name and path by Chris Menard If you type the same header and footer repeatedly in your Word documents you should save a Word document as a Template. After adding your header and footer make sure the document has nothing on it in the body. [--]. Click File [--]. Save As [--]. Type in a filename [--]. Change the File type to from a Word Document to a Word Template 01:48 When you are ready to use your template 02:25 [--]. Click on File [--]. Click on New [--]. Click Personal [--]. Click the Template you want to use ********************** About Chris Menard ********************** Chris Menard is"
YouTube Link 2016-09-09T15:29Z 92.6K followers, [----] engagements

"Outlook on the web: [--] tips including send later snooze and undo send Outlook on the web has everything you need to be your most productive and connected self. I love the desktop version but the web version has a few features that aren't available in the desktop version. The good news is you can run both at the same time. They are always in sync. The Focused Inbox divides your inbox into two tabs: the Focused Tab and the Other Tab. Your most important email messages are on the Focused tab while the rest remain easily accessiblebut out of the wayon the Other tab. To turn on the Focused Inbox"
YouTube Link 2020-08-20T12:42Z 93.6K followers, [----] engagements

"Outlook: Create Contact List using Outlook on the Web - aka Distribution List A contact list is a collection of email addresses and is useful for sending emails to a group of people. Contact lists are sometimes referred to as distribution lists. You can create a contact list using Outlook on the Web. I've covered this feature using Outlook on the desktop. Those videos are listed below in the description. Example of a contact list for Vendors. You have [--] vendors you need to email explaining a new policy. You can create a contact list called Vendors add all [--] emails and now when you email"
YouTube Link 2022-02-03T15:34Z 93.6K followers, 25.4K engagements

"Excel DateDif function - difference between two dates In Excel if you need to calculate the difference between two dates in years month or days the DATEDIF function will handle it. DATEDIF is "Date & Dif". It is an interesting function since it does not show up in the Date & Time function in Excel. DATEDIF has three arguments - start date end date and date unit (year/month/ or date). Reason to use DATEDIF Get days months or years between two dates HR could use this to see how long employees have worked. We could track how long customers have been in the system. Syntax =DATEDIF (start_date"
YouTube Link 2020-10-19T13:22Z 94K followers, 26.1K engagements

"Excel - [--] Methods to Shade Every Other Row Highlighting or shading every other row in Excel is a great way to make your data easier to read. I'll show three methods for applying color to alternate rows. Method [--] is my least favorite but I see users doing this a lot. Method [--] is one of my favorite features in Excel but for the most control use method [--]. Method [--] is Conditional Formatting and I use the MOD Function and the ROW function. The MOD function returns the remainder of one number divided by another. The ROW function tells you what row you are in. MOD Examples: =MOD(72) will return 1."
YouTube Link 2022-07-05T13:00Z 94.6K followers, 82K engagements

"Add Timers in Microsoft Teams Meetings Microsoft Teams is introducing an exciting new feature in July [----] that will revolutionize how you manage your meetings: Teams Meetings TIMERS. This countdown timer feature is designed to help you keep meetings on track by visually displaying the remaining time for each segment or speaker. Whether youre running a scheduled meeting or an impromptu session this tool enables seamless time management that everyone in the meeting can see and interact with. In this article we'll explore how to use this feature practical examples of its implementation and why"
YouTube Link 2025-06-27T13:23Z 92.9K followers, [----] engagements

"SyncBack Free for easy backup by Chris Menard SyncBack is a great program for backing up files to USB or external hard drives. The free version for home users is shown in this video but the steps shown are used in all the versions of SyncBack for setting up your backup. What you need to do: 1) Create a profile (takes [--] seconds) 2) Pick source and destination (takes [--] seconds) 3) Make a schedule. (30 seconds) That's it Your files are automatically backed up. No more worrying about losing files if your computer crashes or if you want to take a backup with you just unplugged your external"
YouTube Link 2015-03-20T16:36Z 94.8K followers, 12.7K engagements

"Branching and sections in Microsoft Forms by Chris Menard Branching or skip logic also called conditional questioning is easy to add to a survey in MS Forms. Branching is used to send someone to a specific question based on the previous question's answer. Examples of branching are a doctor's office asking if you are a new patient If yes you have more questions than if you picked no. Another medical example is the questions are you male or female For a class survey the question "Do you want to be notified of future classes" YES you send them to a question to get their email address. Picking NO"
YouTube Link 2020-02-17T15:46Z 93K followers, 139K engagements

"Excel People Graph and two PivotTable tips by Chris Menard You can delete the data worksheet from an Excel file and still manipulate your PivotTables that are based on that worksheet. This will reduce your file size. Also you can pull the data back up from inside the PivotTable. Another tip is this video. We are often looking at data by customer employee vendor and state. Use the People Graph from Microsoft to make cool charts that Excel by default can't make. The People Graph is free under Insert Add-Ins. http://chrismenardtraining.com https://chrismenardtraining.teachable.com/p/excel-tables"
YouTube Link 2018-01-16T22:30Z 93.1K followers, [----] engagements

"OneDrive - Sync Icons Explained for files and folders OneDrive is great for syncing your files. OneDrive has a great feature called Files on Demand. Your files on your computer could have three possible status icons with Files on Demand running. These icons appear when you are in File Explorer. I'll explain the three OneDrive sync icons and determine the local hard drive space used on your computer from OneDrive. We will look at how to free up hard drive space used by OneDrive. The OneDrive Files on Demand sync icons are easy to understand. You have three icons for your files and folders. The"
YouTube Link 2021-03-09T14:17Z 94.5K followers, 273.1K engagements

"Redact sensitive information with Adobe Acrobat [--] by Chris Menard You can redact confidential information or Protected Health Information with Adobe Acrobat [--] Pro. I have another video of redacting information with Foxit Phantom PDF. www.chrismenardtraining.com And make sure you subscribe to my channel -- EQUIPMENT USED --------------------------------- My camera https://amzn.to/3vdgF5E Microphone - https://amzn.to/3gphDXh Camera tripod https://amzn.to/3veN6Rg Studio lights - https://amzn.to/3vaxyy5 Dual monitor mount stand - https://amzn.to/3vbZSjJ Web camera https://amzn.to/2Tg75Sn Shock"
YouTube Link 2016-12-01T21:25Z 92.6K followers, [----] engagements

"Excel Right-Click Secrets: [--] Shortcuts You Need to Know In this tutorial I show you [--] powerful right-click techniques in Excel that will speed up your workflow. You'll learn how to move columns without inserting or deleting filter by cell color and value with one click auto-fill weekdays only (skipping weekends) control formatting when inserting rows and instantly convert formulas to values. These right-click shortcuts work in Excel [---] Excel [----] Excel [----] and earlier versions. I recorded this during EA Ignite in Nashville while preparing for a Copilot training session. My courses are"
YouTube Link 2025-11-05T14:56Z 92.8K followers, [----] engagements

"OneDrive Add Multiple Accounts - OneDrive Personal and OneDrive for Work or School Microsoft OneDrive comes in two flavors. OneDrive Personal or Home. If you have a M365 personal or home account subscription or the free OneDrive you have this OneDrive. The other OneDrive account is OneDrive for Work or School (formerly called OneDrive for Business). It is possible to run both on one computer. My OneDrive Personal is a white cloud in the system tray and my OneDrive for Work or School is a blue cloud. Chapters 0:00 Intro 0:35 Settings Add Account 2:25 Automatic backup message OneDrive"
YouTube Link 2023-11-28T14:00Z 92K followers, 55.2K engagements

"Smarter Way to Link Excel Tables (Without XLOOKUP or VLOOKUP or Duplicates) Here is a powerful alternative to VLOOKUP and XLOOKUP in Excel by utilizing Excel's Data Models. I'll walk you through importing data from one sheet to another using a customer worksheet and an orders worksheet. We'll set up relationships between tables to maintain a lightweight file and I'll demonstrate how to create effective PivotTables with multiple linked tables. Learn how to optimize your data management in Excel. Check out my courses on Excel OneNote Copilot and Teams: https://courses.chrismenardtraining.com"
YouTube Link 2025-10-09T14:12Z 92.7K followers, 35.1K engagements

"Excel: extract email addresses from data by Chris Menard There are three methods to exact emails from data in Excel. After extracting the email you can use two methods to add a comma between the email address so you upload to your LMS or other systems. TimeStamps 00:00 Intro 01:00 Mid and Find Function - Method [--] 01:45 Flash Fill - Method [--] 02:37 Text to Columns - Method [--] 03:20 CTRL + H to lose closed angle bracket on Method [--] 04:05 Add commas with a 3D reference 05:30 TEXTJOIN function in Excel Websites: http://chrismenardtraining.com/ https://chrismenardtraining.teachable.com - online"
YouTube Link 2018-02-25T15:43Z 93.4K followers, 194.4K engagements

"Speed Up Data Entry with Excel Data Validation Lists In today's fast-paced work environment efficiency and accuracy in data entry can significantly impact productivity. The Data Validation List feature is one of the best tools for achieving this in Excel. This guide will walk you through the process of setting up and using Data Validation Lists to streamline your data entry tasks in Microsoft Excel. 00:00 Introduction to Data Validation Lists in Excel 00:24 Setting Up Your Data Validation List 01:30 Creating and Using the Data Validation List 02:44 Advanced Tips for Data Validation 03:15"
YouTube Link 2025-01-08T15:00Z 93.4K followers, [----] engagements

"Excel Copilot: App Skills & Use Voice Prompts In this tutorial I show you how to properly access Copilot's App Skills in Excel and use voice commands to work faster with your data. If you've clicked the Copilot icon and gotten a task pane that doesn't look right you're not alone. I'll walk you through accessing the correct Copilot interface by using the dropdown menu to select App Skills instead of the default chat option. I'll also demonstrate how to use Copilot's microphone feature to create prompts without typing. In this example I extract month names from invoice dates using natural"
YouTube Link 2025-10-16T13:55Z 93.2K followers, [----] engagements

Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing