Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Excel
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. Excel 3D reference You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count,
Microsoft Excel
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. Middle class calculator The starting point is the median
Microsoft Word
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. **Word to Adobe Acrobat** it is easy to make bookmarks in the
Microsoft Excel
**Cost-Volume-Profit (CVP)** analysis provides insights into how variations in both variable and fixed costs impact a company’s profitability. By examining the relationships between sales volume, costs, and revenue, CVP analysis helps organizations make informed decisions about pricing, production levels, and overall financial performance. The **Contribution Margin** is a company&
Microsoft Outlook
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
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. **Teams Avatars** In addition, avatar “reactions” are available during meetings to allow the avatar to
Microsoft Excel
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 Left and Find Function** For example, the product
Microsoft Excel
Excel has three cell references - Relative, Absolute, and Mixed. It is critical to understand when to use each reference in Excel. Excel References - Relative, Absolute, and Mixed The default reference is relative is used frequently in Excel. The next highly used reference is absolute. Finally, we have two
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. Popular Excel Articles Excel Charts - three methods for filtering
Microsoft Teams
The new Microsoft Teams is coming soon! Teams is getting completely overhauled. The new Teams preview is now available for Windows desktop users. It will come soon to Mac users and Teams on the web. Microsoft Teams came out in 2017. Today, over 280 million people use Teams monthly. Switching
Microsoft Excel
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). You can type questions, and Excel will return results in a PivotTable format.
Microsoft Excel
After sorting in Excel, we will look at two great methods for separating blocks of data or showing a clean separator between our groups. Break between groups in Excel A group may be departments, states, countries, or cities. We will use the Subtotal command, and Page Breaks between Groups for