Microsoft Office Blog by Chris Menard

Excel - Getting Started with Autofill - MUST KNOW FEATURE

Using AutoFill in Excel is one of Excel's most used features. To be proficient in Excel, you need to master AutoFill. In this video, we will look at using Autofill with Series, Columns, Number Patterns, Dates, and Text.

Excel Essential Skills - Rows & Columns and the EVIL Merge and Center

Excel Essential Skills you should know include AutoFit, Absolute Reference, Inserting and Deleting Rows and Columns, and why not to use Merge and Center.

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

What is the Middle Class and Are You in the Middle Class?

What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live.

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Breakeven Analysis - Breakeven in Units and Breakeven in Sales

The Contribution Margin is a company's revenue minus its variable cost. You can use the Contribution Margin to find the Breakeven Point.

Outlook on the web - 3 Calendar features the desktop version doesn't have

Outlook on the web has many 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.

Microsoft Teams - Create and Customize Avatars

Microsoft Teams is rolling out mesh (3D) Avatars. You can customize your avatar. Avatars are not static. When testing, my avatar reacted to audio and moved from time to time to provide some visual interest.

Excel - 3 Cool methods to extract text from the beginning of a text string

We frequently need to extract part of a text string in Microsoft Excel. We are going to extract the first part of a text string. Examples of text string parts you would extract include product numbers, employee IDs, and accounting numbers.

Excel - switch between relative, absolute, and mixed references

Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel.

Artificial Intelligence (AI) in Microsoft 365

Artificial Intelligence (AI) is in all Microsoft 365 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.

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