Microsoft Office Blog by Chris Menard

Excel - Combine Multiple Tables - Relationships (PivotTables) and XLOOKUP

You can set up a relationship with two or more tables in Excel to create a PivotTable. XLOOKUP and VLOOOKUP also work, but you can skip those great functions and set up Relationships. For example, one Excel table contains the Employee ID and name.

NEW Teams - Two New Features - October 2023

Teams see new posts at bottom and pop-out conversations - two new features in Teams 2.0.

Excel PivotTable - Table VS. Range as source - Which is better?

In Excel, a PivotTable can be based on a Range or on a Table. I encourage you to base your PivotTable on a Table. Initially, both a range and table will be correct.

Excel - IF Function using AND and OR

One of my favorite functions is the IF function. The IF function allows you to use true and false conditions. For example, if the value in cell B2 is over $5,000, give them a 2% discount.

Excel - Advanced Filters

Excel filters are great for seeing just a subset of your data. You can use filters for text, numbers, and dates, but also by color. You can use font color or fill color (the paint can). You can also use Advanced Filters. You Advanced Filters when you are looking at multiple fields but for different criteria. For example, I want to filter and only see people in Georgia and New York. That is easy to do and can be done with the drop-down filter. But, for Georgia, I want to see people who are Single, and for New York, I want to see Family. That requires an Advanced Filter.

November 6-8, 2023 - EA Ignite Conference in Austin, TX

I will present at the EA Ignite Spring Conference in Austin, TX, on November 6 through 8, 2023. Session 1 - Microsoft Teams 2.0: What's New and What it Means to You. Session 2 - Microsoft's AI Tools: How Technology Works for You.

Excel Business Functions - Functions everyone should know - Excel Essentials Training

Did you know that there are over 500 Functions in Excel? In this short video, part of my Excel Essentials Training Course, we look at the seven business functions I use all the time, and these functions should be used by every Excel user.

Styles in Tables and PivotTables and Grand Total Calculation - Excel

When you create a Table or PivotTable in Excel, you can work with Styles. There are three style groups - Light, Medium, and Dark. Within each group are multiple styles.

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!