Chris Menard is a Microsoft MVP. He is certified in Excel, Word, Outlook, and PowerPoint. His YouTube videos have over 25 million views.
Microsoft Word
If you want your Heading 1 paragraphs to start at the top of the next page, you can accomplish this with a page break, but a better option would be to use Word’s paragraph feature to do this. 1. Right-click your **Heading 1** style and select **Modify**. 2.
Microsoft Outlook
You can delay the delivery of an email message and have the message held in the **Outbox** for a specified time after you click **Send**. Delayed Delivery is a great feature if you are emailing out proposals or doing an email campaign. Applies to: Outlook 2016, Outlook 2013, Outlook 2010,
Microsoft Outlook
Do find yourself typing the same message over and over, perhaps a weekly reminder for projects, progress reports, or your availability? Outlook Quick Parts can help you with your Canned Responses. Set up a canned response in Outlook 1. Start a new mail message in Outlook. 2. Click in the
Microsoft Excel
When the numbers in your Excel file vary widely from data series to data series and you want to create a chart, the chart to create is a **Combo** chart. You would also use a combo chart when you have mixed types of data (for example, revenue and net income
Microsoft Excel
Need to calculate the weighted average for work or school? There are two ways to do it but the easiest is to use the sumproduct function in Excel. It is easy to calculate the average. Just use the average function in MS Excel which will show you the calculated “central”
Microsoft Excel
You can’t import recurring or repeating events into the Google Calendar. Here is a workaround I use so you can pull in the recurring events. The top row of your csv file should contain the fields needed to import into Google Calendar. I added a field called Recurring and
Microsoft Word
Microsoft Word has a feature that is rarely used but is very helpful. It is double click and type. Just double-click anywhere in the document and your insertion point (the cursor) will be placed exactly at that place. I use this all the time to add videos or images
Microsoft PowerPoint
Are you the person that has a 75MB PowerPoint? The reason most PowerPoint presentations get too large in size is due to images. The good news is you can batch compress all your images at once. So if you have 100 slides with an image on every slide, you can
Microsoft Excel
Need to apply conditional formatting to groups of data? It can be done, you need to sort and have a “helper” column. This short video demonstrates how to add a helper column and use an IF statement and then you the ISODD or ISEVEN function statement with conditional formatting. Video
**Irfanview** is a free popular free image viewer and has a batch processing feature. One of the batch processing features allows you to resize all your large images at one time. Another feature I came across is the ability to change JPG images into PDF files. Why would you want
Microsoft Excel
To protect a worksheet 1. Select the cells you want to users to change. 2. On the Home tab, in the Alignment group, choose the small arrow to open the Format Cells dialog box or right click and select Format Cells. 3. The Format Cells dialog box launcher opens. On
Microsoft Excel
Icon Sets in Excel Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. For example, a three-icon set uses one