Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
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
Import events to Google Calendar You can transfer your events in Microsoft Excel to a Google Calendar. This will save you the time of retyping all the events. Steps to save Excel as a CSV (Export) Prior to saving an Excel file as a CSV, make certain you only have
Microsoft PowerPoint
Inserting a 3D Model on a slide from Online Sources 1. Click the **Insert** tab, click **3D Models** in the Illustration group, and click **From Online Sources**. 2. After the 3D models load, select **All Animated Models** or any of the groups with a Runner icon showing. 3. Select one
Microsoft Excel
It is tempting to use merge and center in Excel. It stands out when you open Excel. Avoid merge and center. Three reasons why merge and center is evil: 1. Data with Merge and Center can't be sorted. 2. Remove Duplicates, another great Excel feature, doesn't
Microsoft Excel
Many Excel files are not set up properly. Data that should be in a flat file is laid out in a crosstab file format, or in this example, the data is missing information and has totals manually applied. The issue with data being set up incorrectly is the following can’
Microsoft Word
Microsoft Word has rules for Mail Merge. One of the rules we will look at today is the If…Then…Else statement. It is actually really simple to use. If one condition is met, do one thing, if the condition is not met, do something else. It is similar to
Microsoft Excel
Create a Sunburst Chart in Excel by Chris Menard - YouTube The sunburst chart or multi-level pie chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. A sunburst chart without
Microsoft Excel
Excel group numbers and IFS and FormulaText functions Two new Excel 2016 Functions **IFS** - The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements and is much
Tools
Are you ready to learn Microsoft Sway? Join Chris Menard and Cristian Cotovan on 2/28/2018 at 2 PM ET for a free 30-minute webinar on Microsoft Sway. What can you do with Microsoft Sway? **Use Sway to show:** - new hires - vacation photos - employee spotlight -
Microsoft Excel
Excel - use the Median function in a PivotTable by Chris Menard - YouTube PivotTables do not allow median function. We will create a helper column and use an array function to calculate the median in a PivotTable. Also shown are average, median, averageif, if statement with the median function.
Microsoft Excel
Bill in Smyrna, GA wants to show percentage in a PivotTable and filter the PT. That is easy. The issue is Bill wants to show the unfiltered percentages, not the filtered percentages. I had to add a helper column to do this. PivotTable Percentages - Show unfiltered percentage when filtering