Microsoft Office Blog by Chris Menard

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.

EA Ignite Fall 2023 - San Antonio TX - Chris Menard - Two Sessions

Chris Menard will present two sessions at EA Ignite in November 2023. Menard's sessions are Microsoft's AI Tools: How Technology Works for You and Microsoft Teams 2.0: What's New and What it Means for You

Excel - Financial Functions for a House or a Car

Excel has a lot of Financial Functions. We will look at several functions for a home purchase or a car purchase.

Excel Print Options - Set Print Area, Print Selection, Margins, and Printing Gridlines

Excel has many print options. We will look at setting the Print Area, Print Selection, working with Margins, Printing Gridlines, and Printing Row and Column headings. This is part of my Excel Essentials training course, available in July 2023!

Excel Page Break Preview and Inserting Page Breaks - Excel Essentials

Excel has three views in the status bar - Normal, Page Layout, and Page Break Preview. We will look at using Page Break Preview to move and lose page breaks and using the Insert Tab to Insert Page Breaks and Reset All Page Breaks. These commands are part of my Excel Essentials Course.

Excel - Copy and Move Data - Excel Essentials

Part of Excel Essentials is moving and copying data. There are multiple ways to move and copy, and I included a few tips in this video.

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.