Microsoft Office Blog by Chris Menard

Create a data validation drop down list in Excel by Chris Menard

You can make a drop down list so only correct data is entered. If bad data is entered, sorting, filtering, pivottables, and other stuff will be incorrect.

Use absolute reference in Excel to keep a cell constant when you copy or autofill

If you need a cell to stay constant, you can make it an absolute reference cell to stay constant. Press the F4 function key to create an absolute reference.

Create your own custom sort in Excel

Excel already has built-in custom lists for sorting, but you can create your own custom sort list in case you don't want to sort alphabetically or A to Z.

Word - make headings 1 always show on a new page using Page break before setting

In a long Word document, it is often desirable to have Heading 1 styles show at the top of a new page and never have two headings 1 on the same page.

Delay or schedule sending email messages in Microsoft Outlook

When you click Send on an email, it is typically sent immediately, but you can have it sent at a later time by using delayed delivery in Outlook.

Create canned responses in Microsoft Outlook by using Quick Parts

Do find yourself typing the same message over and over in Microsoft Outlook? You can use Quick Parts in Outlook to create canned responses to emails.

Create a combo or two-axis chart in Excel 2016 by Chris Menard

If you are trying to chart values in Excel that are far apart numerically, you need to create a combo chart in Excel. It is very easy in Excel 2016.

How to calculate the weighted average in Excel

Need to calculate the weighted average in Excel? It is very easy if you use the sumproduct function in Excel. This is useful for school or work.

Import csv file with recurring or repeating events into Google Calendar

Need to import recurring or repeating events from a csv file into a Google Calendar? Here are the steps with a YouTube video.

Click and type anywhere in Microsoft Word

In Microsoft Word, you can double click and start typing anywhere. By clicking and typing anywhere you can use insert images and pictures anywhere.

Create a treemap in Excel to spot patterns

A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers.

Resize all images in PowerPoint

To reduce your PowerPoint file size, you should compress your images. You can compress all the images at one time by using Compress