Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
I'm excited to share two powerful functions in Microsoft Excel 365 that will make combining data ranges a breeze: VSTACK and HSTACK. These dynamic array functions allow you to efficiently merge data vertically and horizontally. Let me walk you through how to use them. Understanding VSTACK Function VSTACK
Microsoft Excel
Understanding mortgage rates is crucial for anyone looking to buy a home or refinance their existing mortgage. In this comprehensive analysis, we'll dive deep into over 50 years of mortgage rate data using Microsoft Excel. We'll explore historical trends, calculate key statistics, and examine how changes
Microsoft Outlook
As someone who's always looking for ways to streamline my workflow, I was thrilled to discover a fantastic new feature in Microsoft Outlook: scheduling meetings with Copilot. This AI-powered tool is revolutionizing how we manage our inboxes and organize meetings. Let me walk you through my experience with
Microsoft Excel
I have a fabulous topic for you today: Conditional Formatting with Complex Functions using Copilot in Excel. This feature is something I've been eagerly awaiting since Copilot was released in November 2023. Now, I can utilize conditional formatting with complex functions in Copilot. In this example, I want
Microsoft Excel
Welcome to our guide on how to separate date and time in Excel. In this blog, we will explore two dynamic methods to achieve this: using the Integer function and employing Power Query. These methods are perfect for analyzing data trends such as popular class times or customer purchase times.
Microsoft OneDrive
Copilot in OneDrive is here, and it promises to revolutionize how we interact with documents. With features like summarizing documents, creating FAQs, and asking questions about document content, Copilot offers a powerful toolset for enhancing productivity and efficiency. Copilot for M365 users can now access its powerful features in Microsoft
Microsoft Excel
Excel offers powerful features for data analysis, including the ability to pull data from web sources. One common task is importing the list of S&P 500 companies. This guide will demonstrate how to import this data from Wikipedia and utilize Excel's Stock Data Type for further
Microsoft Excel
Excel is a powerful tool that can significantly enhance productivity when used effectively. As users transition from beginners to more advanced levels, certain functions and shortcuts become essential. Here, we present seven time-saving Excel tips that will help you work more efficiently. Tip 1: Moving Columns Moving columns in Excel
Microsoft Excel
Copilot in Excel has introduced some exciting new features that are designed to enhance your productivity. These updates might seem minor or major depending on your workflow. Let's dive into these new capabilities and see how they can streamline your Excel tasks. Setting Up Your Data In the
Microsoft Forms
Creating surveys can be a daunting task, especially when you aim to gather insightful responses efficiently. With the introduction of Copilot in Microsoft Forms, the process becomes streamlined and intuitive. In this guide, we'll explore how to use this powerful tool to create professional surveys effortlessly. Getting Started
Microsoft Word
Microsoft Word for the web has introduced some fantastic new features for editing tables. These enhancements are perfect for anyone who frequently uses tables in their documents. Let's dive into these new capabilities and see how they can improve your workflow. Reordering Columns One of the most exciting
Microsoft Teams
If you're a Microsoft Teams user with Copilot, exciting new features have been rolled out. You can now manage who has access to meeting recordings, transcriptions, and AI-generated insights as the meeting organizer. This enhances security and privacy in your Teams meetings. In this article, we will explore