Microsoft Office Blog by Chris Menard

Social Security - Breakeven point in Years using Excel

Calculate SSA breakeven in years. The break-even point represents when the cumulative benefits even out. Comparing 62 to 67, you have been collecting money for 60 months.

Teams Meetings - Move Presenter Toolbar When Sharing

Move the Presenter toolbar when sharing your screen in a Teams Meeting.

NEW feature: Teams - Send Individual Channel Meeting Invites to Members

Teams Channel Meetings - Send Invites to members - Now, in meetings for channel members, you can control when users get emails with the meeting invite.

Dictate in Teams: Voice-to-Text for Chat Messages

I share a valuable tip for Microsoft Teams users who want to use voice-to-text for chatting and creating channel posts. This feature isn't available by default in Teams, but I demonstrate how it can be easily enabled on Windows 11 and mention its compatibility with Windows 10.

Oct 28, 2024 - I'll be Speaking at the Administrative Professionals Conference on Excel Copilot: Data Analysis Simplified

I'll be speaking at ASAP's Administrative Professional Conference in Aurora, CO on October 28, 2024. My deep dive session will be on Excel Copilot: Data Analysis Simplified

Sep 28, 2024 - Excel Training for Executive MBA Students at the University of Georgia

I'll be speaking on September 28,2024 to the Executive MBA students from The University Of Georgia's Terry College of Business. We will cover many Excel topics including Financial Analysis in Excel.

Creating a Column Chart using S&P 500 data with Positive and Negative Colors in Excel

Imagine a scenario where you're analyzing the S&P 500 index's performance over several years. You'll likely encounter both positive and negative percentage changes. Distinguishing between these with just numbers can be dry and difficult to grasp immediately.

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Excel has always been a powerhouse for managing data, and with the introduction of Copilot, it's become even more powerful. Copilot

Five Methods for Creating Running Totals in Excel

Excel is a powerful tool that offers various features to manipulate and analyze data efficiently. One of the useful functionalities it provides is the ability to create running totals, which can be essential for tracking cumulative sums over a period.

Removing Duplicates Using Power Query

We're going to take a look at removing duplicates using Power Query in Excel.

The 4 Percent Rule: Using Microsoft Excel to Plan for Retirement

Exploring the 4 percent rule through Microsoft Excel provides a hands-on approach to understanding how it might apply to your retirement planning.

Optimizing Microsoft Excel Files for Better Performance

Excel has a new feature called Check Performance. Check Performance will determine if your workbook is slow and optimize performance.