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
We frequently look at quarterly data. If you want to calculate the fiscal quarter from a date, possibly an invoice date or an order date, and the fiscal quarter starts in a month other than January, use the CHOOSE function. For instance, if the fiscal year is from July to
Microsoft Teams
Channel Calendars are now available in Teams. With Channels having their calendar, it makes it easy for Teams members to see upcoming channel meetings all in one place quickly. Before the calendar, members had to look through the Post tab to find meetings. With the calendar, all channel meetings are
Microsoft Excel
Caution should be used when averaging percentages. As an example, we asked 500 kids and 4500 adults if they like Trix cereal. The kids, 98%, liked Trix cereal. The adults, 42%. Add 98% and 42% and you get 140%. Divide by 2 and that is 70%. (98+42=140 / 2
SnagIt
Applies to: Snagit 2019 and Snagit 2018 One of the best features of Snagit is the ability to capture text that is not selectable. Examples of items where **Grab Text** comes in handy include: 1. text on images 2. error messages 3. dialog boxes 4. folders in Windows How to
Microsoft Excel
A data table is a range of cells in which you can change values in some in some of the cells and come up with different answers to a problem. Types of What-if analysis in Excel There are three types of what-if analysis tools in Excel: 1. scenarios
Microsoft Excel
Posted on: 12/19/2018 Use the UNIQUE function to return a unique list from a range or array of items. The results will automatically "spill" into an adjacent range of the appropriate size when you press Enter. The UNIQUE function works on text and numbers. With the
Microsoft Excel
One of the most powerful functions in Excel is the COUNTIF function. The COUNTIF function in Excel counts the number of cells that meet criteria you specify. Several examples of when to use COUNTIF: - How many employees work in the accounting department? - How many customers are in Georgia? - How many
Microsoft Excel
A loan amortization schedule also called a loan amortization table, is a table that illustrates the process of paying off a loan. The amortization table will show every payment and the details for that payment. How much principal and interest are paid in any particular payment. There are usually seven
Microsoft Excel
Overview of COUNTIF The COUNTIF function is used to find cells that meet certain criteria. COUNTIF function works with dates, numbers, and text. The COUNTIF function has two arguments. For example: - =COUNTIF(A2:A11,"Atlanta") Will count the city of Atlanta. - =COUNTIF(A2:A11,"<>Atlanta&
Microsoft Outlook
A new feature in Outlook 2016 with an Office 365 subscription allows you to add buffer time between appointments and meetings. This is an awesome new feature. You can use that time to check in with your team, get coffee, and answer critical emails. November 2018 was the release date
Paint.net
To make an image a specific width and height, say 200 x 150, you can use a free program called [Paint.Net](http://getpaint.net/). Paint.Net will allow you to crop the image and use a **fixed ratio**. This is handy for profile pictures. Google may require 1000 x
By default Gmail only has one signature for new emails and you can use the same signature for replies. Do you want to use multiple signatures? You can by turning on canned responses in Gmail. We will use canned responses to have multiple signatures. Canned responses allow you to create