Microsoft Office Blog by Chris Menard

Easily Combine Ranges with VSTACK and HSTACK in Excel

VSTACK and HSTACK are two great functions in Excel. We will use them to combine ranges.

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

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 in interest rates impact monthly payments.

Copilot in Excel: Conditional Formatting with Complex Functions

Copilot in Excel now supports Conditional Formatting with Formulas. This is an awesome feature. For example, Copilot can highlight an entire row where the State is Georgia and the city is Atlanta.

2 Methods to Separate Date and Time in 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 (INT) function and employing Power Query.

Copilot in OneDrive: Revolutionizing Document Interaction

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.

How to Import S&P 500 Data into Excel and Utilize Excel's Stock Data Type

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

Excel 7 Easy Tips Everyone Should Know

Excel is a powerful tool that can significantly enhance productivity when used effectively. Here, we present seven time-saving Excel tips that will help you work more efficiently.

Copilot In Excel: NEW Feature Enables Copilot Use Without a Table

Copilot in Excel has introduced some exciting new features that are designed to enhance your productivity. Copilot in Excel handles sorting, conditional formatting, pivottables, and asking questions. You can now do this without having a Table.

Copilot in MS Forms: Creating Efficient and Insightful Surveys

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.

New Feature - Word for the Web: Edit Tables with Ease

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.

August 22, 2024 - Microsoft Copilot: Navigating the Future of Productivity - Southeastern Accounting Show

August 22, 2024 - I will present at the Southeastern Accounting Show in Atlanta, GA. My second session will be Microsoft Copilot: Navigating the Future of Productivity. The SEAS is hosted by the Georgia Society of CPAs.

Copilot in Teams Control Access: Manage Recordings, Transcriptions & AI Insights

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.